Table Relationships

1. This relationship is established when one record in a table has only one matching record in another table.

One-to-one

One-to-many

Many-to-many

2. Table relationship is what makes a database relational.

True

False

3. This relationship is established when one record from a table is related to many matching records in other tables.

One-to-one

One-to-many

Many-to-many

4. It updates all related records in the related table or tables when a record in the primary table is changed.

Cascade delete

Cascade update

Referential integrity

5. This feature enables deletion of all related records in the related tables when a record in the primary table is deleted.

Referential Integrity

Cascade delete related records

Cascade update related fields

6. We can edit an existing relationship by clicking TOOLS then ____________.

Relationships

Primary Key

Records

7. This feature ensures that relationships between records in related tables are valid and and that you don't accidentally delete or change related data.

Referential Integrity

Cascade Update Related Fields

Cascade Delete Related Records

8. A one-to-many relationship is created if only one of the related columns is a ___________.

Records

Relationships

Primary key

9. It is an association between two tables in which one record in either table can relate to many records in the other table.

One-to-one

One-to-many

Many-to-many

10. Table relationships can be enforced without activating cascade update related fields and cascade delete related records.

True

False

Table Relationships

1. This relationship is established when one record in a table has only one matching record in another table.

2.

What first name or nickname would you like us to use?

2. Table relationship is what makes a database relational.

3. This relationship is established when one record from a table is related to many matching records in other tables.

4. It updates all related records in the related table or tables when a record in the primary table is changed.

5. This feature enables deletion of all related records in the related tables when a record in the primary table is deleted.

6. We can edit an existing relationship by clicking TOOLS then ____________.

7. This feature ensures that relationships between records in related tables are valid and and that you don't accidentally delete or change related data.

8. A one-to-many relationship is created if only one of the related columns is a ___________.

9. It is an association between two tables in which one record in either table can relate to many records in the other table.

10. Table relationships can be enforced without activating cascade update related fields and cascade delete related records.