A. Write CREATE TABLE statements for each of the tables using your answers to parts A–D, as necessary. Set the surrogate key values as shown above. Use FOREIGN KEY constraints to create appropriate...

A. Write CREATE TABLE statements for each of the tables using your answers to parts A–D, as necessary. Set the surrogate key values as shown above. Use FOREIGN KEY constraints to create appropriate referential integrity constraints. Set UPDATE and DELETE behavior in accordance with your referential integrity action design. Run these statements to create the QACS tables.

B. Explain how you would enforce the data constraint that SALE _ITEM. Unit Price be equal to ITEM. Item Price, where SALE _ITEM. Item ID = ITEM. Item ID.

C. Write INSERT statements to insert the data shown in Figures 7-54, 7-55, 7-56, 7-57, 7-58, and 7-59.

D. Write an UPDATE statement to change values of ITEM .Item Description from Desk Lamp to Desk Lamps.