Normalization Exercises

Hint: adding new entities may be required to complete the following normalization exercises.

Exercise 1 Normalize the table below Excercise 2 into First Normal Form (1NF) and explain why. Do not normalize beyond 1NF.

Exercise 2 Normalize the following table into Second Normal Form (2NF) and explain why. Do not normalize beyond 2NF.

Student	Age	Subjects
Dan	12	Biology, Math
Tim	13	Math
Karen	11	Math

Exercise 3

Transform the following Entity (table) into Third Normal Form (3NF) and explain why.

StudentID, StudentName, DOB, Street, City, State, Zip