Querying a Database Using Joins and Subqueries

Part 1

Perform a backup of the database using mysqldump before continuing. Do not overwrite the previous backup. There is no need to restore from the backup unless you run into problems in the following parts of the assignment.

Part 2

Add additional tables to the volunteer database to track hours worked per week by the volunteers and amounts of funds raised. Remember to design the tables with appropriate primary and foreign keys so you can relate these records to volunteers in the Person table. Each table should include a column to hold a date to identify the start of the week. Insert data into these tables (at least 10 rows). Submit SQL statements with this assignment. Include a screen shot showing the successful insertion of the rows into the tables.

Part 3

Create 3 queries using SQL JOINs involving two or more tables to display information for all volunteers. Submit the text of the queries and results, in addition to screen shots when you turn in the assignment.

Part 4

Write a brief paper describing the tables added in Part 2. Describe the structure of the tables including the column types and the keys (primary and foreign). Discuss the role of the keys in a SQL JOIN like the ones you have written for Part 3 of this assignment. 

#Querying #Database #Joins #Subqueries

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions