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 5 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 {(CDA),(CDB), CDE)}
a. List prime attributes and non-prime 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 422 pts
Consider a relation F with 5 attributes ABCDE. You are given the following Functional
Dependencies:
AB,
BCE,
EDA.
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 non-prime 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 answer
Consider a relation F with 5 attributes ABCDE.

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!