Question: Given R = { A , B , C , D } if A > B C and B > D : To transform R

Given R={A,B,C,D} if A>BC and B>D :
To transform R to 3NF by representing the 3NF relations and their attributes, and the Functional Dependencies, which resulting relations fulfills 3NF. Candidate keys for each resulting relation are indicated as PK={x}. Dependency is indicated by a >.
R1={A,B,D},PK={A,B}
R2={B,D},PK={B}
R1={A,B,C,D},PK={A,B}
R2={B,C,D},PK={B}
R1={A,B,C},PK={A}
R2={B,D},PK={B}
R1={A,B,C,D},PK={A,B}
 Given R={A,B,C,D} if A>BC and B>D : To transform R to

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!