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
![Normalization Assignment_1](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2F6a8ee5cf6eb641278736cce39412b283.jpg&w=3840&q=10)
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
![Normalization Assignment_2](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2F422445dc7a95417a8dfc93990f1a7dd9.jpg&w=3840&q=10)
Dependency Diagram:
![Normalization Assignment_3](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2F4e54e72bcb3a47b99454673b4089fe8c.jpg&w=3840&q=10)
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
![Normalization Assignment_4](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2Ffba23fda587246cc9bf1953a287a77b3.jpg&w=3840&q=10)
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents