CREATE TABLE ORDERS(
ORD_NO NUMBER PRIMARY KEY,
PURCH_AMT NUMBER,
ORD_DATE DATE,
CUSTOMER_ID NUMBER,
SALESMAN_ID NUMBER
);
CREATE TABLE CUSTOMER(
CUSTOMER_ID NUMBER PRIMARY KEY,
CUST_NAME VARCHAR2(15),
CITY VARCHAR2(10),
GRADE NUMBER,
SALESMAN_ID NUMBER
);
CREATE TABLE SALESMAN(
salesman_id NUMBER PRIMARY KEY,
name VARCHAR2(15),
CITY VARCHAR2(10),
COMMISSION NUMBER
);
CREATE TABLE item_mast (
PRO_ID NUMBER,
PRO_NAME VARCHAR2(30),
PRO_PRICE NUMBER,
PRO_COM NUMBER
);
INSERT INTO ORDERS VALUES (70001,150.5,To_DATE('2012-10-05','YYYY-MM-
DD'),3005,5002);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70009, 270.65, TO_DATE('2012-09-10', 'YYYY-MM-DD'), 3001, 5005);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70002, 65.26, TO_DATE('2012-10-05', 'YYYY-MM-DD'), 3002, 5001);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70004, 110.5, TO_DATE('2012-08-17', 'YYYY-MM-DD'), 3009, 5003);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70007, 948.5, TO_DATE('2012-09-10', 'YYYY-MM-DD'), 3005, 5002);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70005, 2400.6, TO_DATE('2012-07-27', 'YYYY-MM-DD'), 3007, 5001);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70008, 5760, TO_DATE('2012-09-10', 'YYYY-MM-DD'), 3002, 5001);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70010, 1983.43, TO_DATE('2012-10-10', 'YYYY-MM-DD'), 3004, 5006);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70003, 2480.4, TO_DATE('2012-10-10', 'YYYY-MM-DD'), 3009, 5003);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70012, 250.45, TO_DATE('2012-06-27', 'YYYY-MM-DD'), 3008, 5002);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70011, 75.29, TO_DATE('2012-08-17', 'YYYY-MM-DD'), 3003, 5007);
INSERT INTO ORDERS (ord_no, purch_amt, ord_date, customer_id, salesman_id)
VALUES (70013, 3045.6, TO_DATE('2012-04-25', 'YYYY-MM-DD'), 3002, 5001);
INSERT INTO CUSTOMER (customer_id, cust_name, city, grade, salesman_id)
VALUES (3002, 'Nick Rimando', 'New York', 100, 5001);
INSERT INTO CUSTOMER (customer_id, cust_name, city, grade, salesman_id)
VALUES (3007, 'Brad Davis', 'New York', 200, 5001);
INSERT INTO CUSTOMER (customer_id, cust_name, city, grade, salesman_id)
VALUES (3005, 'Graham Zusi', 'California', 200, 5002);
INSERT INTO CUSTOMER (customer_id, cust_name, city, grade, salesman_id)
VALUES (3008, 'Julian Green', 'London', 300, 5002);
INSERT INTO CUSTOMER (customer_id, cust_name, city, grade, salesman_id)
VALUES (3004, 'Fabian Johnson', 'Paris', 300, 5006);
INSERT INTO CUSTOMER (customer_id, cust_name, city, grade, salesman_id)
VALUES (3009, 'Geoff Cameron', 'Berlin', 100, 5003);
INSERT INTO CUSTOMER (customer_id, cust_name, city, grade, salesman_id)
VALUES (3003, 'Jozy Altidor', 'Moscow', 200, 5007);
INSERT INTO CUSTOMER (customer_id, cust_name, city, grade, salesman_id)
VALUES (3001, 'Brad Guzan', 'London', NULL, 5005);
INSERT INTO SALESMAN VALUES (5001,'James Hoog','New York',0.15);
INSERT INTO salesman (salesman_id, name, city, commission)
VALUES (5002, 'Nail Knite', 'Paris', 0.13);
INSERT INTO salesman (salesman_id, name, city, commission)
VALUES (5005, 'Pit Alex', 'London', 0.11);
INSERT INTO salesman (salesman_id, name, city, commission)
VALUES (5006, 'Mc Lyon', 'Paris', 0.14);
INSERT INTO salesman (salesman_id, name, city, commission)
VALUES (5007, 'Paul Adam', 'Rome', 0.13);
INSERT INTO salesman (salesman_id, name, city, commission)
VALUES (5003, 'Lauson Hen', 'San Jose', 0.12);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (101, 'Mother Board', 3200.00, 15);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (102, 'Key Board', 450.00, 16);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (103, 'ZIP drive', 250.00, 14);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (104, 'Speaker', 550.00, 16);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (105, 'Monitor', 5000.00, 11);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (106, 'DVD drive', 900.00, 12);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (107, 'CD drive', 800.00, 12);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (108, 'Printer', 2600.00, 13);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (109, 'Refill cartridge', 350.00, 13);
INSERT INTO item_mast (PRO_ID, PRO_NAME, PRO_PRICE, PRO_COM)
VALUES (110, 'Mouse', 250.00, 12);
