Draw a dependency diagram to show the functional

Question

Task

Table : 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

Using above table

1. Draw a dependency diagram to show the functional dependencies in the relation

2. Decompose the GRADE REPORT relation into a set of 3NF relations

3. Draw a relational schema for your 3NF relations and show the referential integrity constraints

NOTE

For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video.

Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

Rationale

This assessment aligns with the following subject outcomes:be able to critically analyse a database design and apply normalisation theory and techniques;