Consider the following relation R(C, S, T, E, G) with the following conditions:

C>T

ST>E

T>C

SC>G

EG >T

a) Find all the key. Justify your answer.

b) Find prime and non-prime attributes. Justify your answer.

c) Classify functional dependencies. Justify your answer.

d) Determine normal form for relation R. Justify your answer.

e) Assume we are given a decomposition, TES, CTE, SCG. Is the decomposition in 3NF? Justify your answer.

R(CSTEG)

R1(TECS) R2(SCG)

R11(TES) R12(CTE)

f) Is the decomposition (same as e) in BCNF? Justify your answer.

g) Is the decomposition lossless join? Justify your answer.

h) Is the decomposition dependency preserving? Justify your answer.

What/when/how to submit: Submit a soft copy by October 31, 2018 to the corresponding assignment link

Note: Please type your solution.