Normalization Assignment
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