Here is the DB script if you need it. https://docs.google.com/document/d/1dbuiDA

Question

Here is the DB script if you need it.

https://docs.google.com/document/d/1dbuiDA6Mn1Uob17NyQjED8_tyzARH_PI8qBADcCOi3U/edit?usp=sharing

These exercises a use the create m guitar shop sal BA. Write the script for each and save the script (each code segment identified and separated) in Notepad. Do not submit pictures. Submit your completed assignment via Canvas 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 name: "Wind', and Code the INSERT statement so MySQL automatically generates the category id column. 2) Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the category name column to "Bassoon', 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 The next automatically generated ID category. id: product code: dex 640 product name: Yamaha DGX 640 88-Key Digital Piano Long description to come description 799.99 st price discount percent 0 date added: Today's date/time. Use a column list for this statement.

Explanation / Answer

Use the following MYSQL queries for the exercise.

ANSWERS

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.