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.