Question: EXERCISE 5 Consider the relation R 1 ( A , B , C , D , E , F ) with the following functional dependencies

EXERCISE 5
Consider the relation R1(A,B,C,D,E,F) with the following functional dependencies
A,BC,(1)
CB,(2)
CD
B,CF(4)
DE,(5)
Find all candidate keys of R1.(2 PTS)
Is R1 in 2NF? Justify your answer. (1 PT)
Is R1 in 3NF? Justify your answer. (1 PT)
Is R1 in BCNF? Justify your answer. (1 PT)
 EXERCISE 5 Consider the relation R1(A,B,C,D,E,F) with the following functional dependencies

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!