Problem
1. You need about 30 PURCHASE transactions in the database. Write the needed SQL statements for any needed additional PURCHASE transactions and insert the data into your database.
2. Design a data warehouse star schema for a dimensional database named QACS-DW. The fact table measure will be ItemPrice.
3. Create the QACS-DW database in a DBMS product.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.