Assist in creating tables based on erd diagram using sqlplus following sample

Paste in your sql commands

(Oracle 11g)

Thank you

CUSTOMER CID CLAST C FIRST CMI C BIRTHDATEC ADDRESS NumberString String StringDate/Time String 1 Harris Paula E 04/09/1953 1156 Water Street, Apt. 03 Garcia Maria H 07/14/1956 2211 Pine Drive Miller Lee 01/05/1936 699 Pluto St. NW . Chang Alissa R 10/01/1976 987 Durham Rd Edwards Match M 11/20/1986 4204 Gamer Street 6 Nelson E 12/04/1984 232 Echo Rd C CITY String Osseo Radisson Silver Lake Apple Valley Washburn Minnetonka C STATE String WI WI WI MN WI MN CDPHONE C ZIP C EPHONE C USERID String Song String String 54705 7155558943 7155559035 harrispe 7155558332 7155558332 Rarciamm 7155554978 7155559002 miller 7155557651 7155550087 changar 54891 71555582437155556975 edwardsam 55433 71511133337155552222 nelsonke C PASSWORD String asdfjk 12345 zxcvb qwerui qwerty clever ORDERS O ID O DATE Number Date/Time 1 5/29/2006 2 5/29/2006 3 5/31/2006 4 5/31/2006 5 6/01/2006 6 6/01/2006 O METHPMT CID String Number CC 1 5 CHECK 2 3 4 4 OS ID Number 2 6 2 3 6 3 Kyle 789 OC FIRST OC MI ORDERS DOLID DO_DATE O_METHPMT A OCD OS_JD 789 ORDER_SOURCE OS ID OS DESC ORDER SOURCE I Number String 1 789 OS ID Winter 2005 2 Spring 2006 DOS DESC A 3 Summer 2006 4 Outdoor 2006 5 Children's 2006 6 Web Site SHIPMENT 1 SHIPMENT SHIP_ID SHIP ID SHIP DATE EXPECTED Number Date/Time SHIP DATE EXPECTED ED 1 09/15/2006 2 11/15/2006 3 06/25/2006 4 06/25/2006 5 08/15/2006 789 CUSTOMER T O CID 784 OC_LAST A A A OC BIRTHDATE OC ADDRESS A OC CITY A OC STATE A OC ZIP A A CDPHONE A A OC EPHONE A OCUSERID A OC PASSWORD A 789 7891 SHIPMENT LINE SHIP ID INVIDSL QUANTITY Number Number Number 789 ESL DATE RECEIVED Date/Time 09/10/2006 10/2006 789 789 2 2 2 SHIPMENT LINE T SHIP ID INVID SL QUANTITY SL DATE RECEIVED D ORDER LINE BOID INV_ID MOL QUANTITY 78. ORDER LINE OD INV IDOL QUANTITY Numbe Number Number 1 1 14 2 2 1 1 789 25 25 200 200 200 100 100 50 100 100 4 5 12 13 23 24 25 ITEM ITEM ID String 1 2 3 4 5 6 7 08/15/2006 08/25/2005 08/15/2006 08/15/2006 08/15/2006 ITEM DESC Number Men's Expedition Parka 3-Season Tent Women's Hiking Shorts Women's Fleece Pullover Children's Beachcomber Sandals Boy's Surf Shorts Girl's Soccer Tee CAT ID ITEM IMAGE Number String 3 parka.pg 4 tents.pg 1 shorts.ips 1 fleece.ID 2. sandals.jpg 2. surfshorts. pg 2. girlstee.ips INV GOH Number 16 1 2 4 ITEM ITEM_ID ITEM_DESC CAT JD ITEM IMAGE 789 A 789 A INVENTORY INV IDTEM 10 Number Number 2 2 2 3 3 4 3 5 6 3 5 150 6 789 2 10 3 789 8 COLOR COLOR INVENTORY D INV_ID ITEMID COLOR A INV SIZE A INV_PRICE INV_QOH 137 115 135 168 187 0 A 3 4 4 4 4 4 4 5 15 5 10 11 12 13 14 15 16 CATEGORY CAT ID CAT DESC NumberString 1 Women's Clothing 2 Children's Clothing 3 Men's Clothing 4 Outdoor Gear 789 789 CATEGORY CAT ID CAT_DESC 112 121 COLOR INV SIZE INV PRICE Sering String Number Sky Blue Light KE 5 29.95 Kha TM M Khaki L 29.95 Navy Navy M Navy L Lapant 5 Leplant M 59.95 Egeplant L Royal 5995 Roya M 599 Royal L Lrquoise 10 Erquoise 11 15.99 turquoise 12 15.99 Lrquoise1 Bright Pink 10 11 15.99 Enchan 12 Bright Pink 1599 pruce 15 1999 Spruce M Spruce L Spruce XL 209 5 1595 TE M L 1595 White 5 White M A COLOR COLOR String Sky Blue Light Grey Khaki Navy Royal Errplant 113 121 19 20 21 137 5 5 3 5 1 23 123 114 Figure 1-15 Visual repre Blue le Clearwater Traders datal 25 26 1 28 6 Red Spruce Turquoise Bright Pink White O O 12 150 100 100 100 100 100 30 Write