Computer Science Homework Solutions
Problem
#88756

Draw dependence diagrams

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
Student_ID, Course_ID -> Grade
Instructor_Name -> Instructor_Location


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

Solution
What is this?
By OTA - Overall OTA Rating
Xiao Liu, MS - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$23.94)
Included in Download
  • Plain text response
  • Attached file(s):
    • deliverable.doc
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse