Matching
Match the following terms to their description.
Premises:
Cascade delete
Cardinality
Domain integrity
Referential integrity
Cascade update
Responses:
Requires that only values that have a corresponding value in constraints the primary table can be entered for a foreign key
Will update a foreign key automatically when the primary key changes
Rules that are specific for each field
Indicates the number of instances of one entity that relates to one instance of another entity
Will delete every record with the foreign key if the value is deleted from the primary table
Correct Answer:
Premises:
Responses:
Cascade delete
Cardinality
Domain integrity
Referential integrity
Cascade update
Premises:
Cascade delete
Cardinality
Domain integrity
Referential integrity
Cascade update
Responses:
Related Questions
Q29: _ indicate(s)the number of instances of one
Q30: Candidate keys that are not used for
Q31: Which of the following is NOT a
Q32: A(n)_ is a field that determines the
Q33: A(n)_ is a common way to visually
Q35: While several orders can be placed on
Q36: Candidate keys that are not used for
Q37: A dependency requires that the table has
Q38: An update anomaly forces you to change
Q39: _ are rules that are specific for