Question: Question 2 : ( 5 points ) Consider a Relation R 3 = ( A , B , C , D , E , F

Question 2: (5 points)
Consider a Relation R3=(A,B,C,D,E,F) which has the following functional dependencies:
ABC
CD-B
CDF
BF
Which of the following must also hold:
AB
AC
AE
AF
CE
ADE
Question 3: (10 points)
Consider the following relation
R(A,B,C,D,E,F,G), where
(A,B) is the primary key
(A,D) is a candidate key
R has the following dependencies
(A,B)C,D,E,F,G
(A,D)B,C,E,F,G
CF,G
DE
Normalize R to 3 NF
Question 2 : ( 5 points ) Consider a Relation R 3

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 Programming Questions!