Explore BrainMass
Share

Explore BrainMass

    Develop database tables using a relational database system

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

    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
    https://brainmass.com/computer-science/databases/develop-database-tables-relational-database-system-80929

    Attachments

    Solution Summary

    The expert develops database tables using a relational database systems.

    $2.19