How JustAnswer Works:
  • Ask an Expert
    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: 1757
Experience:  M.S. in Internet Information Systems
Type Your Homework Question Here...
TheDoctor is online now
A new question is answered every 9 seconds

**FORTHEDOCTOR**SQL StatementsIn this assignment, you

This answer was rated:


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
Hi, I'm Josie and I am a moderator for this topic. I sent your requested professional a message to follow up with you here, when he is back online.

If I can help further, please let me know. Thank you for your continued patience.
Hello again! Thank you for requesting me!

I will contact you once this is complete.
Hello again,

By when do you need this?
Customer: replied 4 years ago.

By Monday July 1,2013

Thank you. I will contact you once this is complete.
Customer: replied 4 years ago.


You're welcome.

You need to spend $3 to view this post. Add Funds to your account and buy credits.
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1757
Experience: M.S. in Internet Information Systems
TheDoctor and 2 other Homework Specialists are ready to help you