Problem 4 (36 pts) der the relation l(OP,XYES) Fly ⓣSpjXY:0, 0E>S, EY-X, pY-X} 1. Find all possible candidate keys of the relation Y.E 2. Find the Prime attributes and non-prime attributes Prime: YE Non-Prime: QPXS 3. Classify each functional dependency 4. Determine the Normal Form of the relation 5. What is the dependency preservation property for a decomposition? Why is it important? 6. Decompose the relation into BCNF relation. 7. What is the lossless (or nonadditive)
OR
OR