Our Services

Get 15% Discount on your First Order

Querying a Database Using Joins and Subqueries

May 19, 2023

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

database, Joins, Querying, Subqueries

Share This Post

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

Related Questions

SLWK3030 Payne Chapter 1

Each student needs to create a project portfolio for a selected character from their selected movie . Selected Character: Wladyslaw Szpilman Selected Movie: Pianist (2002) The portfolio should include information on how 5 practice theories (at least one theory should be from the problem-solving group of theories, one from

Review of the television shows relate your understanding of the

From a sociological perspective the dominant group is the group that has greater (or complete access) to power. Access to power often equates to privilege, property, and prestige. The minority group is the group that has less or limited access to power. The term “minority”, from a sociological perspective, has

Future of nursing

Write a paper addressing the following questions (provide citations to references used): 1. Is individual access to health care a right or a privilege? Consider the financial implications of your response. What are the additional responsibilities of the client, the nurse and the overall healthcare system based on your stance?

Module 1 Writing Assignment In 500 words using APA format

Module 1 Writing Assignment In 500 words using APA format (remember not to exceed the threshold of 15% similarity score in turinitin) explain the following: After looking through the Container Store catalogue you discover the perfect components you didn’t know you needed to make your small living room closet more

Image Anaylys On “We Can Do It” Poster

The Thesis Is ” This Poster Is Effective Becasue Its Bold Colors Show Patriotism (Red, Blue And White And Happines ( Yellow Background), her posture communicates strength and feminism. – If You Have To Change My Thesis That Is 100% Fine With Me Page 1 Colors ( What It Means,

Modernism and its Reflection in Virginia Woolf’s ‘To the Lighthouse’, (1927)

Modernism and its Reflection in Virginia Woolf’s ‘To the Lighthouse’, (1927) Paper details Q1. Provide a general description of the the tentative project ( the titlesubjestpurposemethodology) and give a brief review of the studues you have conducted so far in this area by refering to some resources? The following are

Imagine these two scenarios: First, a man stumbles out of

Imagine these two scenarios: First, a man stumbles out of a bar, speaking loudly, trying to gain the attention of passersby by putting his arm around them to start a conversation, or remarking on the dress of another passerby. Second, a man stands outside the public library asking for

Ceramic artist: Warren McKenzie – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Palestinian-Israeli Conflict, 1948-present – Premium Paper Help

Please write 350-500 words, on the following: Topic: Describe the

Please write 350-500 words, on the following: Topic: Describe the differences between the cuisines of northern and southern United States. What factors account for the differences in the cuisines of these two areas, broadly. Your answer should include a discussion the history and geography of these regions, as well as

Please respond to the following: Many companies use their brand

Please respond to the following: Many companies use their brand as a competitive advantage. Given your knowledge about the global economy: Identify three brands you believe have the strongest likelihood of remaining a source of advantage in the 21st century and explain why. Next, explain the effects you believe

Financial Management: Organizational Financial Planning

Develop an emergency management financial plan for your organization. Provide baseline information about your organization detailing the population and general budget information. Give examples or case study information about grants or historical declaration funding that supports your financial plan. If you do not work for a a government agency, research

An understanding of one’s own approaches to leadership, motivation, collaboration, and ethical situations is important to the evolution of an effective

An understanding of one’s own approaches to leadership, motivation, collaboration, and ethical situations is important to the evolution of an effective leader. An introspective lens can help emerging leaders better understand and hone these important skills. SCENARIO Imagine that over the past few months you have participated in several organizational projects and

Behavioral Counseling Questions Nursing Assignment Help

Respond to all of these questions in your post: In the paper by Lin, what is the most compelling evidence for primary care providers to provide physical activity or dietary counseling to their patients? Considering the evidence, do you feel this type of counseling should actually be implemented in practice

You can discuss an ethical dilemma e.g. Facebook profits v.

You can discuss an ethical dilemma e.g. Facebook profits v. health and safety; Buffalo Creek profits v, safety, community responsibility etc; and then include CONSIDERATIONS IN ETHICAL DECISION SUCH AS: Who are the stakeholders who will be affected by the decision? Are there competing interests for stakeholders? Is there a

We’ve learned from the readings that creating and implementing policy

We’ve learned from the readings that creating and implementing policy to address challenges in an urban environment is far from simple. What do you believe are the most pressing urban challenges and possible policy solutions for the modern city? Defend your answer with evidence and examples from the Module readings

1- Describe the neurobiological of bipolar associated depression. Include genetics,

1- Describe the neurobiological of bipolar associated depression. Include genetics, neurotransmitters, neuroanatomical changes, current theories of the cause of the disease, and cultural factors if it’s involved.) 2- what is the neurochemistry action of lamotrigine, side effects to monitor, expected benefits for the patient, and contraindications. 3- Describe the non

Read classmates post below respond in 100 words APA format

Read classmates post below respond in 100 words APA format 7th edition This week for our discussion I chose topic 2. I personally think alcohol is a leading drug in the U.S because it is so accessible. Once a person turns 21 they are able to go and instantly start