View the step-by-step solution to:

The following information shows a table called Grade Report for a university. The existing functional dependencies are described as follows:

The following information 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
Table: Grade Report


Student_ID
Student_ Name
Major
Course_ID
Course_Title
Instructor_Name
Instructor_Location
Grade

168300458
Williams
IT
ITD320
Database Imp
Codd
B104
A

168300458
Williams
IT
ITP310
Programming
Parsons
B317
B

543291073
Baker
Acctg
ITD320
Database Imp
Codd
B104
C

543291073
Baker
Acctg
Acct201
Fund Acctg
Miller
H310
B

543291073
Baker
Acctg
Mktg300
Intro Mktg
Bennett
B212
A





Assignment Guidelines:

Draw a dependency diagram for the listed functional dependencies.
In what normal form is the table located within the Assignment Description? Explain why.
Split the table into a set of 3NF tables.
How did you arrive at your solution?
Draw an Entity-Relationship diagram based on your new 3NF table set.
You may use Microsoft Access for help with table splitting and drawing your diagram.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question