7.7 Write and run an SQL CREATE TABLE statement to create the CUSTOMER_01 table.

Figure 7-42 Data for the CH07_RQ_TABLES Database SALE_01 Table

Figure 7-43 Data for the CH07_RQ_TABLES Database SALE_02 Table

7.8 Write and run an SQL CREATE TABLE statement to create the CUSTOMER_02 table.

7.9 Are there any significant differences between the CUSTOMER_01 and CUSTOMER_02 tables? If so, what are they?

7.10 Write and run an SQL CREATE TABLE statement to create the CUSTOMER_03 table.

7.11 Are there any significant differences between the CUSTOMER_02 and CUSTOMER_03 tables? If so, what are they?

SaleIDDateOfSale EmailAddress 20150001 2015-01-14 Robert.Shire@somewhere.com 20150002 2015-01-14 Chris.Bancroft@somewhere.com 20150003 2015-01-16 Robert.Shire@somewhere.com 20150004 2015-01-17 Katherine.Goodyear@somewhere.com SaleAmount 234.00 56.50 123.00 34.25