Construct and execute insert sql statements

Assignment Help Database Management System

Reference no: EM132109286

Project : Creating Databases and Tables, based on p. 195 of the MCSA guide to Microsoft^® SQL server 2012textbook.

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.

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:

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

Construct and execute a SQL query to list all customers with their corresponding cities and states. The list should be sorted in ascending numerical order by ZIP code, followed by customer name alphabetically. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully.

Construct and execute a SQL Query to list the Street, City, State, and Zip Code of all addresses that do not have a customer associated with them. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully.

Construct and execute a SQL query to count the number of customers in each state. The list should be ordered by the number of customers in descending order, then by zip code in ascending order. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully.

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.

Construct and execute a SQL query to list the full names of all customers who have Harper in their name. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully.

Your final step in this assignment is to compose a report of 1-page minimum in length that outlines your experience completing this assignment. Which task was the most difficult for you? Which was the easiest? Your report should follow the CSU-Global Guide to Writing and APA.

Deliverable

After you have completed these steps, submit a single MS Word document that contains the screenshots and the written report. Insert all of the screenshots into the document, label each of them clearly, and include the information for the report below the screenshots.

Reference no: EM132109286

Questions Cloud

Research center at federal reserve : The Research Center at Federal Reserve looks at one key variable for policy makers in setting interest rates to maintain stable inflation. What is that variable

Display a menu to the user on the screen : Define a class called Dog, where a Dog is-a subclass of Animal. Also, a Dog can run (i.e. this class should implement the Runner interface).

Unanticipated dollar appreciation : After an unanticipated dollar appreciation has occurred, what recommendation a company such as Cummins Engine to do with its strong domestic currency?

Billions of shoppers worldwide : An online shopping tax punishes Aussie consumers and denies shoppers the same choice available to billions of shoppers worldwide.

Construct and execute insert sql statements : Construct and execute INSERT SQL statements to add the sample data in the following tables to the Customer and Address tables.

Describe your findings in your eportfolio : Assignment - Paperback Zone - ITECH1100 Understanding the Digital Revolution - Andres and Benjamin want to improve the consistency of how they pay

Write a function printarray to print the hexadecimal numbers : Create a .bmp file, called myBmp.bmp, that stores the 4x3 image shown in Figure 4, where the 24-bit color code marked in each component.

Calculate the volume of a cylinder tank : Write a MATLAB program that calculates the volume of a cylinder tank by receiving the radius,height, & time from the user and calculates the volume of a liquid.

Should all countries have the same environmental standards : Should all countries have the same environmental standards? What about the same labor standards? Justify your answers.

User Account

All Pages