CPSC340A
Database Systems

Activity 10

Inserting & Deleting

Sales Orders Database

  1. Customer Liz Keyser wants to order again the products ordered on December 11, 2012. Use June 12, 2013, as the order date and June 15, 2013, as the shipped date. (Hint: You need to copy rows in both the Orders and Order_Details tables. Assume that you can add 1000 to the OrderID column value that you find for the December 11 order for Liz Keyser to generate the new order number.) (1 & 4 rows added)

  2. Create a new customer record for Mary Baker at 7834 W 32nd Ct., Bothell, WA, 98011, with area code 425 and phone number 555-9876. (1 row added).

  3. Delete any categories that have no products. (0 rows deleted)

Bowling League Database

  1. Delete all bowling matches that have not been played. (1 row deleted)