How JustAnswer Works:

Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site.Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask TheDoctor Your Own Question

TheDoctor, Professional w/Adv. Degree

Category: Homework

Satisfied Customers: 1688

Experience: M.S. in Internet Information Systems

59032869

Type Your Homework Question Here...

TheDoctor is online now

**For TheDoctor**
I have new question. This question builds

Resolved Question:

**For TheDoctor**

I have new question. This question builds on the one from last week and uses that assignment. I have a not at the bottom following the question - it makes the answer much easier.

Here is the 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.

*****

NOTE: The instructor changed the requirements to make it easier:

"Manually create the following scripts:

INSERT SQL Scripts

In a file create the INSERT Scripts that you would use to load the data that I provided in the Week 4 Problems and Solutions Discussion Area

SQL QUERY Script

Show in a file the script that you would use to query the database for the for one of the sales people that are assigned to multiple clients

SQL QUERY Script

Show in a file the script that you would use to produce a full client list by sales person

SQL QUERY Scripts

Show in a file the scripts that you would use to add a contact summary to one of your clients, then modify it, and then delete it"

So I have pasted the original assignment above, followed by the revised requirements. If you accept this one I will need it done in the next 12 hours or so.

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.DianeDallas, TX

Ask a Tutor

Get a Professional Answer. 100% Satisfaction Guaranteed.

136 Tutors are Online Now

Type Your Homework Question Here...

characters left:

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.