Employee (emplD, fName, lName, address, DOB, sex, position, deptNo*)
Department (deptNo, deptName, mgrEmplD*)
Project (projNo, projName, deptNo*)
WorksOn (emplD* projNo*, hoursWorked)
where Employee contains employee details and emplD is the key.
Department contains department details and deptNo is the key.
mgrEmplD identifies the employee who is the manger of
the department. There is only one manger for each department.
Project contains details of the projects in each department and the key is projNo.
and WorksOn contains details of the hours worked by employees on each project, and emplD/projNo form the key.