Register

Normalization

847 views
2 votes
2 votes

Which of the following statement false is relation R is in 3NF but not BCNF?

A) Relation R must consist atleast two over-lapped candidate keys.

B) Relation R must consist proper subset of candidate key determines proper subset of some other candidate key.

C) Relation R must consist atmost one compound candidate key and other candidate keys simple candidate key.

D) Relation R must consist atleast two compound candidate keys.

Someone please explain what does Option A refers here.......i.e overlapped candidate keys

User Avatar

Please log in or register to answer this question.

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

Related questions

1 votes
1 votes
1 answer
1
vijju532 asked Jun 23, 2018
530 views
normalization
proof that a relation with the two attribute is always in BCNF....
proof that a relation with the two attribute is always in BCNF....
User Avatar
2 votes
2 votes
2 answers
2
pradeepchaudhary asked Jun 8, 2018
1,832 views
NORMALIZATION
Given: The Relation R(A,B,C,D,E) having (A,B) as Primary key. The set of functional dependencies: (A,C)-->D , (B,D)-->E. I want to Know whether the functional dependencies Given above are Partial FD's or Not?
Given: The Relation R(A,B,C,D,E) having (A,B) as Primary key. The set of functional dependencies: (A,C) >D , (B,D) >E. I want to Know whether the functional dependencies ...
User Avatar
0 votes
0 votes
1 answer
3
Mk Utkarsh asked Nov 24, 2017
615 views
Normalization
Please explain with example how lossless decomposition into BCNF is possible but dependency preservating BCNF decomposition may not be possible for all relations?
Please explain with example how lossless decomposition into BCNF is possible but dependency preservating BCNF decomposition may not be possible for all relations?
User Avatar
0 votes
0 votes
2 answers
4
Souvik33 asked Dec 17, 2022
805 views
Database Relations | Heighest normal form
MSQ A relation R(A,B,C,D) has only trivial functional dependencies of the form ( A→A, AB→AB,ABC→A, etc) Then consider the following options: The relation is surely in BCNF The relation is surely in 3NF The relation is surely in 2NF None of the above
MSQ A relation R(A,B,C,D) has only trivial functional dependencies of the form ( A→A, AB→AB,ABC→A, etc)Then consider the following options:The relation is surely in...
User Avatar
Link Copied!