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
E) every determinant is a candidate key
Correct Answer:
Verified
Correct Answer:
Verified
Q4: Surrogate keys usually slow performance.
Q28: An artificial column added to a relation
Q29: A relation is in fourth normal form
Q34: If a table is designed so that
Q35: A relation is also known as a(n)_.<br>A)table<br>B)tuple<br>C)relationship<br>D)attribute<br>E)field
Q37: A tuple is also known as a(n)_.<br>A)table<br>B)relation<br>C)row<br>D)field<br>E)file
Q41: A row can be uniquely identified by
Q56: The multivalued dependency noted as A →
Q60: A foreign key is one or more
Q71: In the functional dependency shown as A