drop table FACULTY;
create table FACULTY (
  FNAME varchar(50));

insert into FACULTY values 
('Pan');
insert into FACULTY values 
('Belkasim');
insert into FACULTY values 
('Pan');
insert into FACULTY values 
('Zhu');
insert into FACULTY values 
('Prasad');
insert into FACULTY values 
('Weeks');
insert into FACULTY values 
('Zhu');
insert into FACULTY values 
('Belkasim');

drop table CUSTOMERS;
create table CUSTOMERS (
  CNO integer, 
  CNAME varchar(50), 
  STREET varchar(50), 
  ZIP integer, 
  PHONE varchar(50));

insert into CUSTOMERS values 
(1111, 'Charles', '123 Main St.', 67226, '316-636-5555');
insert into CUSTOMERS values 
(2222, 'Bertram', '237 Ash Avenue', 67226, '316-689-5555');
insert into CUSTOMERS values 
(3333, 'Barbara', '111 Inwood St.', 60606, '316-111-1234');

drop table PARTS;
create table PARTS (
  PNO integer, 
  PNAME varchar(50), 
  QOH integer, 
  PRICE decimal(10,2), 
  OLEVEL integer);

insert into PARTS values 
(10506, 'Land Before Time I', 200, 19.99, 20);
insert into PARTS values 
(10507, 'Land Before Time II', 156, 19.99, 20);
insert into PARTS values 
(10508, 'Land Before Time III', 190, 19.99, 20);
insert into PARTS values 
(10509, 'Land Before Time IV', 60, 19.99, 20);
insert into PARTS values 
(10601, 'Sleeping Beauty', 300, 24.99, 20);
insert into PARTS values 
(10701, 'When Harry Met Sally', 120, 19.99, 30);
insert into PARTS values 
(10800, 'Dirty Harry', 140, 14.99, 30);
insert into PARTS values 
(10900, 'Dr. Zhivago', 100, 24.99, 30);

drop table ORDERS;
create table ORDERS (
  ONO integer, 
  CNO integer, 
  ENO integer, 
  RECEIVED varchar(50), 
  SHIPPED varchar(50));

insert into ORDERS values 
(1020, 1111, 1000, '10-DEC-94', '12-DEC-94');
insert into ORDERS values 
(1021, 1111, 1000, '12-JAN-95', '15-JAN-95');
insert into ORDERS values 
(1022, 2222, 1001, '13-FEB-95', '20-FEB-95');
insert into ORDERS values 
(1023, 3333, 1000, '20-JUN-97', '22-JUN-97');

drop table EMPLOYEES;
create table EMPLOYEES (
  ENO integer, 
  ENAME varchar(50), 
  ZIP integer, 
  HDATE varchar(50));

insert into EMPLOYEES values 
(1000, 'Jones', 67226, '12-DEC-95');
insert into EMPLOYEES values 
(1001, 'Smith', 60606, '01-JAN-92');
insert into EMPLOYEES values 
(1002, 'Brown', 50302, '01-SEP-94');

drop table ODETAILS;
create table ODETAILS (
  ONO integer, 
  PNO integer, 
  QTY integer);

insert into ODETAILS values 
(1020, 10506, 1);
insert into ODETAILS values 
(1020, 10507, 1);
insert into ODETAILS values 
(1020, 10508, 2);
insert into ODETAILS values 
(1020, 10509, 3);
insert into ODETAILS values 
(1021, 10601, 4);
insert into ODETAILS values 
(1022, 10601, 1);
insert into ODETAILS values 
(1022, 10701, 1);
insert into ODETAILS values 
(1023, 10800, 1);
insert into ODETAILS values 
(1023, 10900, 1);

drop table ZIPCODES;
create table ZIPCODES (
  ZIP integer, 
  CITY varchar(50));

insert into ZIPCODES values 
(67226, 'Wichita');
insert into ZIPCODES values 
(60606, 'Fort Dodge');
insert into ZIPCODES values 
(50302, 'Kansas City');
insert into ZIPCODES values 
(54444, 'Columbia');
insert into ZIPCODES values 
(66002, 'Liberal');
insert into ZIPCODES values 
(61111, 'Fort Hays');

drop table NUMBERS;
create table NUMBERS (
  C1 integer, 
  C2 integer, 
  C3 integer, 
  C4 integer, 
  C5 integer);

insert into NUMBERS values 
(1, 1, 1, 1, 1);
insert into NUMBERS values 
(2, 2, 2, 2, 2);
insert into NUMBERS values 
(1, 2, 1, 2, 1);
insert into NUMBERS values 
(2, 1, 2, 1, 2);
insert into NUMBERS values 
(1, 3, 1, 3, 1);
insert into NUMBERS values 
(3, 1, 3, 1, 3);

