[SOLVED] Normalization Exercise

I’m trying to study for my Computer Science course and I need some help to understand this question.

Prior to beginning work on this interactive assignment, read chapter 6 of your textbook as well as the Absolute Beginner’s Guide to Database Normalization (Links to an external site.), Database Normalization (Links to an external site.) and Normalization: How far is far enough (Links to an external site.) online resources, and review any relevant information in this week’s lecture.

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.

Your response must be a minimum of 250 words.

Guided Response: Review several of your colleagues’ posts, and respond to at least two of your peers by 11:59 p.m. on Day 7 of the week. You are encouraged to post your required replies earlier in the week to promote more meaningful interactive discourse in this interactive assignment.

Review your classmate’s proposed normalized tables and discuss whether the tables are fully normalized. Suggest at least one improvement or additional step needed to normalize the tables. In addition, suggest whether or not your classmate should normalize the entity to a higher normalization form (.i.e.: 4NF or 5NF). Describe a database environment that would require normalization to a higher normal form. Explain at least one advantage and one disadvantage for normalizing to 4NF or 5NF.

Your response must be a minimum of 250 words.