Snapsolve any problem by taking a picture.
Try it in the Numerade app?
Problem 6: 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 FA,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. b. Classify each functional dependency for the relation F. Justify your answer. c. Determine the normal form of the relation F. Justify your answer.
Submitted by Dawn H. Feb. 08, 2023 03:07 p.m.
EXPERT VERIFIED
EXPERT VERIFIED
NO COMMENTS YET