Explore BrainMass
Share

Explore BrainMass

    Dependence diagram

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    The following table 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
    Deliverable:

    Draw a dependence diagram. There are examples in the reading assignments of dependence diagrams.
    In what normal form is this table? Explain why.
    Decompose the table into a set of 3NF tables. Describe the process to decompose the table.
    Draw an ER diagram based on the decomposed tables (in Chen model).

    Look at attached grade report...

    © BrainMass Inc. brainmass.com October 9, 2019, 11:51 pm ad1c9bdddf
    https://brainmass.com/computer-science/html-html5/dependence-diagram-270333

    Attachments

    Solution Summary

    Draw a dependence diagram. There are examples in the reading assignments of dependence diagrams.
    In what normal form is this table? Explain why.

    $2.19