trteCHOT RO TABLES UNIQUE TA what DOL 72 What does DML rand ust the squ DMIstatement the that allow w we w oreale and use a database with a set of 00mpare variations in SOL CREATE TABLE and SQL INSERT illustrate dimerent situations that call The database will CREATE TABLE sol. INSERT op be named CHOT RO TABLEs and will contain the CUSTOMER mallsddress. LastName, FirstName) CUSTOMER-02 customerlD, EmailAddress, LastName, FirstName) CUSTOMER customedu EmailAddress. LastName. First CUSTOMER .04 customerID EmailAddress, LastName. FirstName) SALE 01 SALE 02 SalelD, Dateosale.customerID, saleAmount) is a text column containing an email address, and is therefore not a surrogate key. CustomerID is a surrogate key that starts at 1 and increments by 1. SaleID is a surrogate key that starts at 20150001 and increases by 1. CH07.RO TABLES database has the following referential integrity constraints EmailAddress in SALE 01 must esist in EmailAddress in CUSTOMER 01 Customerllo in SALE 02 must esist in CustomerID in CUSTOMER 04 The relationship from SALE 01 to 01 is N 1 O-M. The relationship from SALE 02 to CUSTOMER 04 is N:1, O-M. for these tables are shown in Figures 7.35 The column characteristics (CUSTOMER 010, 7-36 (CUSTOMER 02, CUSTOMER 04 and CUSTOMER.09, 7.37 (SALE 01), and 7-38 (SALE 02. The data for these tables are shown in Figures 7.30 (CUSTOMER 01, 7-40 (CUSTOMER 02.7-1 (CUSTOMER 04, 7-42 (SALE 010, and 7-43 (SALE 02. 74 If you are using Microsoli SQL Server. Oracle Database, or MySQl. create a folder in your Daumme folder save and store the SOL. Required Remarks Column Name Type EmailAddress Varchar Primary Key Yes Varchar 250 No