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

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

B. Populate the MDC_DW database using the appropriate MDC data or transformations of that data.

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

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