Problem
1. What transformations of data will need to be made before the QACS-DW database can be loaded with data? List all the transformations, showing the original format of the QACS and how it appears in the QACS-DW database.
2. Write the complete set of SQL statements necessary to load the transformed data into the QACS-DW database.
3. Populate the QACS-DW database, using the SQL statements you wrote to answer part A.
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.