Notes

CREATE TABLE SALESMAN (
SALESMAN_ID INT PRIMARY KEY,
NAME VARCHAR(50),
CITY VARCHAR(50),
COMMISION FLOAT
);

CREATE TABLE CUSTOMER (
CUSTOMER_ID INT PRIMARY KEY,
CUST_NAME VARCHAR(50),
CITY VARCHAR(50),
GRADE INT,
SALESMAN_ID INT,
FOREIGN KEY(SALESMAN_ID) REFERENCES SALESMAN(SALESMAN_ID)
);

CREATE TABLE ORDERS (
ORDER_NO INT PRIMARY KEY,
PURCHASE_AMOUNT FLOAT,
ORDER_DATE DATE,
CUSTOMER_ID INT,
SALESMAN_ID INT,
FOREIGN KEY(CUSTOMER_ID) REFERENCES CUSTOMER(CUSTOMER_ID),
FOREIGN KEY(SALESMAN_ID) REFERENCES SALESMAN(SALESMAN_ID)
)


INSERT INTO SALESMAN VALUES (5001,"James Hoog","New York",0.15);
INSERT INTO SALESMAN VALUES (5002,"Nail Knite","Paris",0.13);
INSERT INTO SALESMAN VALUES (5005,"Pit Alex","London",0.11);
INSERT INTO SALESMAN VALUES (5006,"Mc Lyon","Paris",0.14);
INSERT INTO SALESMAN VALUES (5007,"Paul Adam","Rome",0.13);
INSERT INTO SALESMAN VALUES (5003,"Lauson Hen","San Jose",0.12);

INSERT INTO CUSTOMER VALUES (3002,"Nick Rimando","New York",100,5001);
INSERT INTO CUSTOMER VALUES (3007,"Brad Davis","New York",200,5001);
INSERT INTO CUSTOMER VALUES (3005,"Graham Zusi","California",200,5002);
INSERT INTO CUSTOMER VALUES (3008,"Julian Green","London",300,5002);
INSERT INTO CUSTOMER VALUES (3004,"Fabian Johnson","Paris",300,5006);
INSERT INTO CUSTOMER VALUES (3009,"Geoff Cameron","Berlin",100,5003);
INSERT INTO CUSTOMER VALUES (3003,"Jozy Altidor","Moscow",200,5007);

INSERT INTO ORDERS VALUES (70001,150.5,"2012-10-05",3005,5002);
INSERT INTO ORDERS VALUES (70009,270.65,"2012-09-10",3003,5005);
INSERT INTO ORDERS VALUES (70002,65.26,"2012-10-05",3002,5001);
INSERT INTO ORDERS VALUES (70004,110.5,"2012-08-17",3009,5003);