Which of the Following Tables Should Be Converted to Second

question 47

Multiple Choice

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)

---

Definitions:

Bequeath

The act of leaving personal property to someone through a will.

Personal Representative

A personal representative is an individual appointed to administer the estate of a deceased person under a will or through a court process.

Nonprobate

Refers to assets or property that will pass to survivors by means other than a will, such as through trust or designated beneficiary.

Ambulatory

A term pertaining to the ability of a will to be changed by a testator.