SOLVED CS312 Assignment 2 Solution and Discussion

[zareen]

Assignment No. 02

Semester: Fall 2019
CS312: Data Base Modeling and Design Total Marks: 20

Due Date:
December 10, 2019

Instructions:

Please read the following instructions carefully before submitting assignment. It should be clear that your assignment will not get any credit if:

• The assignment is submitted after due date.
• The submitted assignment does not open or file is corrupt.
• Assignment is copied (partial or full) from any source (websites, forums, students, etc.)

Note: You have to upload only .doc or .docx file. Assignment in any other format (extension) will not be accepted and will be awarded with zero marks.

Objectives:
The objectives of this assignment are,
• Know basics of Requirement specification to ER modeling
• Basics of developing Database by designing ERD

For any query about the assignment, contact at [email protected]

Assignment 2
TASK to perform

In continuation of assignment 1 of CS312, you have to identify and design following;

Task:

By using system requirements in assignment 1, you are required to identify Entities in the University Certificates system and use identified entities to draw ER diagram along with assumed attributes and cardinalities between entities.

Best of Luck!

[zareen]

Solution:

[Asad Office account]

Project Specifications / System Requirements

Suppose ABC organization has decided to automate process of leave management of its employees. Leaves can be of different types: Short, Half, and Full. Leaves’ description can be: Casual, Earned, Medical, and Extra-ordinary leaves. Employees will have to do registration and create their account.
In order to apply for leave, employees first have to login their account using their login credentials i.e., user name and password. After successful login, they can apply for leave using “Apply Leave” interface. They will select leave type, leave description, leave date and time. The employees will also provide reason of leave. After leave is successfully applied, leave request will be forwarded to the manager and applied leave will either be accepted or rejected. The interface will show total, availed and remaining balance of leaves. Furthermore, the interface of “Leave History” will show details of all applied leaves such as Leave Type, Leave Description, Date, Time, Reason, and Leave Status. Admin will manage employees’ accounts, leave balance, update leave status. Admin will also manage leave history of all employees.

Tasks to Perform

You have to identify following from the above given Project Specification / Requirements:

1. Identify User Characteristics or type of users.
2. Identify at least Seven Functional Requirements.

[zareen]

Solution: