Discussion :: Database Design Using Normalization - True or False (Q.No.4)
We have normalized a table into BCNF if all candidate keys are determinants.
Answer: Option B
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:
Email : (optional)
» Your comments will be displayed only after manual approval.