Consider the relation R(O,P,X,Y,E, S); FDs={ O->P, XY->O, OE->S, EY->X, PY->X} What is the lossless (or nonadditive) join property of a decomposition? Why is it important? Determine whether each of...

Consider the relation R(O,P,X,Y,E, S); FDs={ O->P, XY->O, OE->S, EY->X, PY->X}

What is the lossless (or nonadditive) join property of a decomposition? Why is it important?

Determine whether each of the decompositions has the lossless join property with respect to F and conclude for the whole decomposition

Determine whether each of the decompositions has the dependency preserving property with respect to FD and conclude for the whole decomposition