A dependency diagram is shown below, Identify the partial dependencies and transitive dependencies. Normalise the given scenarios

A dependency diagram is shown below, Identify the partial dependencies and transitive dependencies.  
 
 

Transcribed Image Text:

Normalise the given scenarios to Third normal form 1. XYZ school stores student information as follows. ID Name 20200001 Sai 20200002 Brendan Address House Name 10, Lilly Station pilly street 12, Baxter Ave Acacia House color Purple Yellow Subject Maths Physics Chemistry Maths Subject Cost 100 110 120 100 Accountin 70 Business 70 Grade A A+ A B A 21 A+ Normalise the given scenarios to Third normal form 1. XYZ school stores student information as follows. ID Name 20200001 Sai 20200002 Brendan Address House Name 10, Lilly Station pilly street 12, Baxter Ave Acacia House color Purple Yellow Subject Maths Physics Chemistry Maths Subject Cost 100 110 120 100 Accountin 70 Business 70 Grade A A+ A B A 21 A+