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 to put the Employees table into BCNF. Document each step you take by referring 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 that is not a candidate key:

Move the columns of the functional dependency of the determinant that is not a candidate key to a new relation.

Make the determinant of that functional dependency the primary key of the new relation.

Leave a copy of the determinant in the original relation as a foreign key.

Create a referential integrity constraint between the relations.

Repeat step 3 until every determinant of every relation is a candidate key