Question: Need help don't understand how this is supposed to work In this Normalization exercise, you will need to normalize the Grade Report table according to

Need help don't understand how this is supposed to work

In this Normalization exercise, you will need to normalize the Grade Report table according to the following instructions:

  • Consider the following entity and its attributes.
    • 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.
  • Normalize the entity Grade_Report to 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.
  • Explain the steps required to break up the Grade Report entity into multiple entities that each have a single theme.
  • What is missing

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!