Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment

Question

Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows. A. Draw a realtional schema and diagram the functional dependencies in the relation. B. In what normal form is this relation? C. Decompose GRADE REPORT into a set of 3NF relations. D. Draw a relational schema for your 3NF relations and show the referential integrity constraints.

Student_ID Student_Name Campus_Address Major Course_ID Course_Title Instructor_Name Instructor_Location Grade 168300458 Williams 208 Brooks IS IS 350 Database Mgt. Codd B 104 A 168300458 Williams 208 Brooks IS IS 465 System Analysis Parsons B 317 B 543291073 Baker 104 Phillips Acctg IS350 DatabaseMgt. Codd B 104 C 543291073 Baker 104 Phillips Acct 201 CS588 Fund Acctg Miller H 310 B

Explanation / Answer

No answer text found in this record.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.