Which of the following tables should be converted to second normal form?
A)Employees (EmpID, EmpFirst, EmpLast, Department)
B)Visits (VisitID, VisitType, VisitDate, PatientID, LengthInMinutes)
C)Players (PlayerID, PlayerFirst, PlayerLast, CoachID, CoachFirst, CoachLast, Team)
D)Bookings (BookingID, CheckInDate, CheckOutDate, RoomID, CustomerID)

Question

Quizplus · Accepted Answer

C) Players (PlayerID, PlayerFirst, PlayerLast, CoachID, CoachFirst, CoachLast, Team) should be converted to second normal form because it contains partial dependencies. The attributes CoachFirst and CoachLast depend only on CoachID, not on the primary key (PlayerID) as a whole.

Which of the Following Tables Should Be Converted to Second