Multiple Choice
A relation is in domain/key normal form if ________.
A) every key of the relation is a logical consequence of the definition of constraints and determinants
B) every key of the relation is a logical consequence of the definition of constraints and domains
C) every constraint on the relation is a logical consequence of the definition of keys and determinants
D) every constraint on the relation is a logical consequence of the definition of keys and domains
E) every domain of the relation is a logical consequence of the definition of keys and constraints
Correct Answer:
Verified
Correct Answer:
Verified
Q6: A referential integrity constraint limits the values
Q10: A deletion anomaly exists when deleting data
Q13: A surrogate key is an artificial column
Q29: Given the functional dependency A → B,then
Q55: Given the functional dependency A → (B,
Q61: Functional dependencies can involve groups of attributes.
Q62: Explain the terms relation,tuple,and attribute.
Q64: A relation is in second normal form
Q72: A combination of one or more columns
Q77: Every time we break up a relation