If you have not already implemented the Morgan Importing database shown in Chapter 7 in a DBMS product create and populate the Mi database now in the DBMS of your choice (or as assigned by your instructor). James Morgan wants to analyze shipper performance based on the difference between a shipment's scheduled departure date and the actual departure date. This value will be named Departure Delay with the values measured in days. The values of Days can be positive (the shipment departed later than the scheduled departure date). zero (the shipment departed on the scheduled departure date), or negative (the shipment departed before the scheduled departure date). Because Morgan Importing purchasing agents are responsible for contacting the shippers and arranging the shipments, James also wants an analysis of purchasing agents' performance based on the same measure. A. Design a data warehouse star schema for a dimensional database named MI_DW. The fact table measure will be Departure Delax (the difference between Scheduled DeraduceDate and ActualDeparture 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). B. Create the MI_DW database in a DBMS product. 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 D. Write the complete set of SQL statements necessary to load the transformed data into the MI_DW database. E. Populate the MI_DW database using the appropriate Ml database data or transformations of that date C