Relation R O P X Y E S Fds O P Xy O Oe S Ey X Py X 1classify Functional Dependency 2 Deco Q37281391

for the relation R(O,P,X,Y,E, S) FDs={ O->P, XY->O,OE->S, EY->X, PY->X}. 1.Classify each functionaldependency 2. Decompose the relation into BCNF relation. 3.Determine whether each of the decompositions has the lossless joinproperty with respect to F and conclude for the wholedecomposition. 4. Determine whether each of the decompositions hasthe dependency preserving property with respect to FD and concludefor the whole decomposition

Answer

Dear student, according to the question, the solution isas follows: