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

CT

STE

TEC

SCG

Find all the candidate key. Justify your answer.

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

Classify functional dependencies. Justify your answer.

Determine normal form for relation R. Justify your answer.

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

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

Is the decomposition lossless join? Justify your answer.

Is the decomposition dependency preserving? Justify your answer.

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

Note: Please type your solution.