Draw a dependency diagram to show the functional

Question

Table 1: GRADE REPORT relation above

Table 1: GRADE REPORT relation
Student_ID	Student_Name	Campus_Address	Major	Course_ID	Course_title	Instructor_Name	Instructor_Location	Grade
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

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.

Answer 1

The following table that shows grade report as well relational schema for your 3NF relations Table 1: GRADE REPORT relation above Table 1: GRADE REPORT relation 1. Draw a dependency diagram to demonstrate the functional dependencies in the relation 2. Decompose GRADE REPORT into a set of 3NF relations 3. Illustrate a relational schema for your 3NF relations and illustrate the referential integrity constraints