In this assessment, you will add two additional tables to track hours worked per week by the volunteers and amount of funds raised each week. You will then create SQL queries with JOIN clauses to retrieve information for all volunteers.
Note: Remember to design the new tables with the appropriate primary and foreign keys so you can relate these records to volunteers in the PERSON table. Each table should include an ID column as the primary key and a column to hold a date to identify the start of the week.
Instructions
Your assessment will be scored on the following criteria. Use the Weekly Solutions Submission Template to submit your assessment.
1. Create a new table named HOURS for your volunteer database. The HOURS table will be used to track hours worked per week by the volunteers.
Write and run SQL INSERT statements to insert at least 10 rows of data into the HOURS table.
2. Create a new table named FUNDS for your volunteer database. The FUNDS table will be used to track amount of funds raised per week by the volunteers.
Write and run SQL INSERT statement to insert at least 10 rows of data into the FUNDS table.
3. Write and run SQL INSERT statements to insert rows in each new table for 10 volunteers.
4. Save your SQL statements to a text file using the MySQL tee command and document the process with screenshots.
5. Reflecting on this assessment, summarize the steps taken and any issues you encountered.