- 1 Consider The Relational Schemas Given Below And The Respective Sets Of Functional Dependencies Valid In The Schemas 1 (28.59 KiB) Viewed 28 times
1. Consider the relational schemas given below and the respective sets of functional dependencies valid in the schemas. For each one of the relational schemas identify its highest normal form. Remember that the identification of a normal form requires analysis of the valid functional dependencies and the minimal keys. Provide justification of each answer. A solution with no comprehensive justification scores no marks. i. ii. R1(A,B,C,D,E,F,G,H) F={CH →G, A → BC,E − A,F → EG} R2 = (S,C,L,D) F = {(L,D) →S,(L,D) → C,L → D} R3(A,B,C,D,E) F = {ABC → D, D → A} = (1.0 mark) (1.0 mark) (1.0 mark) iii.