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

Instructions All information required for this assignment is provided in

  Instructions All information required for this assignment is provided in the Unit 7 Student Workbook [Excel] for this unit. Read the Peregrine case [PDF] study and complete the following requirements. Quantitative Analysis: Compute and compare the net present value and payback period of each option. Qualitative Analysis: In a

First file has guidelines and requirements. Second has tips on

First file has guidelines and requirements. Second has tips on how to write it. Third is the rubric. Fourth has 3 outline models to help you get started. (optional) Fifth and final is an example if you need some visual assistance. All in APA format please. Write about something you

This assignment is to help you to learn from an

This assignment is to help you to learn from an actual social worker in the field what social work is all about. The person has to have a degree in Social Work, not a related field. Locate someone you know already who is a social worker or contact a local agency

Metacognition

Prior to engaging in this discussion, please read “Chapter 8: Owning Our Learning Experiences” in your e-book and review the Instructor Guidance. Metacognition is the ability to be aware of and regulate one’s thought processes. It is suggested to be a process that improves our ability to effectively process information.

Recently, a terminated employee used his mobile device to log

 Recently, a terminated employee used his mobile device to log into the company network and steal sensitive data. As the manager of the information technology (IT) security department, you were asked by your boss to present a summary of what the organization should do to prevent this from happening again.

Read/review the following resources for this activity: Textbook: Chapters 9,

Read/review the following resources for this activity: Textbook: Chapters 9, 10 Lesson Minimum of 5 scholarly source (in addition to the textbook) InstructionsFirst, return to your topic chosen in the week three assignment. Answer this question: What are the personal and/or communal ethical factors that may be involved in determining

A well-designed website can help you make a good first

A well-designed website can help you make a good first impression on potential customers and it can let you know whether or not customers are happy with your goods or services. This method is used by [url=https://www.systemaniax.com/services/website/]affordable web design service[/url] to speed up the process. Additionally, it can help you

Define and describe Machine Learning in relationship to Big Data

Define and describe Machine Learning in relationship to Big Data processing and analysis with examples.  List and describe Neural Networks and Machine Learning models along with applicable areas and effectiveness to types of problems. List and describe different types of statistical methods that can be applied to Big Data analysis.

Discussion: Women’s Lives in the International Context Social conditions for

  Discussion: Women’s Lives in the International Context Social conditions for women vary from across the globe. Examples include policies, expectations and laws regarding marriage and divorce, inheritance, driving, political participation, family violence, etc.For this Discussion you will explore the world’s diversity regarding women’s social roles. To Prepare: Review this

***Please read the article “Korea” under the section “East Asia

***Please read the article “Korea” under the section “East Asia After World War II” in your Boundless World History link.  Using 2 additional sources, please write a 500 word  on Korea during this time period.  Please be sure to cite your sources. Link to reading https://www.oercommons.org/courses/boundless-world-history/view Due Friday 05/13/2022

SARS Nursing Assignment Help

 The following public health emergencies to analyze: severe acute respiratory syndrome (SARS) In a report format of 700 words, address the following: Describe the chain of command and the method of public health response that was conducted in this situation. Determine the important public health issues related to medical care

Column B total is currently 22% of Column A. I

  Column B total is currently 22% of Column A. I need Column B to be at least 50% How do I get column B to at least 50%? Format the numbers differently calculate differently the numbers column B should be in order to have column B at at least