Create a one-to-many relationship between the CustomersCode fields in the Customers and Rents tables. Enforce the referential integrity and make sure cascade updating and deleting records are enabled.
Delete the relationship between the Rents and Terms and Conditions tables.
Create a one-to-one relationship between the Code fields of the Products and the ProductsPhoto tables. Do NOT enforce the referential integrity.
Disable the referential integrity and then delete the relationship between the YearReleased fields in the Copies and the Movies tables without deleting the relationship between the respective MovieName fields.
Create a one-to-one relationship between the Code fields of the Products and the ProductsPhoto tables. Enforce the referential integrity. Enable the Cascade Update Related Fields option. Do not enable the Cascade Delete Related Records one.
Create a one-to-many relationship between the CustomersCode fields of the Customers and Rents table. Enforce the referential integrity.
Delete the relationship between the Products and Orders tables. Save the changes.
When we create a relationship between two tables we can ...
What is the purpose of creating a relationship between tables contained in a database?
What do referential integrity rules ensure when they are applied between related fields?
The creation of related tables in a database allows a user to …
The creation of relationships between tables contained in a database allows…
What are related tables used for?
What is the purpose of creating a relationship between tables?
When are we not allowed to delete records from tables related with primary keys?