Question: R = { A , B , C , D , E , F } ABC > D , and D > E , and

R={A,B,C,D,E,F}
ABC>D, and D>E, and E>F
Transform R to 3NF.
R1={A,B,C,D} with PK={A,B,C}
R2={D,E} with PK={D}
R3={E,F} with PK={E}
R1={A,B,C,D} with PK={A}
R2={D,E} with PK={D}
R3={E,F} with PK={E}
R1={A,B,C,D} with PK={A,B}
R2={D,E} with PK={D}
R3={E,F} with PK={E}
R1={A,B,C,D,E} with PK={A,B,C,D}
R2={E,F} with PK={E}
 R={A,B,C,D,E,F} ABC>D, and D>E, and E>F Transform R to 3NF. R1={A,B,C,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!