Describe two disadvantages of normalized tables.
Suppose you are given the table:
EMPLOYEE_DEPARTMENT (EmployeeNumber, EmployeeLastName,
EmployeeFirstName, Email, DepartmentName, BudgetCode)
and you wish to transform this table into the two tables:
DEPARTMENT (DepartmentName, BudgetCode)
EMPLOYEE (EmplyeeNumber, EmployeeLastName, EmployeeFirstName,
Email, DepartmentName)
Write the SQL statements needed for filling the EMPLOYEE and DEPARTMENT tables
with data from EMPLOYEE_DEPARTMENT.