Pitt Fitness modified the Reservations table as follows, but it may have an improper design. The potential problem may be corrected in which normal form?

a. First normal form

b. Second normal form

c. Third normal form

d. It is correctly designed.

Transcribed Image Text:

Reservation (key) Date 2100001 1/5/2021 2100002 1/8/2021 2100003 2100004 2100005 2100006 2100007 1/10/2021 1/10/2021 1/12/2021 1/13/2021 1/13/2021 CustomerID ClassID Instructor LastName FirstName 107 39 RS02 Sisto Robert 108 24 VP01 Pegues Vicki 108 10 RS02 Sisto Robert 108 10 NT01 Tahan Neda 105 NT01 Tahan Neda 105 VP01 Pegues Vicki 109 MS01 Said Memo 8 35 33