View the step-by-step solution to:

Question

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