Multiple Choice
A relation is in second normal form (2NF) if and only if it is in 1NF 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
Q6: A referential integrity constraint limits the values
Q10: A deletion anomaly exists when deleting data
Q25: In functional dependencies,the attribute whose value is
Q49: A key can be composed of a
Q55: Given the functional dependency A → (B,
Q61: Functional dependencies can involve groups of attributes.
Q61: In a relation _.<br>A)entities in a column
Q62: Explain the terms relation,tuple,and attribute.
Q67: A relation is in domain/key normal form
Q77: Every time we break up a relation