Snapsolve any problem by taking a picture.
Try it in the Numerade app?
Problem 5: Consider a relation R with 5 attributes A, E, X, S, and T. You are given the following Functional Dependencies: X -> A, X -> T, E -> S, and E -> A. List all Candidate keys for R. Justify your answer very concisely. Problem 6: Consider a relation F with 5 attributes A, B, C, D, and E. You are given the following Functional Dependencies: A -> B, B -> C, E -> D. Given a set of FDs for the relation schema FAB, CD, 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 Suzanne R. Feb. 11, 2023 04:28 p.m.
EXPERT VERIFIED
EXPERT VERIFIED
NO COMMENTS YET