Register

NIELIT 2016 DEC Scientist B (IT) - Section B: 44

• retagged by
1,497 views
2 votes
2 votes

Which one of the following statements about normal forms is FALSE?

  1. BCNF is stricter than $3$NF.
  2. Lossless, dependency-preserving decomposition into BCNF is always possible.
  3. Lossless, dependency-preserving decomposition into $3$NF is always possible.
  4. Any relation with two attributes is BCNF.
• retagged by
User Avatar

2 Answers

4 votes
4 votes

Option B.Lossless,dependency preserving decomposition into BCNF is always possible

Lossless,dependency preserving decomposition into BCNF is not always possible.

User Avatar
0 votes
0 votes

Lossless,dependency preserving decomposition into BCNF is not always possible

it is always poosible in 3nf or lower level normal form .

so correct ans is : B

User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
2 answers
1
admin asked Mar 31, 2020
907 views
NIELIT 2016 DEC Scientist B (IT) - Section B: 14
Normalization from which is based on transitive dependency is classified as: First normal form. Second normal form. Fourth normal form. Third normal form.
Normalization from which is based on transitive dependency is classified as:First normal form.Second normal form.Fourth normal form.Third normal form.
User Avatar
0 votes
0 votes
2 answers
2
admin asked Mar 31, 2020
3,418 views
NIELIT 2016 DEC Scientist B (IT) - Section B: 40
In functional dependency between two sets of attribute $A$ and $B$ then set of attributes $A$ of database is classified as: top right side down left side left hand side right hand side
In functional dependency between two sets of attribute $A$ and $B$ then set of attributes $A$ of database is classified as:top right sidedown left sideleft hand sideright...
User Avatar
1 votes
1 votes
2 answers
3
admin asked Mar 31, 2020
4,615 views
NIELIT 2016 DEC Scientist B (IT) - Section B: 57
If attribute of relation schema $R$ is member of some candidate key then this type of attributes are classified as: atomic attribute candidate attribute non-prime attribute prime attribute
If attribute of relation schema $R$ is member of some candidate key then this type of attributes are classified as:atomic attributecandidate attributenon-prime attributep...
User Avatar
Link Copied!