E. Create database named QACS in your DBMS.

F. Create a folder in your My Documents folder to save and store *.sql scripts containing the SQL statements that you are asked to create in the remaining questions in this section.

For the SQL Server Management Studio, create a folder named QACS-Database in the Projects folder structure in your My Documents folder.

In the Oracle SQL Developer folder structure in your My Documents folder, create a folder named QACS-Database.

For the SQL Workbench, create a folder named QACS-Database in the Schemas folder in your My Documents folder.

G. Write SQL CREATE TABLE statements for each of these tables. 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.

H. Explain how you would enforce the data constraint that SALE_ITEM.UnitPrice be equal to ITEM.ItemPrice, where SALE_ITEM.ItemID = ITEM.ItemID.