Consider the following functional dependencies that hold on

Consider the following functional dependencies that hold on R(ABCDEF):

AB-> CD, E -> C, B -> EF

Is R in 3NF? Explain your answer in detail and decompose the relation, as necessary, into a collection of relations that are in 3NF. Make sure you first find all the key(s) of R so that you will be able to tell whether an attribute is prime.

Solution

It is in not in 3NF since all tables are not dependent on one key...That is primary key..

Decomposing the relation to make schema in 3NF.

A ->BCDE

A -> EF
A -> C

Now all tables are dependent on one primary key A, so that if we know \"A\" we can able to fetch all tables data.