Question: Consider a relation R ( ABCDEFGHIJ ) with the following set of functional dependencies G = { F AB , CD E , C FG
Consider a relation RABCDEFGHIJ with the following set of functional dependencies
G F AB CD E C FG H IJ D H
Is CDE a superkey of R wrt G
Is CDE a key of R wrt G
Apply the appropriate algorithm to determine a key for R wrt G
Apply the appropriate algorithm to determine all the keys for R wrt G
Determine the prime attributes of R
Is R in BCNF wrt G
Is R in NF wrt G
Determine whether the decomposition D CDE, CFG DH HIJ, FAB has i the dependency
preservation property and ii the lossless join property, with respect to G Also determine which normal
form each relation in the decomposition is in
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
