Computers and Technology, 21.01.2021 22:50 Twivo2353

Querying Databases (70 Points) This Critical Thinking Assignment requires you to use the SQL Server instance named SQLSERVERCSU and the HandsOnOne database and tables that 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 Query Editor throughout this exercise. 1.Construct and execute INSERT 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 Co. 2 2 Jake Harper 4 3 Elizabeth Harper 1 4 Abacus Consulting 3 Additional Sample Data for the Address Table AddressID Street City State Zip Code 1 2400 Broadway New York NY 11201 2 320 21st Street Atlanta GA 30322 3 439 Skyline Blvd Seattle WA 98101 4 56 Park Avenue Dallas TX 75201
2.Construct and execute a 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.
3.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 state 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.
4.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.
5.Your final step in this assignment is to compose a one page report that outlines your experience completing this assignment. Which task was the most difficult for you? Which was the easiest? Your repost should follow CSU-Global Guide to Writing and APA Requirements. After you have completed this Critical Thinking Assignment, submit one MS Word document that contains the three screenshots and the written report. Insert all of the screenshots into the document, label each of them clearly, and include the 1 page report below the screenshots; then upload this single MS Word document in the assignment page.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 10:40

Program using c++ only on visual studio pig is a simple two player dice game, played with one die. the first player to reach or surpass 50 is the winner. each player takes a turn rolling the dice. they add to the pot with each roll, having to decide to roll again and increase the pot, or cash out. the risk being they could lose the amount they’ve accumulated into the pot. the rules for each player’s die roll. 1. roll the dice. a. if user rolled a 1, i. the pot gets set to zero ii. the other player goes to step 1. b. a roll of 2-6 is added to the pot. 2. user can choose to hold or roll again. a. choice roll. return to step 1. b. choice hold. i. increment player score by the pot amount. ii. pot gets set to 0. iii. second player gets to roll and goes to step 1. program requirements: ● before each opponent begins ○ output the score for the person and the computer. ○ output the opponents whose turn is beginning and ask the user to hit enter to continue. ● with each dice roll. ○ output the die value, and amount of the round pot. ○ if it’s the users roll ask if they want to roll again ( r ) or hold ( h ). your program should allow r, r, h or h as valid input. if input is anything else, ask the user again until valid input is obtained. ○ the ai will continue playing until the round pot is 20 or more. ● once a player’s score is greater or equal to 50 then they have won, it will no longer ask if they want to keep rolling the die or not. ● once there is a winner ○ score totals are output along with who the winner was. user or computer ○ player is asked if they want to play again y or n. valid input should be y, y, or n, n. ● when a new game starts the starting roll goes to the player that did not roll last. if the user rolled last in the previous game, then the computer rolls first and vice versa. when the program first begins, the player will make the first roll of the first game. development notes : ● you will need a way to roll dice in your program. the rand() function works well, but returns an integer. if we want numbers 0 – 9 we can get the value modulus 10. ● call srand() with a value to seed it. it’s common to seed it with the current computer clock, include ctime, and then call srand(time(

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:30

Which component acts as a platform on which application software runs

Answers: 2

Answer

Computers and Technology, 23.06.2019 07:50

Most shops require the technician to enter a starting and ending time on the repair order to track the actual time the vehicle was in the shop and closed out by the office. this time is referred to as _ time ? a. comeback b. ro c. cycle d. lead

Answers: 1

Answer

Computers and Technology, 23.06.2019 13:30

Font size, font style, and are all aspects of character formatting.

Answers: 2

Answer

You know the right answer?

Querying Databases (70 Points) This Critical Thinking Assignment requires you to use the SQL Server...

Questions