1. What transformations of data will need to be made before the GG-DW database can be loaded with data? List all the transformations, showing the original format of the GARDEN_GLORY data and how it appears in the GG-DW database.
2. Write the complete set of SQL statements necessary to load the transformed data into the GG-DW database.
3. Populate the GG-DW database, using the SQL statements you wrote to answer part A.
4. Write an SQL query similar to the one shown in the text on page 420 that uses the hours worked per day as the measure.