The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
+17 votes
1.4k views

Which one of the following statements about normal forms is $\text{FALSE}?$

 

  1. $\text{BCNF}$ is stricter than $3NF$

  2. Lossless, dependency-preserving decomposition into $3NF$ is always possible

  3. Lossless, dependency-preserving decomposition into $\text{BCNF}$ is always possible

  4. Any relation with two attributes is in $\text{BCNF}$

 

asked in Databases by Veteran (69k points)
edited by | 1.4k views

1 Answer

+24 votes
Best answer
option $C$
answered by Veteran (12.1k points)
edited by

why dependency preserving decomposition into 3NF is always possible?

I found that indeed it is true that a dependency preserving, lossless join decomposition into 3NF is always possible. here is link. (2nd point)

but, option (c) is about BCNF, which is not true always in case of BCNF
How option D is true?


Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

33,687 questions
40,230 answers
114,268 comments
38,795 users