576 views
1 votes
1 votes
Consider the relation $R(A,B,C,D,E)$ with $FD\{ A\rightarrow C, D\rightarrow CE\} $. Which of the following decomposition is in 3NF?

(A) $R_1(A,C); R_2(B,E); R_3(A,B,D)$
(B) $R_1(A,C); R_2(D,C,E); R_3(A,B,D)$
(C) Already is in 3NF
(D) None of these

2 Answers

1 votes
1 votes
$R(A,B,C,D,E)$ with $FD\{ A\rightarrow C, D\rightarrow CE\} $.where ABD is candidate key. is only in 1nf.

$R_1(A,C); R_2(D,C,E); R_3(A,B,D)$ is in BCNF but not lossless decompostion , but quetion ask only 3NF no matter lossless or lossy so this is answer
0 votes
0 votes

Option B will be right option for it

Ck::ABD

PD=A->D,D->CE

So it is by default in 1NF

for converting it into 2NF we take closure of the A+ and D+

then we remove transitive dependency if any exist

then resulting table will be

R1(AC),R2(DCE) and R3(ABD) -->3NF

Related questions

5 votes
5 votes
2 answers
3
learncp asked Aug 31, 2015
1,031 views
Is the following type of dependencies allowed in 3NF- ?A >Bwhere A is a proper subset of CKand    B is proper subset of another CK.
6 votes
6 votes
4 answers
4
learncp asked Aug 31, 2015
19,608 views
3NF is inadequate in situations where the relation:A. has multiple candidates keyB. has candidate key that are compositeC. has overlapped candidate keysD. all the above