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

material 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.1 * (3 points) Check the key property of the attributes {A.F} using the RAP algorithm. Exercise 1.2 * (4 points) Calculate the minimum coverage of the functional dependencies presented. 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
Get step-by-step solutions from verified subject matter experts
