Answer Happy

4. Base on the following table: EMPLOYEE_DEPARTMENT
EMPLOYEE_DEPARTMENT
(EmployeeNumber, EmployeeLastName, EmployeeFirstName, Email,
DepartmentName,
BudgetCode)
a. Show the step to normalize the table into BCNF.
b. Write the SQL statements for creating the normalize
table.
c. Write SQL filling the EMPLOYEE and DEPARTMENT tables with data
from
EMPLOYEE_DEPARTMENT