Quiz Instructions Write SQL commands that create the Customer, Product, Invoice, and OrderLineltem tables shown in the Practice Data Make sure to use the correct syntax similar to slides 23 and 24 in Powerpoint file "CH 3A. D Question 1 5 pts Customer CREATE Customer ( CHAR(4) NOT NUL Name VarChar(50) NOT NULL Address (50) NOT NULL Customer PK PRIMARY KEY ansitions Animations Slide Show Renew View Help Tell me what you want to do Share : Comm Internet can centain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Customer Phone Division Contract ConCode Markup PhoneNo DID Name Smith 1 1001 8881279800 Cell Divone us nd 123 Apple St 1001 101 Maple st 1002 12 Dupe St. 1003 12 Tiger Rd. 1004 88 Chico St 8389827394 Office 8887384948 Office 9982890001 Cell 8725389377 Cel 8 Idaho Rd D3 DvThree3 Maine st 1003 Wholesaler CID OrderLineltem PID OID 10 2001 11 20023 1020034 13 20042 Retailer Product Name Slinky 9.35 10 Sticky 2.35 08 Bally 8.95 11 Stringy 5.95 14NG Crayon 2.9512 Horsey 59.95 15 Inky7.93 13 Invoice CID 1002 2001 10/1/2017 1001 2002 10/1/2017 Production DID PID PQtV |Rating 01 10 3200 01 08 3452 D3 10 3345 1 03 13 3244 1 D1 11 3255 1 D8 14 4544 2 D1 12 6378 2 03 14 2435 08 15630 D1 1S 1121 D3 08 7855 Price PID aty cio |Type 1002 Hardware 1001 Software 1004 Hardware 1 1005 A25 OldContracts Concods Markup 14 20031 0820017 DateOrdered 2003 0/1/2017 004 1002 200410/2/2017 Dell Command Update Question 2 5 pts Product CREATE TABLE PID NameVarChar(50) NOT NULL Numeric(4,2) NOT NULL. CONSTRAINT Product PK PID) Question3 5 pts Invoice TABLE Invoice( CHAR(4) NOT NULL CHAR(4)NOT NULL NOT NULL DateOrdered Date CONSTRAINT Invoice PK PRIMARY KEY(OID), CONSTRAINT Inv Cust FK (CD) REFERENCES Customer ( Question 4 5 pts OrderLineltem OrderLineltem ( CHAR(2) NOT NULL, CHAR(4 NOT NULL PID OID INT NOT NULL CONSTRAINT Customer PK PRIMARY KEY(PID. CONSTRAINT Lineltem, Product FK FOREIGN KEY PID) REFERENCES Product ( CONSTRAINT Lineltem. Invoice,FK.. _ FOREIGN KEY(OID) REFERENCES (OID)