4) 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.

Record your answer here.

Figure 3.19

Read the following scenario carefully: Banyon Corporation currently keeps track of employee data in a spreadsheet table. However, they see that the single-table approach is not working well since there is duplication of data and various anomalies arise as new rows are inserted, old rows deleted, and current rows updated. Here are the current column headers for Banyon's spreadsheet table, Employees. Employees Banyon has decided to use a database rather than a single-table spreadsheet. They conducted the following analysis. Each employee is identified by a unique empid, Knowing an smpid, you can determine the corresponding employee name, phone and department in which the employee works. Department names are also unique. Knowing a dept name you can determine the department's phone and manager. Each employee possesses a set of skills. Employees must periodically update each skill by passing a test that certifies a certain skill level at a given point in time (skill.date). A skill can be identified by a unique skillid. However, skilleel and skilldate are associated with a specific employee's certification on a given skill