The following table (Attached) shows a table called Grade Report for a university. The existing functional dependencies are described as follows:
Student_ID -> Student_Name, Major
Course_ID -> Course_Title, Instructor_Name, Instructor_Location
Student_ID, Course_ID -> Grade
Instructor_Name -> Instructor_Location
What I need help doing is the following:
1. Drawing a dependency diagram. Included is an example on the pdf file
2.Decomposing the table into a set of 3NF tables, and describing the process to decompose the table.
3.Drawing an ER diagram based on the decomposed tables (ERD model) entity-relationship model or entity-relationship diagram (ERD) .
The table is attached, thanks in advance!!© BrainMass Inc. brainmass.com October 9, 2019, 6:11 pm ad1c9bdddf
The expert develops database tables using a relational database systems.