1. Could we have created the SALE_01 table before creating the CUSTOMER_01 table? If not, why not? 2. Write and run an SQL CREATE TABLE statement to create the SALE_02 table. Note that the foreign key...

1. Could we have created the SALE_01 table before creating the CUSTOMER_01 table? If not, why not?

2. Write and run an SQL CREATE TABLE statement to create the SALE_02 table. Note that the foreign key is Customer ID, which references CUSTOMER_04.CustomerID. In this database, CUSTOMER_04 and SALE_02 records are never deleted, so that there will be no ON DELETE referential integrity action. However, you will need to decide how to implement the ON UPDATE referential integrity action.

3. In Review Question 7.18, how did you implement the ON UPDATE referential integrity action? Why?