A. 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 QACS database. B. Design a...

A. 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 QACS database.

B. Design a data warehouse star schema for a dimensional database named QACS_DW. The fact table measure will be Item Price.

C. Create the QACS_DW database in a DBMS product.

D. What transformations of data will need to be made before the QACS_DW database can be loaded with data? List all the transformations, showing the original format of the QACS database and how it appears in the QACS_DW database.