SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 29 Nov 2017 My Price 10.00

SQL Server instance named SQLSERVERHOA,

Question:I have the following assignment due 6/4/17. I have completed step 1, but am including it because it's important to the other step I need help with. This is for SQL Server. I have attached the code that I have for question 2. STEP ONE DOES NOT NEED TO BE COMPLETED. Thank you :)

 

This Critical Thinking Assignment requires you use the SQL Server instance named SQLSERVERHOA, and the HandsOnOne database and tables you created in Modules 1 and 3, respectively. The objective of this activity is to hone your skills at manipulating data using SQL DML statements. Use the Query Editor throughout this activity.

  1. Construct and execute INSERT SQL statements to add the sample data in the following tables to the Customer and Address tables in the HandsOnOne database:
  2. Construct and execute a SQL query to change Alice Harper’s address to 320 21st St, Billing, MT 59101. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully.

Additional Sample Data for Customer Table

 

CustomerID        CustomerName

CustomerAddressID

1

Western Supply Company

1

2

Nick Harper

3

3

Alice Harper

3

4

Abacus Consulting

4

Additional Sample Data for the Address Table

 

AddressID Street

City

State

Zip Code

1

2400 Broadway Drive

Missoula

MT

59802

2

320 21st Street

Billings

MT

59101

3

439 Skyline Blvd

Denver

CO

80002

4

56 Park Avenue

New York

NY

10001

 

 

 

Module 4.JPG

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 29 Nov 2017 11:11 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)