Suppose the Session table is set up as follows. Is this design correct? If not, in which normal form would you correct it?

a. First normal form

b. Second normal form

c. Third normal form

d. It is correctly designed; it does not violate any form.

Transcribed Image Text:

SessionNum Session Date Patient Num 10/10/2021 1011 10/11/2021 1016 10/11/2021 1014 1013 1016 1018 1017 1015 1010 1019 1020 1021 27 28 29 30 31 32 33 34 35 36 37 38 10/12/2021 10/15/2021 10/16/2021 10/17/2021 10/17/2021 10/18/2021 10/18/2021 10/19/2021 10/19/2021 Session LengthOfSession 45 30 60 30 90 15 60 45 30 75 30 60 First TherapyCode 92507 97010 97014 97033 98960 97035 97039 97112 97113 97116 97124 97535 TherapistID Last JR085 Risk Jonathan AS648 Shields Anthony SW124 Wilder Steven BM273 McClain Bridgette AS648 Shields Anthony JR085 Risk Jonathan SN852 Nair BM273 McClain SW124 Wilder Steven SN852 Nair Saritha BM273 McClain Bridgette AS648 Shields Anthony Saritha Bridgette