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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!