Consider the relation schema R(A, B, C, D, E, F) and the set S = {AB → C, BC → AD, D → E, C → B} of functional dependencies. Assuming that R is decomposed into the relation schemas R1(A, B), R2(B, C), R3(A, B, D, E), and R4(E, F). Use the Chase test to show if this is a lossless decomposition.

Exercise 2 (Lossless Decomposition, Dependency Preservation) [20 points]

Suppose we do not have access to the full data set of flights, but we are able to sample 250 flights at random from the table. We would like to estimate the percentage of flights that are delayed.  To do this, we sum the number of flights in our sample and divide by 250 (and multiply by 100).  We then resample with replacement from our sample many times, each time computing this statistic (sum of delayed flights / 250 * 100).  With this process, we obtain a 95% confidence interval: (23.7%, 64.3%).  Choose all the correct statements:

Consider the relation schema R(A, B, C, D, E, F) and the set S = {AB → C, BC → AD, D → E, C → B} of functional dependencies. Assuming that R is decomposed into the relation schemas R1(A, B), R2(B, C), R3(A, B, D, E), and R4(E, F). Use the Chase test to show if this is a lossless decomposition.

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.

Name the three main genera of mangroves and where are they commonly found in the mangrove ecosystem (e.g. above or below high tide line, high or low salinity areas etc.). (3 pts)

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

List and define the three different type of binary stars. 

Accounting for over half of all deforestation in tropical regions is the ________.

Pulsars are pulsating variable stars.