Question

Which of the following tables should be converted to third normal form?

	a.	Products (ProductID, CategoryID, ProductName, UnitPrice)
	b.	Departments (DeptID, DeptName)
	c.	Clients (ClientID, ClientFirst, ClientLast, ProjectID, ProjectType)
	d.	Classes (ClassID, ClassName, ClassDate, StartTime, EndTime, ClassPrice)

Answer 1

Following table we will need to converted to third normal form if there exists a  no transitive dependency for non-prime attributes if it is in second normal form already.

Products (ProductID, CategoryID, ProductName, UnitPrice)

Clients (ClientID, ClientFirst, ClientLast, ProjectID, ProjectType)

Classes (ClassID, ClassName, ClassDate, StartTime, EndTime, ClassPrice)

For better understanding you should have provided the association between the columns. That could have been better for clear understanding if it given as there may be some transitive dependency and there may not be. It all depends on how you are considering.