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

Paste in your sql commands

(Oracle 11g)

Thank you

786 786 ORDER SOURCE I OS ID OS_DESC A A 1789 ORDERS T O ID O DATE O_METHPMT A OC_ID OS_JD 789 789 CUSTOMER CID OC_LAST A A JC FIRST A CMI A OC_BIRTHDATE C ADDRESS A OC CITY A OC STATE A C ZIP A CDPHONE A A C EPHONE A OC_USERID C PASSWORD A SHIPMENT U SHIP ID SHIP_DATE EXPECTED ED 789 ORDER LINE 10D INVID OL_QUANTITY 78, 789 789 7891 789 SHIPMENT LINE T SHIP_ID INVID SL_QUANTITY SL DATE RECEIVED E 789 789 ITEM ITEM_ID ITEM_DESC CAT_JD ITEM_IMAGE A 789 A 789 COLOR COLOR INVENTORY T INV ID 789 ITEM_ID COLOR A INV_SIZE A INV_PRICE INV_QOH A. 789 CATEGORY CAT ID CAT DESC 789 789 A Figure 1-15 Visual representation of the Clearwater Traders database CUSTOMER CID C LAST Number String 1 Harris 2 Garcia 3 Miller 4 Chang 5 Edwards 6 Nelson CMI String E H C FIRST String Paula Maria Lee Alissa Mitch Kyle C BIRTHDATE Date/Time 04/09/1953 07/14/1958 01/05/1936 10/01/1976 11/20/1986 12/04/1984 C ADDRESS String 1156 Water Street, Apt. #3 2211 Pine Drive 699 Pluto St. NW 987 Durham Rd. 4204 Garner Street 232 Echo Rd. C CITY String Osseo Radisson Silver Lake Apple Valley Washburn Minnetonka C STATE String WI WI WI MN WI MN C ZIP String 54705 54867 53821 55712 54891 55438 R M E CUSTOMER (continued) CDPHONE CEPHONE CUSERID String String String 7155558943 7155559035 harrispe 7155558332 7155558332 garciamm 7155554978 7155559002 miller 7155557651 7155550087 changar 7155558243 7155556975 edwardsam 7151113333 7155552222 nelsonke C_PASSWORD String asdfjk 12345 zxcvb qwerui qwerty clever ORDER_SOURCE OS ID OS DESC Number String 1 Winter 2005 2 Spring 2006 3 Summer 2006 4 Outdoor 2006 5 Children's 2006 6 Web Site ORDERS OID Number 1 2 3 4 5 6 O DATE Date/Time 5/29/2006 5/29/2006 5/31/2006 5/31/2006 6/01/2006 6/01/2006 alalalalalalala OMETHPMT CID String Number 1 5 CHECK 2 3 4 4 OS ID Number 2 6 2 3 6 3 Mom CATEGORY CAT ID CAT DESC NumberString 1 Women's Clothing 2 Children's Clothing 3 Men's Clothing 4 Outdoor Gear ITEM ITEM ID String 1 2 3 4 5 6 7 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.jpg 4 tents.pe 1 shorts.jpg 1 fleece.jpg 2 sandals.jpg 2 surfshorts. pg 2 girlstee.jpg INV SIZE String INVENTORY INV ID ITEM ID Number Number 1 2 2 2 3 3 4 3 5 3 6 3 7 3 8 3 4 10 4 11 4 12 4 13 4 14 4 15 16 5 17 5 18 5 19 5 20 5 21 5 22 5 23 1 24 1 25 1 26 1 27 6 28 6 29 6 30 7 31 7 32 7 COLOR String Sky Blue Light Grey Khaki Khaki Khaki Navy Navy Navy Errplant Errplant Errplant Royal Royal Royal Turquoise Turquoise Turquoise Turquoise Bright Pink Bright Pink Bright Pink Bright Pink Spruce Spruce Spruce Spruce Blue Blue Blue White White White S M L S M L S M L s M L 10 11 12 1 10 11 INV PRICE Number 259.99 259.99 29.95 29.95 29.95 29.95 29.95 29.95 59.95 59.95 59.95 59.95 59.95 59.95 15.99 15.99 15.99 15.99 15.99 15.99 15.99 15.99 199.95 199.95 209.95 209.95 15.95 15.95 15.95 19.99 19.99 19.99 INV QOH Number 16 12 150 147 0 139 137 115 135 168 187 0 124 112 121 111 113 121 148 137 134 123 114 17 0 12 50 100 100 100 100 100 12 LIN 1 S M L XL S M L s M - ORDER LINE OID INV ID Number Number 1 1 1 14 2 19 3 24 3 26 4 12 5 8 5 13 6 2 6 7 OL QUANTITY Number 1 2 1 1 1 2 1 1 1 SHIPMENT SHIP_ID Number 1 2 3 4 5 SHIP DATE EXPECTED Date/Time 09/15/2006 11/15/2006 06/25/2006 06/25/2006 08/15/2006 Figure 1-14 Clearwater Traders database (continued) SL DATE RECEIVED Date/Time 09/10/2006 09/10/2006 SHIPMENT_LINE SHIP_ID INV_ID Number Number 1 1 1 2 2 2 3 5 3 6 3 7 4 12 4 13 5 23 5 24 5 25 SL QUANTITY Number 25 25 25 200 200 200 100 100 50 100 100 08/15/2006 08/25/2006 08/15/2006 08/15/2006 08/15/2006 COLOR COLOR String Sky Blue Light Grey Khaki Navy Royal Eggplant Blue Red Spruce Turquoise Bright Pink White