CMIS PROJECT

Drop Table SALESPERSONS; CREATE TABLE SALEPERSONS (SALESPERSON_ID VARCHAR2(10), TITLE VARCHAR2(12), FIRST_NAME VARCHAR2(15), LAST_NAME VARCHAR2(15), MIDDLE_NAME VARCHAR2(15), HIRE_DATE DATE, DEALER_ID VARCHAR2(10), CONSTRAINT SALEPERSONS_PK PRIMARY KEY (SALESPERSON_ID) ); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP001', 'MR', 'Tracy', 'McGrady', TO_DATE('01/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D1'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP002', 'MR', 'Vince', 'CarterR', TO_DATE('01/11/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D2'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP003', 'Ms', 'Mona', 'Lisa', TO_DATE('12/01/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D3'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP004', 'Ms', 'Madline', 'Lisa', TO_DATE('12/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D4'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP005', 'Mr', 'Vince', 'McMahon', TO_DATE('01/01/2009 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D5'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP006', 'Mr', 'Albert', 'Camo', TO_DATE('12/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D6'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP007', 'Ms', 'Kaley', 'CouCou', TO_DATE('12/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D7'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP008', 'Ms.', 'Stephanie', 'McMahon', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D8'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP009', 'Mr', 'Mario', 'Gutze', TO_DATE('01/01/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D9'); Insert into SALEPERSONS (SALESPERSON_ID, TITLE, FIRST_NAME, LAST_NAME, HIRE_DATE, DEALER_ID) Values ('SP010', 'Mr', 'Albert', 'Bourne', TO_DATE('01/01/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'D10');