Consider the following user view of a grade report at auniversity:
StudentName: Student ID:
Semester: Year:
Major: Status:
Course
Number
Course
Title
Professor
Name
Professor Dept.
Grade
…..
……….
………….
………..
……….
Build the required relations andnormalize them into 3NF specifying the primary key for eachresulting relation. Make your own assumptions.
Expert Answer
An answer will be send to you shortly. . . . .