Question: 6 . Consider the following relation R and its set of functional dependencies: R = ( A , B , C , D , E

6. Consider the following relation R and its set of functional dependencies:
R =(A, B, C, D, E)
FDs ={A-> BC, CD-> E, B-> D, E -> A}
a. What are the different candidate keys in this relation?
[2 Marks]
b. Is this relation in BCNF? If yes how, if not then make it compliant with the BCNF.
[2 Marks]
c. Is this relation in 3NF? If yes how, if not then make it compliant with the 3NF.
[1 Mark]

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!