Normalization Exercise

 

Normalization is an important step towards translating models and diagrams into relational databases. In this exercise, you will need to normalize the Grade_Report table below and explain the steps needed to do so.

For this assessment, consider the following entity and its attributes and normalize the entity Grade_Report to 3NF.

Entity: Grade_Report (StudentID, StudentName, Phone, DOB, Address, Email_Address, CourseNumber, CourseName, Grade, DepartmentID, DepartmentName)

Explain the steps needed to normalize this entity to 1NF, 2NF and 3NF. List the resultant Normalized entities in the same format as the original Grade_Report.

Once the entity is normalized to 3NF, describe any issues this entity might have that can be solved by normalization. Explain the functional dependencies that exist between the attributes. Provide the steps required to break up the Grade_Report entity into multiple entities that each have a single theme.