Create a database SALES with the following tables:
PRODUCTS Contains one row for each type of product that is available for sale.
OFFICES Contains one row for each of the company’s five sales offices where the salespeople work.
SALESREPS Contains one row for each of the company’s ten salespeople.
CUSTOMERS Contains one row for each of the company’s customers.
ORDERS Contains one row for each order placed by a customer. For simplicity, each order is assumed to be for a single product.
DESCRIPTION PRICE Ratchet Link Midget Remover Seducer Plate 180.0 909-1b Brace Size widget Size 4 Widget Handle Brace Pin 00050$ Reducer $134,09 Left Ring 54.500.03 Woueting Brace Holder Retainer 5225, 00 Size 1 Kitget $55,09 508-b Brace 51, 425,0 Widget Installer Reducer Size 2 widget $4,500,00 widget adjuster Motor Mount Brace Retainer Minge Pin
ORDER_NUMBER PRODUCTS
779C 41003 41094 41093 887P X%49 2A44L
41089 41091 775C 41002 XX46A
113048 2008-02-10 2120 102 IMM 06L6 112993 2007-01-04 2106 102 REI 2A45C 113065 2008-02-27 2106 102 Xb47 113003 2008-01-25 2108 109 36LL 113049 2008-02-10 2118 108 QSA Xk47 112987 2007-12-31 2103 105 ACI 4100Y 113057 2008-02-18 2111 103 ACI 4100X 113042 2008-02-02 2113 101 REI 2A44R
$3,750,00 24 $1,896.00 6m $2,130.00 $5,625.00 $776.00 $27,500.00 24 $600.00 $22,500.00
ORDER_NUMBER ORDER_DATE CUST REP XFR PRODUCT QTY AMOUNT
112961 2007-12-17 2117 106 RET 2A44L $31,500,00 113012 2008-01-11 2111 41003 35 $3,745,00 112989 2008-01-03 2101 106 114X 6 $1,458,00 113051 2008-02-10 2118 108 QS Xk47 2 $1,420.00 112968 2007-10-12 2102 41004 34 $3,978,00 113036 2008-01-30 2107 41002 22,500,00 113045 2008-02-02 2112 108 RET 2944R $45, 000,00 112963 2007-12-17 2103 105 ACI 41004 $3,276,00 113013 2008-01-14 2118 COOTR $652.00 113058 2008-02-23 2108 PEA 112 10 $1,490,00 112997 2008-01-08 2124 107 BIC 41003 1 $652.00 112983 2007-12-27 2103 105 ACI 4100 6 $702,00 113024 2008-01-20 2114 QSA Xt47 $7,100.00 113062 2008-02-24 2124 PEA 114 $2,430.00 112979 2007-10-12 2114 102 acI 41003 6 $15,000,00 113027 2008-01-22 2103 105 ACI 41002 $4,104.00 113007 2008-01-08 2112 $2,925,00 113069 2008-03-02 2109 $31, 350.00 113034 2008-01-29 2107 110 RET 2A45C 8 $632,00 112992 2007-11-04 2118 41002 10 $760,00 112975 2007-10-12 2A44G $2,100,00 200802-15 $150,00
OFFICE CITY REGION MGR TARGET SALES
Denver Western 108 $300,000,00 $186,042.00 New York Eastern 106 $575,000.00 $692,637,00 Chicago Eastern 104 $5000,000.00 $735, 042, 00 Atlanta Eastern 105 $350,000,00 $367,911.00 Los Angeles Western 108 $725,000.00 $835,915.00
Salesperson Table
NAME AGE HIRE_DATE SALES
Kate Adams 33 20060212 104 $350,0.00 Harry Jones Sales Rep 380,90,9 5392.935, 00 Smith ,900- K 47,050.00 San Clark 1 YP sales 5299, 912,-09 Bob Smith ==2=a sales MT 106 * 5142,96.6 Dan Roberts 42 sales rep -000,00 $305,693,40 Tom Ryder MILL 20080113 75,965.60 Harry Fritch 21 361,865.60 Nissi Crvlet Sales Rep 209503 03 $295, 969, 90 5286, 75,60