Problem
1. Design a data warehouse star schema for a dimensional database named MDC-DW. The fact table measure will be ExtendedPrice.
2. Create the MDC-DW database in your DBMS product.
3. What transformations of data will need to be made before the MDC-DW database can be loaded with data? List all the transformations, showing the original format of the MDC data and how it appears in the MDC-DW database.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.