CREATE TABLE CUSTOMER ( CustomerID Int NOT NULL, FirstName Char(25) NOT NULL, LastName Char(25) NOT NULL, Phone Char(12) NOT NULL, EmailAddress VarChar(100) NULL, ReferredBy IntNULL, CONSTRAINT...

Answer the questions in the word document using the data in SQL.


CREATE TABLE CUSTOMER ( CustomerIDIntNOT NULL, FirstName Char(25)NOT NULL, LastNameChar(25)NOT NULL, PhoneChar(12)NOT NULL, EmailAddressVarChar(100)NULL, ReferredByIntNULL, CONSTRAINTCustomer_PKPRIMARY KEY (CustomerID), CONSTRAINTCustomer_FK_Refer FOREIGN KEY (ReferredBy) REFERENCES CUSTOMER (CustomerID) ); CREATE TABLE INVOICE ( InvoiceNumberIntNOT NULL, CustomerIDIntNOT NULL, DateInDateNOT NULL, DateOutDateNULL, TotalAmountNumber(8,2)NULL, CONSTRAINTInvoice_PKPRIMARY KEY (InvoiceNumber), CONSTRAINT InvoiceCustomerFK FOREIGN KEY(CustomerID) REFERENCES CUSTOMER(CustomerID) ); CREATE TABLE INVOICE_ITEM ( InvoiceNumberIntNOT NULL, ItemNumberIntNOT NULL, ItemChar(50)NOT NULL, QuantityIntNOT NULL, UnitPriceNumber(8,2)NULL, CONSTRAINTInvoiceItem_PK PRIMARY KEY(InvoiceNumber, ItemNumber), CONSTRAINTInvoiceItemFKFOREIGN KEY(InvoiceNumber) REFERENCES INVOICE(InvoiceNumber) ON DELETE CASCADE ); /******************************************************************************/ commit; INSERT INTO CUSTOMER VALUES( 1, 'Nikki', 'Kaccaton', '723-543-1233', '[email protected]', NULL); INSERT INTO CUSTOMER VALUES( 2, 'Brenda', 'Catnazaro', '723-543-2344', '[email protected]', 1); INSERT INTO CUSTOMER VALUES( 3, 'Bruce', 'LeCat', '723-543-3455', '[email protected]', 2); INSERT INTO CUSTOMER VALUES( 4, 'Betsy', 'Miller', '723-654-3211', '[email protected]', 3); INSERT INTO CUSTOMER VALUES( 5, 'George', 'Miller', '723-654-4322', '[email protected]', 4); INSERT INTO CUSTOMER VALUES( 6, 'Kathy', 'Miller', '723-514-9877', '[email protected]', 2); INSERT INTO CUSTOMER VALUES( 7, 'Betsy', 'Miller', '723-514-8766', '[email protected]', 1); COMMIT; INSERT INTO INVOICE VALUES( 2018001, 1, TO_DATE('10/04/18', 'MM/DD/YY'), TO_DATE('10/06/18', 'MM/DD/YY'), 158.50); INSERT INTO INVOICE VALUES( 2018002, 2, TO_DATE('10/04/18', 'MM/DD/YY'), TO_DATE('10/06/18', 'MM/DD/YY'), 25.00); INSERT INTO INVOICE VALUES( 2018003, 1, TO_DATE('10/06/18', 'MM/DD/YY'), TO_DATE('10/08/18', 'MM/DD/YY'), 49.00); INSERT INTO INVOICE VALUES( 2018004, 4, TO_DATE('10/06/18', 'MM/DD/YY'), TO_DATE('10/08/18', 'MM/DD/YY'), 17.50); INSERT INTO INVOICE VALUES( 2018005, 6, TO_DATE('10/07/18', 'MM/DD/YY'), TO_DATE('10/11/18', 'MM/DD/YY'), 12.00); INSERT INTO INVOICE VALUES( 2018006, 3, TO_DATE('10/11/18', 'MM/DD/YY'), TO_DATE('10/13/18', 'MM/DD/YY'), 152.50); INSERT INTO INVOICE VALUES( 2018007, 3, TO_DATE('10/11/18', 'MM/DD/YY'), TO_DATE('10/13/18', 'MM/DD/YY'), 7.00); INSERT INTO INVOICE VALUES( 2018008, 7, TO_DATE('10/12/18', 'MM/DD/YY'), TO_DATE('10/14/18', 'MM/DD/YY'), 140.50); INSERT INTO INVOICE VALUES( 2018009, 5, TO_DATE('10/12/18', 'MM/DD/YY'), TO_DATE('10/14/18', 'MM/DD/YY'), 27.00); COMMIT; INSERT INTO INVOICE_ITEM VALUES(2018001, 1, 'Blouse', 2, 3.50); INSERT INTO INVOICE_ITEM VALUES(2018001, 2, 'Dress Shirt', 5, 2.50); INSERT INTO INVOICE_ITEM VALUES(2018001, 3, 'Formal Gown', 2, 10.00); INSERT INTO INVOICE_ITEM VALUES(2018001, 4, 'Slacks-Mens', 10, 5.00); INSERT INTO INVOICE_ITEM VALUES(2018001, 5, 'Slacks-Womens', 10, 6.00); INSERT INTO INVOICE_ITEM VALUES(2018001, 6, 'Suit-Mens', 1, 9.00); INSERT INTO INVOICE_ITEM VALUES(2018002, 1, 'Dress Shirt', 10, 2.50); INSERT INTO INVOICE_ITEM VALUES(2018003, 1, 'Slacks-Mens', 5, 5.00); INSERT INTO INVOICE_ITEM VALUES(2018003, 2, 'Slacks-Womens', 4, 6.00); INSERT INTO INVOICE_ITEM VALUES(2018004, 1, 'Dress Shirt', 7, 2.50); INSERT INTO INVOICE_ITEM VALUES(2018005, 1, 'Blouse', 2, 3.50); INSERT INTO INVOICE_ITEM VALUES(2018005, 2, 'Dress Shirt', 2, 2.50); INSERT INTO INVOICE_ITEM VALUES(2018006, 1, 'Blouse', 5, 3.50); INSERT INTO INVOICE_ITEM VALUES(2018006, 2, 'Dress Shirt', 10, 2.50); INSERT INTO INVOICE_ITEM VALUES(2018006, 3, 'Slacks-Mens', 10, 5.00); INSERT INTO INVOICE_ITEM VALUES(2018006, 4, 'Slacks-Womens', 10, 6.00); INSERT INTO INVOICE_ITEM VALUES(2018007, 1, 'Blouse', 2, 3.50); INSERT INTO INVOICE_ITEM VALUES(2018008, 1, 'Blouse', 3, 3.50); INSERT INTO INVOICE_ITEM VALUES(2018008, 2, 'Dress Shirt', 12, 2.50); INSERT INTO INVOICE_ITEM VALUES(2018008, 3, 'Slacks-Mens', 8, 5.00); INSERT INTO INVOICE_ITEM VALUES(2018008, 4, 'Slacks-Womens', 10, 6.00); INSERT INTO INVOICE_ITEM VALUES(2018009, 1, 'Suit-Mens', 3, 9.00); COMMIT;