Multiple Choice
A relation is in third normal form (3NF) if and only if it is in 2NF and ________.
A) all non-key attributes are determined by the entire primary key
B) there are no non-key attributes determined by another non-key attribute
C) every attribute is a candidate key
D) every candidate key is a determinant
Correct Answer:
Verified
Correct Answer:
Verified
Q47: Explain the concept of a surrogate key.
Q48: Candidate keys are called interlocking candidate keys
Q49: A key can be composed of a
Q50: Suppose that you need to update one
Q51: Having to enter facts about two entities
Q53: A relation is in second normal form
Q54: In relational terms as defined by E.F.Codd,a
Q55: Given the functional dependency A → (B,
Q56: The multivalued dependency noted as A →
Q57: Which of the following is NOT true