Question: Attributes/scheme: A, B, C, D, E, F, G, H, I, J} Dependencies: {A. F} {B.C, D, E): {A} - {C}; {C} {F}; {D} - {G.


Attributes/scheme: A, B, C, D, E, F, G, H, I, J} Dependencies: {A. F} {B.C, D, E): {A} - {C}; {C} {F}; {D} - {G. H}; {E. D} - {D.I. G}; {E} - {D} Exercise 1.3 (3 points) Convert the scheme into 3-NF using the synthesis algorithm. Exercise 1.4 (2 points) Transfer the following scheme to BCNF. Determine the violations of the BCNF per iteration. Determine all relations and (non-trivial) functional dependencies after each iteration Relation: {A, B, C, D} Dependencies: {D} - {A.C}; {C} - {A}
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
