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
Get step-by-step solutions from verified subject matter experts
