Question: Consider the following decompositions for the relation schema R of Exercise 15.24. Determine whether each decomposition has (1) the dependency preservation property, and (2) the
Consider the following decompositions for the relation schema R of Exercise 15.24. Determine whether each decomposition has (1) the dependency preservation property, and (2) the lossless join property, with respect to F.
Also determine which normal form each relation in the decomposition is in.
a. D1 = {R1, R2, R3, R4, R5}; R1 = {A, B, C} , R2 = {A, D, E} , R3 = {B, F}, R4 = {F, G, H}, R5 = {D, I, J}
b. D2 = {R1, R2, R3}; R1 = {A, B, C, D, E}, R2 = {B, F, G, H}, R3 = {D, I, J}
c. D3 = {R1, R2, R3, R4, R5}; R1 = {A, B, C, D}, R2 = {D, E}, R3 = {B, F}, R4 = {F, G, H}, R5 = {D, I, J}
Step by Step Solution
3.26 Rating (164 Votes )
There are 3 Steps involved in it
Let take the relation R is R A B C D E F G H l And The functional dependencies F are ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1013-C-S-O-S (818).docx
120 KBs Word File
