Draw a dependency diagram to show the functional

Question

Manually drawing the dependency diagram or the relational schema is NOT acceptable.please do according to the marking criteria.

Task

Table 1: GRADE REPORT relation above

1Student_ID	1Student_Name	Kampus_Address	'Major	1Course_10	1Course_title	1Instructorfiame	lInstructor_Location	'Grade
1 16830058	1 Williams	1 Albury	I BIT	1 ITC114	'Database Sys	'Peter	16104	1HD
1 16830058	1 Williams	1 Albury	I BIT	1 ITC211	'Sys Analysis	'John	16115	I 0
1 543291073	1 Baker	I Wagga	I Acct	1 ITC200	'Database Mgt	'David	1 H310	I D
1 543291073	1 Baker	I Wagga	I Acct	1 Acc11	'Fund Acct	'William	1 Al20	I D
1 543291073	1 Baker	I Wagga	I Acct	1 Mkg21	'Intro Mkt	'Mike	1 A112	I 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

By using the grade report, provided in the assignment, answer to the following questions by keeping in mind that manual drawing of dependency diagram or relational schema is not applicable. Q1. Draw a dependency diagram to illustrate the functional dependencies in the relation. Q2. Decompose GRADE REPORT to a set of 3NF relations. Q3. Draw a relational schema for your 3NF relations and illustrate the referential integrity constraints Q4. Particularly you are needed to apply the normalization procedure to existing data in order to minimize the redundancies and data anomalies.