Question: 4. Write an INSERT statement that adds this row to the Products table: ProductID: The next automatically generated ID CategoryID: 4 ProductCode: dgx_640 Product Name:

4. Write an INSERT statement that adds this row to the Products table: ProductID: The next automatically generated ID CategoryID: 4 ProductCode: dgx_640 Product Name: Yamaha DGX 640 88-key Digital Piano Description: Long description to come. ListPrice: 799.99 Discount Percent: 0 Date Added: Today's date/time. Use a column list for this statement. NOTE: Because ProductID is automatically generated and DiscountPercent is already defaulted to 0, they do not need to be inserted. 5. Write an UPDATE statement that modifies the product you added in exercise 4. This 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%. When you 6. Write a DELETE statement that deletes the row in the Categories table that has an ID of 4. i 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: Email Address: rick@raven.com Password: (empty string) FirstName: Rick LastName: Raven Use a column list for this statement
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
