Question: Consider the relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F = {{A, B}-C,

 Consider the relation R = {A, B, C, D, E, F,

Consider the relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F = {{A, B}-C, {B, D}-{E, F}, {A, D}-{G, H), AI,HJ). Decompose R into 3NF relations Select one: O a R1 (A, B, C), R2 (A, D, E, I, J), R3 (B. F, G, H) b.R1 (A, B, C), R2 (A, D, E), R3 (B. F), R4 (D. I, J), R5 (E, G, H) c. R1 (A, B, C), R2 (B, D, E, F), R3 (A, D, G, H, J), R4 (A, I) O d. R1 (A, B, C), R2 (B, D, E, F), R3 (A, D, G, H), R4 (A. I), R5 (H, J), R6 (A,B,D

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!