The Grade Report Table below shows a relation called Grade Report for a university. For StudentID...
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
The Grade Report Table below shows a relation called Grade Report for a university. For
StudentID StudentName CampusAddress Major CourseID
Acctg Mkgt 300
a. Diagram the functional dependencies in the relation.
b. Draw an ER relational model
c. Draw a full relational model based on your ER model in 3NF and show the referential
Answer rating: 100% (QA)
for part 1 please follow the given attachment Dependency of the table is named as F1 F2 F3 F4 2 the ...View the full answer