DRAW A DEPENDENCY DIAGRAM TO SHOW FUNCTIONAL DEPEN

DRAW A DEPENDENCY DIAGRAM TO SHOW FUNCTIONAL DEPENDENCIES IN THE RELATION

The primary theme of the paper is DRAW A DEPENDENCY DIAGRAM TO SHOW FUNCTIONAL DEPENDENCIES IN THE RELATION in which you are required to emphasize its aspects in detail. The cost of the paper starts from $109 and it has been purchased and rated 4.9 points on the scale of 5 points by the students. To gain deeper insights into the paper and achieve fresh information, kindly contact our support.

able 1: GRADE REPORT RELATION

Student_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGrade
 16830058  Williams  Albury  BIT  ITC114 Database Sys  Peter  B104  HD
 16830058  Williams  Albury  BIT  ITC211 Sys Analysis  John  B115  D
 543291073  Baker  Wagga  Acct  ITC200 Database Mgt  David  H310  D
 543291073  Baker  Wagga  Acct  Acc11  Fund Acct  William  A120  C
 543291073  Baker  Wagga  Acct  Mkg21  Intro Mkt  Mike  A112  P

Using Table 1: GRADE REPORT RELATION ABOVE

  1. Draw a dependency diagram to show the functional dependencies in the relation.
  2. Decompose GRADE REPORT into a set of 3NF relations.
  3. Draw a relational schema for your 3NF relations and show the referential integrity constraints.

NOTE

Manually drawing the dependency diagram or the relational schema is NOT acceptable.

Rationale:
  1. This assessment item is designed to test your understanding of more advanced database design, your ability to use an iterative approach to modelling, and to examine data problems due to redundancy.
  2. Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.
100% Plagiarism Free & Custom Written
Tailored to your instructions