1. You need about 20 SERVICE transactions in the database. Write the needed SQL statements for any needed additional SERVICE transactions and insert the data into your database.
2. Design a data warehouse star schema for a dimensional database named GG-DW. The fact table measure will be HoursWorked.
3. Create the GG-DW database in a DBMS product.