Create a one-to-many relationship, enforcing referential integrity and cascade on update,

to ensure that no doll can be in the database unless its manufacturer is in the database.

(10 points)

Write a query listing the character, manufacturer, country of manufacture, and price for the 3 cheapest dolls. The query shall list the dolls in order of increasing price. (10 points)

Write a query listing the dolls and their manufacturer; the query shall output the doll

name, the manufacturer, and the opening year of that manufacturer. The query shall output these items only if the manufacturer is in China and is the subject of lawsuits. (10 points)

Ditils Mill Manufacturers x Ditils Mill Manufacturers x