Given the following Schema Employee (empNo, fName, mName, lName, address, DOB, extension, position, deptNo)Department (deptNo, deptName, building, office, mgrEmpNo)Project (projNo, projName, deptNo)WorksOn (empNo, projNo, dateWorked, hoursWorked)Where:Employee contains employee details and empNo is its primary key.Department contains department details and deptNo is its primary key.mgrEmpNo identifies the employee who is the manager of the department. There is only one manager for each department.Project contains details of the projects in each department and its primary key is projNo (no twodepartments can run the same project).WorksOn contains details of the hours worked by employees on each project, andempNo/projNo/dateWorked form the key.Draw the E-R diagram (in UML notation) that matches this schema his schema.
Given the following Schema
Employee (empNo, fName, mName, lName, address, DOB, extension, position, deptNo)
Department (deptNo, deptName, building, office, mgrEmpNo)
Project (projNo, projName, deptNo)
WorksOn (empNo, projNo, dateWorked, hoursWorked)
Where:
Employee contains employee details and empNo is its primary key.
Department contains department details and deptNo is its primary key.
mgrEmpNo identifies the employee who is the manager of the department. There is only one manager for each department.
Project contains details of the projects in each department and its primary key is projNo (no two
departments can run the same project).
WorksOn contains details of the hours worked by employees on each project, and
empNo/projNo/dateWorked form the key.
Draw the E-R diagram (in UML notation) that matches this schema his schema.
Step by step
Solved in 2 steps with 1 images
