logo

Normalization Assignment for CS-630 Database Systems

   

Added on  2019-09-25

11 Pages561 Words76 Views
CS-630 Database SystemsNormalization AssignmentGIVEN TABLE:EmpIdEmpNameHireDatePositionIdPositionDescDeptIdDeptNameDependentIdDependentDOBDependentRelation101Juan Rivera12/02/20001President10Corporate105/10/1970SpouseJuan Rivera12/02/20001President10Corporate201/14/2000SonJuan Rivera12/02/20001President10Corporate301/14/2000Daughter102Mike West04/15/20102Controller20Budgeting111/11/1985SpouseMike West04/15/20102Controller20Budgeting210/11/2012Son103Gita Phogat10/10/20103Staff30Finance103/06/2013SonGita Phogat10/10/20103Staff30Finance207/11/2015Daughter104Mary Lamb01/31/20173Staff40IT109/09/1990Spouse

1stNF: EmpId(PK)EmpNameHireDatePositionId(PK)PositionDescDeptId(PK)DeptNameDependentIdDependentDOBDependentRelation101Juan Rivera12/02/20001President10Corporate105/10/1970SpouseJuan Rivera12/02/20001President10Corporate201/14/2000Son101101Juan Rivera12/02/20001President10Corporate301/14/2000Daughter102Mike West04/15/20102Controller20Budgeting111/11/1985Spouse102Mike West04/15/20102Controller20Budgeting210/11/2012Son103Gita Phogat10/10/20103Staff30Finance103/06/2013Son103Gita Phogat10/10/20103Staff30Finance207/11/2015Daughter104Mary Lamb01/31/20173Staff40IT109/09/1990Spouse

Dependency Diagram:

2nd NF:Table: EMPLOYEE_DETAILSEmpId(PK)EmpNameHireDatePositionId(PK)DeptId(PK)DependentIdDependentDOBDependentRelation101Juan Rivera12/02/2000110105/10/1970SpouseJuan Rivera12/02/2000110201/14/2000Son101101Juan Rivera12/02/2000110301/14/2000Daughter102Mike West04/15/2010220111/11/1985Spouse102Mike West04/15/2010220210/11/2012Son103Gita Phogat10/10/2010330103/06/2013Son103Gita Phogat10/10/2010330207/11/2015Daughter104Mary Lamb01/31/2017340109/09/1990Spouse

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
The create table employee
|4
|894
|17

Data modelling and data base design
|23
|1376
|15

Data Modelling & Database Design tasks 2022
|10
|1825
|14