Question: a ) You are tasked with designing a conceptual schema for a corporate database system. The system is required to record details about its employees,
a You are tasked with designing a conceptual schema for a corporate database system.
The system is required to record details about its employees, the organizational units they
belong to and their immediate family details as follows:
Employees: Each employee must be uniquely identifiable by an Employee ID EID and
associated with specific details such as salary and contact number.
Departments: Departments within the company should be distinctly recognized by a
Department ID DID and should include a department name dname and allocated
budget.
Employee's Children: For the employees' children, the database should store their names
and ages.
Additional requirements include:
An employee is associated with departments.
Each department has one employee who acts as its manager.
Children are uniquely identified by their name given the employee parent is known.
The children's data is relevant only as long as the employee parent is employed by the
company
b Using the information above, create an EntityRelationship ER diagram that accurately
displays these requirements. Ensure that your diagram specifies all necessary entities,
relationships, and constraints as described.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
