Question
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 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 scriptso 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
Script
/* 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:
Solution.docx.