Database - Database Design Using Normalization - Discussion
Discussion Forum : Database Design Using Normalization - True or False (Q.No. 4)
4.
We have normalized a table into BCNF if all candidate keys are determinants.
Discussion:
5 comments Page 1 of 1.
Shruti Madan said:
1 decade ago
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.
Mohamed said:
10 years ago
Candidate keys are all keys that can be a primary key.
In BCNF only the chosen primary key(s) are determinants.
In BCNF only the chosen primary key(s) are determinants.
Stefan said:
1 decade ago
A relation is in BCNF is, and only if, every determinant is a candidate key.
Answer should be true!
Answer should be true!
Neha said:
1 decade ago
All determinats must be the candidate keys!
Seema said:
8 years ago
What is determinant?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers