Database - Database Design Using Normalization - Discussion

Discussion :: Database Design Using Normalization - True or False (Q.No.4)

4. 

We have normalized a table into BCNF if all candidate keys are determinants.

[A]. True
[B]. False

Answer: Option B

Explanation:

No answer description available for this question.

Neha said: (Sep 1, 2011)  
All determinats must be the candidate keys!

Shruti Madan said: (Jan 12, 2012)  
Determinant is any attritube that identifies any other attribute. So like this, a determinant can be or cannot be unique i.e. its not a compulsion for a determinant to contain atrribute (s) thet will uniquely identify each and every attribute in the entire table. But a candidate key is a key which is a set of attributes that uniquely identifies the rest of the the attributes and candidate key is a key that has the potential to become a primary key. So the reverse statement that "all candidate keys are determinants" is false because it reverses the BCNF and violates the definition of a candidate key.

Stefan said: (Oct 12, 2014)  
A relation is in BCNF is, and only if, every determinant is a candidate key.

Answer should be true!

Mohamed said: (Jan 1, 2016)  
Candidate keys are all keys that can be a primary key.

In BCNF only the chosen primary key(s) are determinants.

Seema said: (Nov 15, 2017)  
What is determinant?

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.