Cash-back offer from March 22nd to 31st, 2024: Get a flat 10% cash-back credited to your account for a minimum transaction of $50.Post Your Questions Today!

Question DetailsNormal
$ 20.00

SQL Server 2012 Chapter 7 assingment! (my guitar shop hw assignment)

Question posted by
Online Tutor Profile
request

1.      Write an INSERT statement that adds this row to the Categories table:

CategoryName:            Brass

Code the INSERT statement so SQL Server automatically generates the value for the CategoryID column.

2.      Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the CategoryName column to “Woodwinds”, and it should use the CategoryID column to identify the row.

3.      Write a DELETE statement that deletes the row you added to the Categories table in exercise 1. This statement should use the CategoryID column to identify the row.

4.      Write an INSERT statement that adds this row to the Products table:

ProductID:                   The next automatically generated ID CategoryID:                 4 ProductCode:               dgx_640 ProductName:              Yamaha DGX 640 88-Key Digital Piano Description:                 Long description to come. ListPrice:                      799.99 DiscountPercent:          0 DateAdded:                 Today’s date/time.

Use a column list for this statement.

5.      Write an UPDATE statement that modifies the product you added in exercise 4. This statement should change the DiscountPercent column from 0% to 35%.

6.      Write a DELETE statement that deletes the row in the Categories table that has an ID of 4. When you execute this statement, it will produce an error since the category has related rows in the Products table. To fix that, precede the DELETE statement with another DELETE statement that deletes all products in this category.

7.      Write an INSERT statement that adds this row to the Customers table:

EmailAddress:             Password:                    (empty string) FirstName:                   Rick LastName:                   Raven

Use a column list for this statement.

8.      Write an UPDATE statement that modifies the Customers table. Change the password column to “secret” for the customer with an email address of .

9.      Write an UPDATE statement that modifies the Customers table. Change the password column to “reset” for every customer in the table.

10.  <<You don’t need to show this in your homework, but you should do it.>> Open the script named CreateMyGuitarShop.sql that’s in the Exercise Starts directory. Then, run this script. That should restore the data that’s in the database.

 

 

 

 

Available Answer
$ 20.00

[Solved] SQL Server 2012 Chapter 7 assingment! (my guitar shop hw assignment)

  • This Solution has been Purchased 1 time
  • Submitted On 22 Feb, 2017 03:12:45
Answer posted by
Online Tutor Profile
solution
1.      Write an INSERT statement that adds this row to the Categories table: CategoryName:            Brass Code the INSERT statement so SQL Server automatically generates the value for the CategoryID column. 2.      Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the CategoryName column to “Woodwinds”, and it should use the CategoryID column to identify the row. 3.      Write a DELETE statement that deletes the row you added to the Categories table in exercise 1. This statement should use the CategoryID column to identify the row. 4.      Write...
Buy now to view the complete solution
Other Similar Questions
User Profile
Acade...

SQL Server 2012 Chapter 7 assingment! (my guitar shop hw assignment)

1.      Write an INSERT statement that adds this row to the Categories table: CategoryName:            Brass Code the INSERT statement so SQL Server automatically generates the value for the CategoryID colum...
User Profile
DEEPE...

SQL Server 2012 Corporate Proposal

SQL Server 2012 Corporate Proposal   SQL Server 2012 Corporate Proposal Overview ESL Inc. is a large company that has been using a series of spreadsheets, access databases, and manual records to keep track of the m...
User Profile
Acade...

SQL Server 2012 Corporate Proposal

ESL Inc. is a large company that has been using a series of spreadsheets, access databases, and manual records to keep track of the majority of the organization’s internal and customer data. They have grown significantly ov...

The benefits of buying study notes from CourseMerits

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35