Question: } A , D G , H B , D E , F A I { H J Identify all candidate keys for R 2

}
A,DG,H
B,DE,F
AI
{HJ
Identify all candidate keys for R2.
ABD is the candidate key, because closure of ABD has all the attributes of R. Prime attributes: A B D, Non-prime attributes: C E F G H I
Check out that R2 is in 3NF or not? If not decompose it in 3NF.
(1)-- Neither AB is super key, nor C is prime attribute.
(2)-- Neither AD is not super key, nor GH is prime attribute.
(3)- Neither BD is not super key, nor EF is prime attribute.
(4)- Neither A is not super key, nor I is prime attribute.
(5)- Neither H is not super key, nor J is prime attribute.
So,R2 is not in 3NF as it is not following the rules of 3NF.
Therefore, R2(A,B,C,D,E) needs to be divided into following:
R21(ABCI)
R22(ADGHJ)
R23(BDEF)
R24(ABD)
R211(A B C)
R212(A I)
R221(A D G H)
R221(H J)
 } A,DG,H B,DE,F AI {HJ Identify all candidate keys for R2.

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!