Empid Empname Empphone Deptname Deptphone Deptmgrname Skillid Skillname Skilldate Skilllev Q26823867
emp_id |
emp_name |
emp_phone |
dept_name |
dept_phone |
dept_mgrname |
skill_id |
skill_name |
skill_date |
skill_level |
Refer to Figure 3-19. Use the process defined in Figure 3-19 toput the Employees table into BCNF. Document each step you take byreferring to the appropriate step in Figure 3-19.
Here is Figure 3-19
Process for Putting a Relation into BCNF: |
Identify all functional dependencies in the relation |
Identify every candidate key in the relation. |
If there is a functional dependency that has a determinant thatis not a candidate key: Move the columns of the functional dependency of the determinantthat is not a candidate key to a new relation. Make the determinant of that functional dependency the primarykey of the new relation. Leave a copy of the determinant in the original relation as aforeign key. Create a referential integrity constraint between therelations. |
Repeat step 3 until every determinant of every relation is acandidate key |