A. You need about 30 SHIPMENT transactions in the database. Write the needed SQL statements for any needed additional SHIPMENT transactions, and insert the data into your MI database. B. Design a data...

A. You need about 30 SHIPMENT transactions in the database. Write the needed SQL statements for any needed additional SHIPMENT transactions, and insert the data into your MI database.

B. Design a data warehouse star schema for a dimensional database named MI_ DW. The fact table measure will be Departure Delay (the difference between Scheduled Departure Date and Actual Departure Date). Dimension tables will be TIMELINE, SHIPMENT, SHIPPER, and PURCHASING_AGENT (PURCHASING_AGENT is a subset of EMPLOYEE containing data on only the employees who are purchasing agents).

C. Create the MI_DW database in a DBMS product.

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