Question: Given the relation R ( A , B , C , D , E , G , H ) and Fo: ( fd 1 ,

Given the relation R (A, B, C, D, E, G, H) and Fo: (fd1, fd2, fd3, fd4, fd5, fd6, fd7) where
fd1: A D
fd2: G A
fd3: B H
fd4: G E
fd5: C B
fd6: (G,H) B
fd7: (G,H) C
Assuming you select the candidate key with the most desirable functional dependencies as your primary key, what are the desirable fds in Fc?
Group of answer choices
fd1
fd3
fd7
fd1, fd2, fd3, fd4, fd5
fd2 and fd4

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!