Question: To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. 1. Write

To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. 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: Todays 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: rick@raven.com 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 rick@raven.com. 9. Write an UPDATE statement that modifies the Customers table. Change the password column to reset for every customer in the table. 10. Open the script named CreateMyGuitarShop.sql thats in the Exercise Starts directory. Then, run this script. That should restore the data thats in the database.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

\ -- Chapter 5 Homework Insert, update, and delete data Use your copy of the my_guitar_shop database: _mgs If you need to restore the database to the original state, you can modify and run the...

Insert, update, and delete data Use your copy of the ap database: _ap If you need to restore the database to the original state, you can modify and run the create_db_ap script to restore it. To test...

HW5: Chapters 7&8 How to insert, update, and delete data Exercises To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT...

Chapter 7 How to insert, update, and delete data Exercises To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. * *...

Lab Assignment 6: The purpose of this assignment is to demonstrate that you can execute statements that are used to add, change, and delete data in relational database tables. These problems require...

Note that Problems 5-9 may refer to the invoice_id created in Problem 4: you can get that by visually inspect the invoice_id created in the query for Problem 4. To test whether a table has been...

that Problems 5-9 may refer to the invoice_id created in Problem 4: you can get that by visually ipect the invoice_id created in the query for Problem 4. To test whether a table has been modified...

answer this by SQL Language, and show the screen shot for the work and run on your computer. Thank you. To test whether a table has been modified correctly as you do these exercises, you can write...

To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. 1 . Write an INSERT statement that adds this row to the...

Assume that a country produces and consumes two goods, cloth and machines, and is in equilibrium in autarky. It now finds that it can trade at international prices where (Pcloth/Pmachines) on the...

Can you tell whether f (x) exists from a plot of f (x) for x > 5? Explain. lim

Suppose that Mr . Smith bought common stock from AirPower, a green energy startup. Which of the following statements regarding Mr . Smith's rights with the respect to AirPower are accurate? Check all...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

What is the difference between Needs and GAP Analyses?

What are ERP suites? Are HCMSs part of ERPs?

An economy is operating with output $400 billion below its natural rate, and fiscal policymakers want to close this recessionary gap. The central bank agrees to adjust the money supply to hold the...