Create a one-to-many relationship between the CID field of the Customers table and the CustomersID field of the Rents table. Set update options to Update and Delete cascade.
Delete the relationship between the Rents and RentTerms tables.
Create a one-to-one relationship between the ID field of the ProductsPhoto and the Products tables. Do NOT set update and delete cascade options.
Create a one-to-one relationship between the ID fields of the ProductsPhoto and the Products tables. Set the update cascade option but not the delete cascade option.
Create a one-to-many relationship between the CID fields of the Customers and CustomerID of the Rents table. Set Update cascade and Delete cascade options.
Delete the relationship between the Products and Orders tables. Save the changes.
The creation of relationships between tables contained in a database allows…
Creating related tables in a database allows …
What is the purpose of creating a relationship between tables contained in a database?
In what case are records from related tables with primary keys not allowed to be deleted?
What are the referential integrity rules between related fields, assure us?
What is the purpose of creating a relationship between tables?
What are related tables used for?