Conduct normalization analysis on CLYSTMS by listing the FDs and the highest normal form of each relation. Complete the task by filling in the row "Normalization Analysis." Database

The relation schema:

Clipboard Font Paragraph Swimmer (Swimmerld, FName, LName, Phone, Email, JoinTIme, CurrentLevelid, Main CTL ld Main CT Since Swimmerld Candidate Kes Foreign Keys Level Levelld Nullable Attributes Notes [1] The relationship WM Caretaker" is implemented as two attributes ain Main CT Id and Main CT Since. It is also acceptable to use a separate relation to implement the relationship. [2] CurrentLevelld is a derived column that can be obtained from the table LevelHistory. Normalization Analysis 2 Caretaker (CT ld. FName. LName. Phone. Email) Candidate Keys [1] CT ld Foreign Keys Nullable Attributes Notes Normalization Analysis Highest NF OtherCaretaker(OC ld, Swimmerld, CT ld. Since Candidate Keys [11 OC Id. [21 ISwimmerld. CT Idl Foreign Keys Nullable Attributes [1] A surrogate key, OC ld, is created as the primary key. This is optional Notes Normalization Analysis FD Highest NF Level( Levelld, Level, Description) Candidate Keys [1] Levelld, [2] Level Foreign Keys Possibly Description, depending on assumptions made Nullable Attributes Notes Normalization Analysis FD: Highest NF Clipboard Font Paragraph Swimmer (Swimmerld, FName, LName, Phone, Email, JoinTIme, CurrentLevelid, Main CTL ld Main CT Since Swimmerld Candidate Kes Foreign Keys Level Levelld Nullable Attributes Notes [1] The relationship WM Caretaker" is implemented as two attributes ain Main CT Id and Main CT Since. It is also acceptable to use a separate relation to implement the relationship. [2] CurrentLevelld is a derived column that can be obtained from the table LevelHistory. Normalization Analysis 2 Caretaker (CT ld. FName. LName. Phone. Email) Candidate Keys [1] CT ld Foreign Keys Nullable Attributes Notes Normalization Analysis Highest NF OtherCaretaker(OC ld, Swimmerld, CT ld. Since Candidate Keys [11 OC Id. [21 ISwimmerld. CT Idl Foreign Keys Nullable Attributes [1] A surrogate key, OC ld, is created as the primary key. This is optional Notes Normalization Analysis FD Highest NF Level( Levelld, Level, Description) Candidate Keys [1] Levelld, [2] Level Foreign Keys Possibly Description, depending on assumptions made Nullable Attributes Notes Normalization Analysis FD: Highest NF