Consider a relation R with six attributes A, B, C, D, E, F. You are given the following dependences:

C F, E

BC D,

AD B, and

ED C.

Is {(ABCD)} a candidate key of this relation? If not, is {(ABC)}? Justify your answer.

Consider the relation F with five attributes M,O,N,E,Y with the following dependences:

O N,

OY M,

MY E, and

MN O.

List all keys for F and justify your answer.

Determine normal form for the relation F and justify your answer.

Assume we are given decomposition: F₁(O, Y, M), F₂(O, N, E, Y) as indicated in the below figure.

Is the decomposition lossless join? Justify your answer.

Is the decomposition dependency preserving? Justify your answer.

Answer:

Is F₁(O, Y, M) not in BCNF? Justify your answer.

Answer: