Question: Consider a relation F with 5 attributes ABCDE. You are given the following Functional Dependencies: A - > B , BC - > E ,
Consider a relation F with attributes ABCDE. You are given the following Functional Dependencies:
A B
BC E
ED A
Given a set of FDs for the relation schema F A B C D E with the candidate keys CDACDB CDE
a List prime attributes and nonprime attributes for the relation F Justify your answer.
A is prime, B is prime
b Classify each functional dependency for the relation F Justify your answer.
c Determine the normal form of the relation F Justify your answerProblem pts
Consider a relation with attributes ABCDE. You are given the following Functional
Dependencies:
Given a set of FDs for the relation schema F A B C D E with the candidate keys
CDB CDE
a List prime attributes and nonprime attributes for the relation F Justify your answer.
A is prime, is prime
b Classify each functional dependency for the relation F Justify your answer.
c Determine the normal form of the relation F Justify your answer
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
