1. Write the complete set of SQL statements necessary to load the transformed data into the MDC-DW database.
2. Populate the MDC-DW database, using the SQL statements you wrote to answer part G.
3. Write an SQL query similar to the one shown in the text on page 420 that uses the ExtendedPrice as the measure.
4. Write the SQL view equivalent of the SQL query you wrote to answer part I.