A. Write the complete set of SQL statements necessary to load the transformed data into the MI_DW database. B. Populate the MI_DW database using the appropriate MI database data or transformations of...

A. Write the complete set of SQL statements necessary to load the transformed data into the MI_DW database.

B. Populate the MI_DW database using the appropriate MI database data or transformations of that data.

C. Write an SQL query similar to SQL-Query-CH12-02 text on page 551 that uses Departure Delay as the measure.

D. Write the SQL view equivalent of the SQL query you wrote to answer part G.