Consider the relation schema R(A, B, C, D, E) and the set F…

Consider the relation schema R(A, B, C, D, E) and the set F = {B → D, CD → E, E → A, A → BC} of functional dependencies. Assume that R is decomposed into the relation schemas R1(A, B, C, E) and R2(B, D). Use the Nonadditive Join Test for Binary Decomposition to determine if this is a lossless decomposition. Further, test and explain whether it is dependency preserving.

Match each term with the correct description (1 answer for e…

Match each term with the correct description (1 answer for each 5-pts).  I. Marl II. Peat III. Thin-green periphyton (algae) IV. Thick blue-green periphyton (algae) V. Cattails a. Soil that is a product of periphyton which oxidizes and leaves behind calcium carbonate particles; a light colored soil b. Grows in acidic/soft water with little dissolved calcium c. Grows in hard-water areas with abundant calcium from contact with limestone bedrock d. Marsh species that are common in areas of higher levels of nutrients or soil disturbance e. Soil that is a product of long-hydroperiod wetlands and is composed of organic remains of dead plants