Question: ( 1 5 points ) You are given the following set of functional dependencies for a table with 7 attributes ( ABCDEFG ) : A

(15 points) You are given the following set of functional dependencies for a table with 7
attributes (ABCDEFG):
AB, AC, CDG, EGF, AFGE
a. Find all candidate keys (show your work)
b. Find a lossless decomposition into Boyce-Codd normal form with the following
instructions:
i. If there is a choice of functional dependencies that can be used, pick the
leftmost one (as listed on the question) that has not been use.
ii. If you have to replace a functional dependency with another, put the new one(s)
at the end of the list.

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!