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

Table of Contents

Calculate your order
Pages (275 words)
Standard price: $0.00

Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

Review of Case Studyview of Case Studyvi

Description Rewrite and modified Section B (a), (b), (c). 1. ‘Section B: (b) Use psychological research and literature to suggest an approach which will help

New questions

Don't Let Questions or Concerns Hold You Back - Make a Free Inquiry Now!