Share
Explore BrainMass

Drawing a Dependence Diagram

Using Microsoft Word, complete the following:

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).
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

These shown Dependencies have been included in a .jpeg file for better order.

Attachments

$2.19