Here is the assignment reposted again with the additional information. Hope this

Question

Here is the assignment reposted again with the additional information. Hope this helps. I am at a standstill. I have even embedded a copy of the database that I have started. Not sure if it will transfer or not. If not I can email it needed. Thanks 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. Submission Details Name your document SU_ITS2110_W4_A2_LastName_FirstInitial.doc. Submit your document to the W4 Assignment 2 Dropbox by Tuesday, January 19, 2016. This is what I have so far… The fields are client, salesperson, contacts, Five Clients: 1112, Jones, Tom, M 1131, Smith, Brooke, L 3111, Welch, Clay, H 2131, Alexander, Megan, N 3551, Terry, Nick, R Three Sales Persons: 1111, Smith, Brad 2222, Foster, Sam 3333, Johns, Krystal Ten Contacts: 0001, Jade, Mara, A 0002, White, John, B 0003, Hamel, Luke, C 0004, Fisher, Lea, D 0005, Smith, Jacob, M 0006, Loose, Mark, N 0007, Thomas, Alex, E 0008, Reed, Anton, T 0009, Lemons, Randy, J 0010, Smith, Krystal, L Contact Summaries & Contact Information: 0001, 9362110013, Good Contact very reliable 0002, 4095601234, Good contact Semi reliable 0003, 8542319456, Hard to get ahold of 0004, 9326546587, Live in California Good Number Good Contact 0005, 9365784321, Lives in Dallas Good contact

Explanation / Answer

Please share the scripts. Will write the query.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.