Matching
Match the following terms with their definition.
Premises:
Normalization
One-to-one relationship
Referential integrity
Many-to-many relationship
Cascade Update
Responses:
The process of minimizing the duplication of information
A maximum of one
Makes necessary changes throughout all related tables to ensure data integrity
Needs to use an intermediate table
Ensures that relationships between tables remain consistent
Correct Answer:
Premises:
Responses:
Normalization
One-to-one relationship
Referential integrity
Many-to-many relationship
Cascade Update
Premises:
Normalization
One-to-one relationship
Referential integrity
Many-to-many relationship
Cascade Update
Responses:
Related Questions
Q29: All information about a database's table joins
Q30: The AutoNumber data type is best used
Q31: Tables have _ view(s).<br>A) two<br>B) three<br>C) four<br>D)
Q32: Tables have two views: Datasheet view and
Q33: A(n)_ is a link between tables.<br>A) field<br>B)
Q35: Match the following terms with their definition.
Q36: The Description property in a table's Design
Q37: An appropriate example of the type of
Q38: An entity is a characteristic of an
Q39: To copy and paste from Excel into