1,228 views
2 votes
2 votes

Consider the relation $R\left ( A,B,C,D,E \right )$ with functional dependencies

$F=${

$A\rightarrow B$

$BC\rightarrow E$

$ED\rightarrow A$

}

Number of additional relation required to convert it into lossless , dependency preserving $3NF$ decomposition is _____________


What is meaning of additional relation (Here no table mentioned previously)??

2 Answers

3 votes
3 votes

First, let's have a look at the candidate keys. 

In this case the candidate keys are $\rightarrow$ $CDA$, $CDB$, $CDE$.

Now, in this case, each attribute is a prime attribute. So, this realtion is already in 3NF and there is no point in decomposing this further.

Therefore, no additional relations are required.

So, the correct answer to this question will be 0.

0 votes
0 votes

4 table are required.

Related questions

0 votes
0 votes
1 answer
1
1 votes
1 votes
1 answer
3