2013

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.

2014

Delete the relationship between the Rents and Terms and Conditions tables.

2074

Create a one-to-one relationship between the Code fields of the Products and the ProductsPhoto tables. Do NOT enforce the referential integrity.

2075

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.

2076

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.

2077

Create a one-to-many relationship between the CustomersCode fields of the Customers and Rents table. Enforce the referential integrity.

2143

Create a relationship between the IDCustomer field of the Customers table and the CustomerID field of Orders table. Enable the referential integrity.

2144

Create a one-to-one relationship between the two IDCustomer fields of the Customers and CustomersComments tables.

2189

Delete the relationship between the Products and Orders tables. Save the changes.

2198

Modify the Personel_q query so that it displays the employee in the first field and his/her manager in the second field of the query. Save and close the query.

2209

Create a one-to-many relationship between the CustomersCode fields of the Customers and Rents tables. Enable the referential integrity and make sure that field updates and record deletions are allowed. Apply the appropriate join type to make sure that all records of the Rents table are included.

2210

Create a relationship between the RentTerms fields of the Terms and Conditions and Rents tables. Apply the appropriate join type to make sure that all records of the Rents table are included.

2775

Create a relationship between the Customers and Products tables using the Orders table as Link table.

2776

Delete all records from the Products table without deleting the existing records from the Orders table.

2777

Modify the relationship between the Products and ProductsPhoto tables so that changes to the Code field of the Products table are reflected to the respective record in the ProductsPhoto table. Make sure the same condition applies to the deletion of records.

2791

Create a relationship between the Customers and Categories tables. Enable the referential integrity.

2813

Modify the type of the Type field of Orders table in the appropriate way to create a relationship between this field and the IDTypeOrder field of the TypeOrders table. Activate the referential integrity. Save the changes.