Which of the following tables should be converted to third normal form?
A)Clients (ClientID, ClientFirst, ClientLast, ProjectID, ProjectType)
B)Departments (DeptID, DeptName)
C)Products (ProductID, CategoryID, ProductName, UnitPrice)
D)Classes (ClassID, ClassName, ClassDate, StartTime, EndTime, ClassPrice)

Question

Quizplus · Accepted Answer

The table in option A should be converted to third normal form because it contains transitive dependencies. ProjectType is dependent on ProjectID, which is not the primary key (ClientID). This violates the rules of third normal form, which requires that all attributes must be directly dependent on the primary key.

Which of the Following Tables Should Be Converted to Third