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.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.
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.

Stefan said:   1 decade ago
A relation is in BCNF is, and only if, every determinant is a candidate key.

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:

Your comments will be displayed after verification.