A table called "Employee" has the following attributes: ( EmployeeID , DepartmentID, DepartmentName, EmployeeName). The following dependencies exist:
EmployeeID → EmployeeName, DepartmentID DepartmentID → DepartmentName Note : The underlined columns/attributes is PK.
Which of the following actions will normalize the table to 3NF ?

Question

A table called "Employee" has the following attributes: ( EmployeeID , DepartmentID, DepartmentName, EmployeeName). The following dependencies exist: 
  EmployeeID → EmployeeName, DepartmentID DepartmentID → DepartmentName Note : The underlined columns/attributes is PK. 
 Which of the following actions will normalize the table to  3NF ?

Accepted Answer

Split the table into  (EmployeeID, DepartmentID, EmployeeName)  and  (DepartmentID, DepartmentName) .

Answer

Add  DepartmentID  as a primary key.

Answer

Remove  DepartmentName  from the table.

Answer

Create a composite key with  (EmployeeID, DepartmentID) .

Crowdly

A table called "Employee" has the following attributes: ( EmployeeID , Departmen...

Want instant access to all verified answers on eclass.yorku.ca?