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: *category_id: 4 category_name: Brass Code the INSERT statement as part of a script so Oracle commits the change. 2. Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the product_name column to Woodwinds, and it should use the category_id 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 category_id column to identify the row. 4. Write an INSERT statement that adds this row to the Products table: product_id: 11 category_id: 4 product_code: dgx_640 product_name: Yamaha DGX 640 88-Key Digital Piano description: Long description to come. list_price: 799.99 discount_percent: 0 date_added: 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 discount_percent column from 0% to 35%. 6. Write a DELETE statement that deletes the row that you added to the Categories table in exercise 1. 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. (Remember that to code two or more statements in a script, you must end each statement with a semicolon.) 7. Write an INSERT statement that adds this row to the Customers table: customer_id: 9 email_address: rick@raven.com password: sesame first_name: Rick last_name: 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 create_my_guitar_shop.sql thats in the mgs_ex_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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started