1.Is the following table in 3NF? Justify your answer.

T(A, B, C, D, E, F)

A BC

B A

C DEF

2.Is the following table in 3NF? Justify your answer.

T(A, B, C, D, E, F)

A BC

C DE

E F

3.Decompose the table in question two into tables which are in 3NF.

4.Is the following table in 3NF? Justify your answer.

T(A, B, C, D, E, F)

A DBFE

E ABFD

5.(a) tell what the FDs of the following table are. (b) The table is not in 3NF, decompose it so that it is in 3NF.

This table stores information about participants in a multi-stage contests. First contestants compete in a regional contest (several US states belong to the same region) and the winners in these contests go on to compete nationally). Each contestant may have multiple phone numbers, but (of course!) each row in the table can only store one number.

contestants(id, full_name, state, region, phoneNumber).