Pitt Fitness modified the Orders table as follows, but it may still not be designed properly. 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:

OrderID (key) 2501 2502 2502 2502 2503 2503 2504 OrderDate 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 CustomerlD 107 108 108 108 105 105 109 ItemID (key) S-61 S-59 P-25 T-19 S-45 T-91 P-24 Description T-shirt L T-shirt M Yoga Pants M Tank L T-shirt S Tank S Yoga Pants L Price 825 $25 $50 $18 $25 818 $50