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)
Correct Answer:
Verified
Correct Answer:
Verified
Q40: _ describes the relationship of attributes in
Q41: Relational databases are often implemented on tables
Q42: Which type of table is an excellent
Q43: Third normal form is also often referred
Q44: What do you call each key that
Q45: A(n) _ occurs if a nonkey attribute
Q46: A(n) _ helps constrain the values in
Q48: Which of the following is an example
Q49: What do you call a table that
Q50: What do you call a data inconsistency