Home Online Database ERD Activity 1 Activity 2 Activity 3 Activity 4 Activity 5 Activity 6 Activity 7

Activity 6: Deleting records from a table.

Investigate

First start by learning about the SQL DELETE statement by reading through the following web page:

Practice

Use the Online Database to perform the following queries:

DescriptionSQL QueryResults
Janet Leverling has left the company. Delete her record from the employee table.
Order 10252 has been cancelled. Delete this order from the orders table as well as all the entries on the orderDetails table related to this order.
A mistake was made when inputing order 10281. The customer ordered 3 boxes of Teatime Chocolate Biscuits. Update the record accordingly to set the quantity ordered to 3.