To perform the following assignments, refer to the tables created in the JLDB_Build_5.sql script at the beginning of the chapter.

IF NEEDED I CAN PROVIDE JLDB_Build_5.sql COPY PASTA FROM NOTEPAD IN THE COMMENTS

1. Add a new row in the ORDERS table with the following data: Order# = 1021, Customer# = 1009, and Order date = July 20, 2009.

2. Modify the zip code on order 1017 to 33222.

3. Save the changes permanently to the database.

6. Create a script using substitution variables that allows a user to set a new cost amount for a book based on the ISBN.

9. Delete Order# 1005. You need to address both the master order record and the related detail records.

10. Execute a command that undoes the previous deletion.