Description
SQL Statements
In this assignment, you will practice writing SQL statements.
Create scripts of SQL statements for the following situations:
- Add a minimum of five clients, three sales people, ten contacts, and at least one contact summary for each client to your database that you created in W3 Assignment 2. Every sales person must have at least one client.
- Query your database to produce all the clients for one of the sales people that are assigned to multiple clients.
- Produce a full client list by sales person.
- Add a contact summary to one of your clients, then modify it, and then delete it.
In a Microsoft Word document, create a report that outlines the steps you took to create these scripts. Include the scripts in the report along with a description of the results that you achieved. With your results, include screen shots showing your results.
Explanation & Answer
Hello check the solution
SQL Statements
Steps in creating the scripts
The solution started by populating all of the respective tables. The tables were populated with
enough data rows as shown below.
Figure 1 client table
Figure 2 salesperson table
Figure 3 contact informa...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
We Were Eight Years in Power
by Ta-Nehisi Coates
The Prince
by Niccolò Machiavelli
Sounds Like Titanic
by Jessica Chiccehito Hindman
12 Rules for Life
by Jordan Peterson
Unf*ck Yourself
by Gary John Bishop
Girl Stop Apologizing
by Rachel Hollis
Extreme Ownership - How US Navy SEALs Lead and Win
by Jocko Willink and Leif Babin
My Brilliant Friend
by Elena Ferrante