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.

Cite any sources in APA format.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

The steps I took to create these scripts
o Read the request carefully
o Reconsider the model to see if it meets the new requirement
o Create a new model if this action is necessary to fulfill the task
o Open the textbook Database Processing Fundamentals, Design, and Implementation by David M. Kroenke & David J. Auer
o Read chapter 7th one more time
o Start to create these script
o Run the test to make sure everything is OK

/* select database */
USE abc_thomas;

/*add three sales people */
insert into salesperson (ID) values ('sp1');
insert into salesperson (ID) values ('sp2');
insert into salesperson (ID) values ('sp3');...

By purchasing this solution you'll be able to access the following files:

for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Upload a file
Continue without uploading

We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats