rem Tables for Oracle Database 10g:The Complete Reference, by Kevin Loney and George Koch, 
rem copyright Osborne/McGraw-Hill
rem 
rem Tables Used in this Book
rem 
rem This appendix contains the complete listings of all the tables used in the examples
rem throughout this book. They can be keyed in to a start file “as is” to load into a
rem database using SQL*Plus. If these tables are a part of your Oracle database, you 
rem can easily work your way through the examples in this book and experiment with the 
rem many techniques that are illustrated.
rem 
rem For ease of use, set up a user named practice, with a password of practice. Give 
rem this user CONNECT and RESOURCE roles (or similar system privileges) so that new 
rem users can access it to learn Oracle. If you are a new user on an existing Oracle 
rem installation, check with your DBA to see if this has already been done. If not, 
rem you might request it, or at least request that the tables and start files be 
rem available to you through public synonyms. Whatever “damage” is done on the 
rem practice id can always be repaired simply by reloading the tables from their start 
rem files.
rem 
rem 
rem Using the Scripts and Tables in this Book
rem 
rem This file is made available so you can access these tables without retyping. You can
rem use these tables to easily work your way through the examples and experiment with 
rem the many techniques that are illustrated in the book.

-- Drop existing tables.  Executing with EXECUTE IMMEDIATE to suppress error messages if objects does not exist.
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BREEDER'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE CUSTOMER'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BORROWER'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TYPE TOOLS_VA'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TYPE PERSON_TY'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TYPE ANIMALS_NT'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TYPE ANIMAL_TY'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE ADDRESS'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE AREAS'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BOOKSHELF_AUTHOR'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE AUTHOR'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BIRTHDAY'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BOOK_ORDER'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BOOK_REVIEW_CONTEXT'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BOOK_REVIEW_CTXCAT'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BOOKSHELF'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE CATEGORY'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BOOKSHELF_AUDIT'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BOOKSHELF_CHECKOUT'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE BREEDING'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE CD'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE COMFORT'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE COMFORT2'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE COMFORT_TEST'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE CONTINENT'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE COUNTRY'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE EMPTY'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE HOLIDAY'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE LOCATION'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE MAGAZINE'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE MATH'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE NAME'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE NEWSPAPER'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE NUMBERTEST'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE PAYDAY'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE PROPOSAL'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE RADIUS_VALS'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE RATING'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE ROSE'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE SHIPPING'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE STOCK'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE STOCK_ACCOUNT'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE STOCK_TRX'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE TROUBLE'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE TWONAME'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE WEATHER'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE LEDGER'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE WORKER'; EXCEPTION WHEN OTHERS THEN NULL; END;
BEGIN EXECUTE IMMEDIATE 'DROP TABLE WORKERSKILL'; EXCEPTION WHEN OTHERS THEN NULL; END;

rem *******************
rem The ADDRESS_TY Type
rem *******************


CREATE OR REPLACE TYPE ADDRESS_TY AS OBJECT
(Street  VARCHAR2(50),
 City    VARCHAR2(25),
 State   CHAR(2),
 Zip     NUMBER);
/


rem ******************
rem The ANIMAL_TY Type
rem ******************

CREATE OR REPLACE TYPE ANIMAL_TY AS OBJECT
(Breed      VARCHAR2(25),
 NAME       VARCHAR2(25),
 BirthDate  DATE,
MEMBER FUNCTION AGE (BirthDate IN DATE) RETURN NUMBER);
/

CREATE OR REPLACE TYPE BODY ANIMAL_TY AS
MEMBER FUNCTION Age (BirthDate DATE) RETURN NUMBER IS
BEGIN
  RETURN ROUND(SYSDATE - BirthDate);
END;
END;
/

rem  For the Nested Table examples:
CREATE OR REPLACE TYPE ANIMALS_NT AS TABLE OF ANIMAL_TY;
/


rem ******************
rem The PERSON_TY Type
rem ******************

rem  Requires that the ADDRESS_TY type already exist.

CREATE TYPE PERSON_TY AS OBJECT
(NAME      VARCHAR2(25),
 ADDRESS   ADDRESS_TY);
/


rem *****************
rem The TOOLS_VA Type
rem *****************

rem  Creates a varying array datatype.

CREATE OR REPLACE TYPE TOOLS_VA AS VARRAY(5) OF VARCHAR2(25);
/


rem *****************
rem The ADDRESS Table
rem *****************

CREATE TABLE ADDRESS (
LastName   VARCHAR2(25),
FirstName  VARCHAR2(25),
Street     VARCHAR2(50),
City       VARCHAR2(25),
State      CHAR(2),
Zip        NUMBER,
Phone      VARCHAR2(12),
Ext        VARCHAR2(5)
);

INSERT INTO ADDRESS VALUES ('BAILEY', 'WILLIAM',
     NULL,NULL,NULL,NULL,'213-555-0223',NULL);
INSERT INTO ADDRESS VALUES ('ADAMS', 'JACK',
     NULL,NULL,NULL,NULL,'415-555-7530',NULL);
INSERT INTO ADDRESS VALUES ('SEP', 'FELICIA',
     NULL,NULL,NULL,NULL,'214-555-8383',NULL);
INSERT INTO ADDRESS VALUES ('DE MEDICI', 'LEFTY',
     NULL,NULL,NULL,NULL,'312-555-1166',NULL);
INSERT INTO ADDRESS VALUES ('DEMIURGE', 'FRANK',
     NULL,NULL,NULL,NULL,'707-555-8900',NULL);
INSERT INTO ADDRESS VALUES ('CASEY', 'WILLIS',
     NULL,NULL,NULL,NULL,'312-555-1414',NULL);
INSERT INTO ADDRESS VALUES ('ZACK', 'JACK',
     NULL,NULL,NULL,NULL,'415-555-6842',NULL);
INSERT INTO ADDRESS VALUES ('YARROW', 'MARY',
     NULL,NULL,NULL,949414302,'415-555-2178',NULL);
INSERT INTO ADDRESS VALUES ('WERSCHKY', 'ARNY',
     NULL,NULL,NULL,NULL,'415-555-7387',NULL);
INSERT INTO ADDRESS VALUES ('BRANT', 'GLEN',
     NULL,NULL,NULL,NULL,'415-555-7512',NULL);
INSERT INTO ADDRESS VALUES ('EDGAR', 'THEODORE',
     NULL,NULL,NULL,NULL,'415-555-6252',NULL);
INSERT INTO ADDRESS VALUES ('HARDIN', 'HUGGY',
     NULL,NULL,NULL,NULL,'617-555-0125',NULL);
INSERT INTO ADDRESS VALUES ('HILD', 'PHIL',
     NULL,NULL,NULL,NULL,'603-555-2242',NULL);
INSERT INTO ADDRESS VALUES ('LOEBEL', 'FRANK',
     NULL,NULL,NULL,NULL,'202-555-1414',NULL);
INSERT INTO ADDRESS VALUES ('MOORE', 'MARY',
     NULL,NULL,NULL,601262460,'718-555-1638',NULL);
INSERT INTO ADDRESS VALUES ('SZEP', 'FELICIA',
     NULL,NULL,NULL,NULL,'214-555-8383',NULL);
INSERT INTO ADDRESS VALUES ('ZIMMERMAN', 'FRED',
     NULL,NULL,NULL,NULL,'503-555-7491',NULL);


rem ***************
rem The AREAS Table
rem ***************

CREATE TABLE AREAS
(Radius      NUMBER(5),
 Area        NUMBER(14,2)
);

REMARK No inserts. This table is empty.


rem ****************
rem The AUTHOR Table
rem ****************

CREATE TABLE AUTHOR
(AuthorName  VARCHAR2(50) PRIMARY KEY,
Comments  VARCHAR2(100));

INSERT INTO AUTHOR VALUES
('DIETRICH BONHOEFFER', 'GERMAN THEOLOGIAN, KILLED IN A WAR CAMP');
INSERT INTO AUTHOR VALUES
('ROBERT BRETALL','KIERKEGAARD ANTHOLOGIST');
INSERT INTO AUTHOR VALUES
('ALEXANDRA DAY','AUTHOR OF PICTURE BOOKS FOR CHILDREN');
INSERT INTO AUTHOR VALUES
('STEPHEN JAY GOULD','SCIENCE COLUMNIST, HARVARD PROFESSOR');
INSERT INTO AUTHOR VALUES
('SOREN KIERKEGAARD','DANISH PHILOSOPHER AND THEOLOGIAN');
INSERT INTO AUTHOR VALUES
('HARPER LEE','AMERICAN NOVELIST, PUBLISHED ONLY ONE NOVEL');
INSERT INTO AUTHOR VALUES
('LUCY MAUD MONTGOMERY','CANADIAN NOVELIST');
INSERT INTO AUTHOR VALUES
('JOHN ALLEN PAULOS','MATHEMATICS PROFESSOR');
INSERT INTO AUTHOR VALUES
('J. RODALE', 'ORGANIC GARDENING EXPERT');
INSERT INTO AUTHOR VALUES
('DANIEL BOORSTIN', 'LIBRARIAN OF CONGRESS');
INSERT INTO AUTHOR VALUES
('CHRIS VAN ALLSBURG', 'ILLUSTRATOR');
INSERT INTO AUTHOR VALUES
('MARGARET WISE BROWN', 'EDITOR AND AUTHOR');
INSERT INTO AUTHOR VALUES
('CLEMENT HURD', 'ILLUSTRATOR');
INSERT INTO AUTHOR VALUES
('G. B. TALBOT', 'FAMOUS LEDGERIST');
INSERT INTO AUTHOR VALUES
('JOHN KEATS', 'ROMANTIC POET');
INSERT INTO AUTHOR VALUES
('JOHN BARNARD', 'KEATS EDITOR');
INSERT INTO AUTHOR VALUES
('CHRISTOPHER NOLAN', 'POET AND AUTHOR');
INSERT INTO AUTHOR VALUES
('DAVID MCCULLOUGH', 'HISTORIAN');
INSERT INTO AUTHOR VALUES
('MERIWETHER LEWIS', 'EXPLORER AND JOURNALIST');
INSERT INTO AUTHOR VALUES
('WILLIAM CLARK', 'EXPLORER AND JOURNALIST');
INSERT INTO AUTHOR VALUES
('STEPHEN AMBROSE',NULL);
INSERT INTO AUTHOR VALUES
('BERNARD DE VOTO', 'EDITOR');
INSERT INTO AUTHOR VALUES
('WILTON BARNHARDT', 'AMERICAN AUTHOR');
INSERT INTO AUTHOR VALUES
('AVI', 'PROLIFIC AUTHOR OF BOOKS FOR CHILDREN');
INSERT INTO AUTHOR VALUES
('J. K. ROWLING', 'AUTHOR OF HARRY POTTER SERIES');
INSERT INTO AUTHOR VALUES
('W. P. KINSELLA', 'AUTHOR AND WRITING PROFESSOR');
INSERT INTO AUTHOR VALUES
('E. B. WHITE', 'AUTHOR AND ESSAYIST');
INSERT INTO AUTHOR VALUES
('BERYL MARKHAM', 'AVIATOR AND ADVENTURESS');
INSERT INTO AUTHOR VALUES
('PETER GOMES', 'HARVARD THEOLOGIAN');
INSERT INTO AUTHOR VALUES
('THOMAS SWEARS', 'PASTOR AND AUTHOR');
INSERT INTO AUTHOR VALUES
('E. ANNIE PROULX',NULL);

COMMIT;


rem ******************
rem The BIRTHDAY Table
rem ******************

CREATE TABLE BIRTHDAY (
FirstName     VARCHAR2(15),
LastName      VARCHAR2(15),
BirthDate     DATE,
Age           NUMBER,
CONSTRAINT PK_BIRTHDAY PRIMARY KEY (FirstName, LastName)
);

INSERT INTO BIRTHDAY VALUES ('GEORGE','SAND',
        TO_DATE('12-MAY-1946','DD-MON-YYYY'),42);
INSERT INTO BIRTHDAY VALUES ('ROBERT','JAMES',
        TO_DATE('23-AUG-1937','DD-MON-YYYY'),52);
INSERT INTO BIRTHDAY VALUES ('NANCY','LEE',
        TO_DATE('02-FEB-1947','DD-MON-YYYY'),42);
INSERT INTO BIRTHDAY VALUES ('VICTORIA','LYNN',
        TO_DATE('20-MAY-1949 3:27','DD-MON-YYYY HH24:MI'),42);
INSERT INTO BIRTHDAY VALUES ('FRANK','PILOT',
        TO_DATE('11-NOV-1942','DD-MON-YYYY'),42);


rem ********************
rem The BOOK_ORDER Table
rem ********************

CREATE TABLE BOOK_ORDER
(Title       VARCHAR2(100) PRIMARY KEY,
Publisher    VARCHAR2(20),
CategoryName VARCHAR2(20));


INSERT INTO BOOK_ORDER VALUES
('SHOELESS JOE','MARINER','ADULTFIC');
INSERT INTO BOOK_ORDER VALUES
('GOSPEL','PICADOR','ADULTFIC');
INSERT INTO BOOK_ORDER VALUES
('SOMETHING SO STRONG','PANDORAS','ADULTNF');
INSERT INTO BOOK_ORDER VALUES
('GALILEO''S DAUGHTER','PENGUIN','ADULTNF');
INSERT INTO BOOK_ORDER VALUES
('LONGITUDE','PENGUIN','ADULTNF');
INSERT INTO BOOK_ORDER VALUES
('ONCE REMOVED','SANCTUARY PUB','ADULTNF');

COMMIT;


rem *****************************
rem The BOOK_REVIEW_CONTEXT Table
rem *****************************

CREATE TABLE BOOK_REVIEW_CONTEXT
(Title       VARCHAR2(100) PRIMARY KEY,
Reviewer     VARCHAR2(25),
Review_Date  DATE,
Review_Text  VARCHAR2(4000));

INSERT INTO BOOK_REVIEW_CONTEXT VALUES
('MY LEDGER', 'EMILY TALBOT', '01-MAY-02',
'A fascinating look into the transactions and finances of G. B. Talbot and Dora Talbot as they managed a property in New Hampshire around 1900.  The stories come through the purchases – for medicine, doctor visits and gravesites – for workers during harvests – for gifts at the general store at Christmas.  A great read. ');


rem ****************************
rem The BOOK_REVIEW_CTXCAT Table
rem ****************************

CREATE TABLE BOOK_REVIEW_CTXCAT
(Title       VARCHAR2(100) PRIMARY KEY,
Reviewer     VARCHAR2(25),
Review_Date  DATE,
Review_Text  VARCHAR2(4000));

INSERT INTO BOOK_REVIEW_CTXCAT VALUES
('MY LEDGER', 'EMILY TALBOT', '01-MAY-02',
'A fascinating look into the transactions and finances of G. B. Talbot and Dora Talbot as they managed a property in New Hampshire around 1900.  The stories come through the purchases – for medicine, doctor visits and gravesites – for workers during harvests – for gifts at the general store at Christmas.  A great read. ');

rem ******************
rem The CATEGORY Table
rem ******************

CREATE TABLE CATEGORY
(CategoryName  VARCHAR2(12) PRIMARY KEY,
ParentCategory  VARCHAR2(8),
SubCategory VARCHAR2(20));

INSERT INTO CATEGORY VALUES
('ADULTREF','ADULT','REFERENCE');
INSERT INTO CATEGORY VALUES
('ADULTFIC','ADULT','FICTION');
INSERT INTO CATEGORY VALUES
('ADULTNF','ADULT','NONFICTION');
INSERT INTO CATEGORY VALUES
('CHILDRENPIC','CHILDREN','PICTURE BOOK');
INSERT INTO CATEGORY VALUES
('CHILDRENFIC','CHILDREN','FICTION');
INSERT INTO CATEGORY VALUES
('CHILDRENNF','CHILDREN','NONFICTION');

COMMIT;


rem *******************
rem The BOOKSHELF Table
rem *******************

REM  The CATFK foreign key requires that the CATEGORY table
REM  is created and populated before BOOKSHELF.

CREATE TABLE BOOKSHELF
(Title       VARCHAR2(100) PRIMARY KEY,
Publisher    VARCHAR2(20),
CategoryName VARCHAR2(20),
RATING       VARCHAR2(2), 
CONSTRAINT CATFK FOREIGN KEY (CategoryName) 
REFERENCES CATEGORY(CategoryName));

INSERT INTO BOOKSHELF VALUES
('TO KILL A MOCKINGBIRD','HARPERCOLLINS','ADULTFIC','5');
INSERT INTO BOOKSHELF VALUES
 ('WONDERFUL LIFE','W.W.NORTON','ADULTNF','5');
INSERT INTO BOOKSHELF VALUES
 ('INNUMERACY','VINTAGE BOOKS','ADULTNF','4');
INSERT INTO BOOKSHELF VALUES
 ('KIERKEGAARD ANTHOLOGY','PRINCETON UNIV PR','ADULTREF','3');
INSERT INTO BOOKSHELF VALUES
 ('ANNE OF GREEN GABLES','GRAMMERCY','CHILDRENFIC','3');
INSERT INTO BOOKSHELF VALUES
 ('GOOD DOG, CARL','LITTLE SIMON','CHILDRENPIC','1');
INSERT INTO BOOKSHELF VALUES
 ('LETTERS AND PAPERS FROM PRISON','SCRIBNER','ADULTNF','4');
INSERT INTO BOOKSHELF VALUES
 ('THE DISCOVERERS','RANDOM HOUSE','ADULTNF','4');
INSERT INTO BOOKSHELF VALUES
 ('THE MISMEASURE OF MAN','W.W. NORTON','ADULTNF','5');
INSERT INTO BOOKSHELF VALUES
 ('EITHER/OR','PENGUIN','ADULTREF','3');
INSERT INTO BOOKSHELF VALUES
 ('POLAR EXPRESS','HOUGHTON MIFFLIN','CHILDRENPIC','1');
INSERT INTO BOOKSHELF VALUES
('RUNAWAY BUNNY','HARPERFESTIVAL','CHILDRENPIC','1');
INSERT INTO BOOKSHELF VALUES
('MY LEDGER','KOCH PRESS','ADULTNF','5');
INSERT INTO BOOKSHELF VALUES
('COMPLETE POEMS OF JOHN KEATS','VIKING','ADULTREF','2');
INSERT INTO BOOKSHELF VALUES
('UNDER THE EYE OF THE CLOCK','ARCADE PUB','CHILDRENNF','3');
INSERT INTO BOOKSHELF VALUES
('JOHN ADAMS','SIMON SCHUSTER','ADULTNF','4');
INSERT INTO BOOKSHELF VALUES
('TRUMAN','SIMON SCHUSTER','ADULTNF','4');
INSERT INTO BOOKSHELF VALUES
('JOURNALS OF LEWIS AND CLARK','MARINER','ADULTNF','4');
INSERT INTO BOOKSHELF VALUES
('GOSPEL','PICADOR','ADULTFIC','4');
INSERT INTO BOOKSHELF VALUES
('EMMA WHO SAVED MY LIFE','ST MARTIN''S PRESS','ADULTFIC','3');
INSERT INTO BOOKSHELF VALUES
('MIDNIGHT MAGIC','SCHOLASTIC','CHILDRENFIC','1');
INSERT INTO BOOKSHELF VALUES
('HARRY POTTER AND THE GOBLET OF FIRE','SCHOLASTIC','CHILDRENFIC','4');
INSERT INTO BOOKSHELF VALUES
('SHOELESS JOE','MARINER','ADULTFIC','3');
INSERT INTO BOOKSHELF VALUES
('BOX SOCIALS','BALLANTINE','ADULTFIC','3');
INSERT INTO BOOKSHELF VALUES
('TRUMPET OF THE SWAN','HARPERCOLLINS','CHILDRENFIC','3');
INSERT INTO BOOKSHELF VALUES
('CHARLOTTE''S WEB','HARPERTROPHY','CHILDRENFIC','3');
INSERT INTO BOOKSHELF VALUES
('WEST WITH THE NIGHT','NORTH POINT PRESS','ADULTNF','3');
INSERT INTO BOOKSHELF VALUES
('THE GOOD BOOK','BARD','ADULTREF','4');
INSERT INTO BOOKSHELF VALUES
('PREACHING TO HEAD AND HEART','ABINGDON PRESS','ADULTREF','4');
INSERT INTO BOOKSHELF VALUES
('THE COST OF DISCIPLESHIP','TOUCHSTONE','ADULTREF','3');
INSERT INTO BOOKSHELF VALUES
('THE SHIPPING NEWS','SIMON SCHUSTER','ADULTFIC','4');

COMMIT;


rem *************************
rem The BOOKSHELF_AUDIT Table
rem *************************

CREATE TABLE BOOKSHELF_AUDIT
(Title       VARCHAR2(100),
Publisher    VARCHAR2(20),
CategoryName VARCHAR2(20),
Old_Rating   VARCHAR2(2),
New_Rating   VARCHAR2(2),
Audit_Date   DATE); 


rem **************************
rem The BOOKSHELF_AUTHOR Table
rem **************************

REM    The AUTHOR, CATEGORY, and BOOKSHELF tables 
REM    must be created before BOOKSHELF_AUTHOR.

CREATE TABLE BOOKSHELF_AUTHOR
(Title      VARCHAR2(100),
AuthorName  VARCHAR2(50),
CONSTRAINT TitleFK FOREIGN KEY (Title) REFERENCES BOOKSHELF(Title),
CONSTRAINT AuthorNameFK FOREIGN KEY (AuthorName) 
REFERENCES AUTHOR(AuthorName));

INSERT INTO BOOKSHELF_AUTHOR VALUES
('TO KILL A MOCKINGBIRD','HARPER LEE');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('WONDERFUL LIFE','STEPHEN JAY GOULD');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('INNUMERACY','JOHN ALLEN PAULOS');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('KIERKEGAARD ANTHOLOGY','ROBERT BRETALL');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('KIERKEGAARD ANTHOLOGY','SOREN KIERKEGAARD');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('ANNE OF GREEN GABLES','LUCY MAUD MONTGOMERY');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('GOOD DOG, CARL','ALEXANDRA DAY');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('LETTERS AND PAPERS FROM PRISON','DIETRICH BONHOEFFER');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('THE DISCOVERERS','DANIEL BOORSTIN');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('THE MISMEASURE OF MAN','STEPHEN JAY GOULD');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('EITHER/OR','SOREN KIERKEGAARD');
INSERT INTO BOOKSHELF_AUTHOR VALUES
 ('POLAR EXPRESS','CHRIS VAN ALLSBURG');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('RUNAWAY BUNNY','MARGARET WISE BROWN');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('RUNAWAY BUNNY','CLEMENT HURD');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('MY LEDGER','G. B. TALBOT');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('COMPLETE POEMS OF JOHN KEATS','JOHN KEATS');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('COMPLETE POEMS OF JOHN KEATS','JOHN BARNARD');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('UNDER THE EYE OF THE CLOCK','CHRISTOPHER NOLAN');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('JOHN ADAMS','DAVID MCCULLOUGH');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('TRUMAN','DAVID MCCULLOUGH');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('JOURNALS OF LEWIS AND CLARK','MERIWETHER LEWIS');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('JOURNALS OF LEWIS AND CLARK','WILLIAM CLARK');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('JOURNALS OF LEWIS AND CLARK','STEPHEN AMBROSE');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('JOURNALS OF LEWIS AND CLARK','BERNARD DE VOTO');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('GOSPEL','WILTON BARNHARDT');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('EMMA WHO SAVED MY LIFE','WILTON BARNHARDT');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('MIDNIGHT MAGIC','AVI');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('HARRY POTTER AND THE GOBLET OF FIRE','J. K. ROWLING');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('SHOELESS JOE','W. P. KINSELLA');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('BOX SOCIALS','W. P. KINSELLA');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('TRUMPET OF THE SWAN','E. B. WHITE');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('CHARLOTTE''S WEB','E. B. WHITE');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('WEST WITH THE NIGHT','BERYL MARKHAM');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('THE GOOD BOOK','PETER GOMES');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('PREACHING TO HEAD AND HEART','THOMAS SWEARS');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('THE COST OF DISCIPLESHIP','DIETRICH BONHOEFFER');
INSERT INTO BOOKSHELF_AUTHOR VALUES
('THE SHIPPING NEWS','E. ANNIE PROULX');

COMMIT;


rem ****************************
rem The BOOKSHELF_CHECKOUT Table
rem ****************************

CREATE TABLE BOOKSHELF_CHECKOUT
(NAME  VARCHAR2(25),
 Title VARCHAR2(100),
 CheckoutDate  DATE,
 ReturnedDate  DATE);

INSERT INTO BOOKSHELF_CHECKOUT VALUES
('JED HOPKINS','INNUMERACY','01-JAN-02','22-JAN-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('GERHARDT KENTGEN','WONDERFUL LIFE','02-JAN-02','02-FEB-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('DORAH TALBOT','EITHER/OR','02-JAN-02','10-JAN-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('EMILY TALBOT','ANNE OF GREEN GABLES','02-JAN-02','20-JAN-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('PAT LAVAY','THE SHIPPING NEWS','02-JAN-02','12-JAN-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('ROLAND BRANDT','THE SHIPPING NEWS','12-JAN-02','12-MAR-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('ROLAND BRANDT','THE DISCOVERERS','12-JAN-02','01-MAR-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('ROLAND BRANDT','WEST WITH THE NIGHT','12-JAN-02','01-MAR-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('EMILY TALBOT','MIDNIGHT MAGIC','20-JAN-02','03-FEB-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('EMILY TALBOT','HARRY POTTER AND THE GOBLET OF FIRE','03-FEB-02','14-FEB-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('PAT LAVAY','THE MISMEASURE OF MAN','12-JAN-02','12-FEB-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('DORAH TALBOT','POLAR EXPRESS','01-FEB-02','15-FEB-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('DORAH TALBOT','GOOD DOG, CARL','01-FEB-02','15-FEB-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('GERHARDT KENTGEN','THE MISMEASURE OF MAN','13-FEB-02','05-MAR-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('FRED FULLER','JOHN ADAMS','01-FEB-02','01-MAR-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('FRED FULLER','TRUMAN','01-MAR-02','20-MAR-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('JED HOPKINS','TO KILL A MOCKINGBIRD','15-FEB-02','01-MAR-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('DORAH TALBOT','MY LEDGER','15-FEB-02','03-MAR-02');
INSERT INTO BOOKSHELF_CHECKOUT VALUES
('GERHARDT KENTGEN','MIDNIGHT MAGIC','05-FEB-02','10-FEB-02');

COMMIT;


rem ******************
rem The BORROWER Table
rem ******************

rem  Requires that the TOOLS_VA datatype be created first.

CREATE TABLE BORROWER
(NAME          VARCHAR2(25),
 Tools         TOOLS_VA,
CONSTRAINT BORROWER_PK PRIMARY KEY (NAME));

INSERT INTO BORROWER VALUES
('JED HOPKINS',
  TOOLS_VA('HAMMER','SLEDGE','AX'));


rem *****************
rem The BREEDER Table
rem *****************

rem  Requires that the ANIMAL_TY and ANIMALS_NT types
rem    already exist.

CREATE TABLE BREEDER (
BreederName      VARCHAR2(25),
Animals          ANIMALS_NT)
NESTED TABLE ANIMALS STORE AS ANIMALS_NT_TAB;


rem ******************
rem The BREEDING Table
rem ******************

CREATE TABLE BREEDING (
Offspring     VARCHAR2(10),
Sex           CHAR(1),
Cow           VARCHAR2(10),
Bull          VARCHAR2(10),
Birthdate     DATE
);

INSERT INTO BREEDING VALUES ('EVE','F',NULL,NULL,NULL);
INSERT INTO BREEDING VALUES ('ADAM','M',NULL,NULL,NULL);
INSERT INTO BREEDING VALUES ('BANDIT','M',NULL,NULL,NULL);
INSERT INTO BREEDING VALUES ('BETSY','F','EVE','ADAM',
   TO_DATE('02-JAN-1900','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('POCO','M','EVE','ADAM',
   TO_DATE('15-JUL-1900','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('GRETA','F','EVE','BANDIT',
   TO_DATE('12-MAR-1901','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('MANDY','F','EVE','POCO',
   TO_DATE('22-AUG-1902','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('NOVI','F','BETSY','ADAM',
   TO_DATE('30-MAR-1903','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('GINNY','F','BETSY','BANDIT',
   TO_DATE('04-DEC-1903','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('CINDY','F','EVE','POCO',
   TO_DATE('09-FEB-1903','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('DUKE','M','MANDY','BANDIT',
   TO_DATE('24-JUL-1904','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('TEDDI','F','BETSY','BANDIT',
   TO_DATE('12-AUG-1905','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('SUZY','F','GINNY','DUKE',
   TO_DATE('03-APR-1906','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('RUTH','F','GINNY','DUKE',
   TO_DATE('25-DEC-1906','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('PAULA','F','MANDY','POCO',
   TO_DATE('21-DEC-1906','DD-MON-YYYY'));
INSERT INTO BREEDING VALUES ('DELLA','F','SUZY','BANDIT',
   TO_DATE('11-OCT-1908','DD-MON-YYYY'));


rem ************
rem The CD Table
rem ************

CREATE TABLE CD (
ACCOUNT      NUMBER NOT NULL,
Amount       NUMBER NOT NULL,
MaturityDate DATE NOT NULL
);

INSERT INTO CD VALUES (573334, 10000,
   TO_DATE('15-JAN-2009','DD-MON-YYYY'));
INSERT INTO CD VALUES (677654, 25000,
   TO_DATE('15-JAN-2001','DD-MON-YYYY'));
INSERT INTO CD VALUES (976032, 10000,
   TO_DATE('15-JAN-1995','DD-MON-YYYY'));
INSERT INTO CD VALUES (275031, 10000,
   TO_DATE('15-JAN-1997','DD-MON-YYYY'));
INSERT INTO CD VALUES (274598, 20000,
   TO_DATE('15-JAN-1999','DD-MON-YYYY'));
INSERT INTO CD VALUES (538365, 45000,
   TO_DATE('15-JAN-2001','DD-MON-YYYY'));
INSERT INTO CD VALUES (267432, 16500,
   TO_DATE('15-JAN-2004','DD-MON-YYYY'));


rem *****************
rem The COMFORT Table
rem *****************

CREATE TABLE COMFORT (
City          VARCHAR2(13) NOT NULL,
SampleDate    DATE NOT NULL,
Noon          NUMBER(3,1),
Midnight      NUMBER(3,1),
Precipitation NUMBER
);

INSERT INTO COMFORT VALUES ('SAN FRANCISCO',
   TO_DATE('21-MAR-2003','DD-MON-YYYY'),62.5,42.3,.5);
INSERT INTO COMFORT VALUES ('SAN FRANCISCO',
   TO_DATE('22-JUN-2003','DD-MON-YYYY'),51.1,71.9,.1);
INSERT INTO COMFORT VALUES ('SAN FRANCISCO',
   TO_DATE('23-SEP-2003','DD-MON-YYYY'),NULL,61.5,.1);
INSERT INTO COMFORT VALUES ('SAN FRANCISCO',
   TO_DATE('22-DEC-2003','DD-MON-YYYY'),52.6,39.8,2.3);
INSERT INTO COMFORT VALUES ('KEENE',
   TO_DATE('21-MAR-2003','DD-MON-YYYY'),39.9,-1.2,4.4);
INSERT INTO COMFORT VALUES ('KEENE',
   TO_DATE('22-JUN-2003','DD-MON-YYYY'),85.1,66.7,1.3);
INSERT INTO COMFORT VALUES ('KEENE',
   TO_DATE('23-SEP-2003','DD-MON-YYYY'),99.8,82.6,NULL);
INSERT INTO COMFORT VALUES ('KEENE',
   TO_DATE('22-DEC-2003','DD-MON-YYYY'),-7.2,-1.2,3.9);


rem ******************
rem The COMFORT2 Table
rem ******************

CREATE TABLE COMFORT2 (
City          VARCHAR2(13) NOT NULL,
SampleDate    DATE NOT NULL,
Noon          NUMBER(3,1),
Midnight      NUMBER(3,1),
Precipitation NUMBER
);


rem **********************
rem The COMFORT_TEST Table
rem **********************

CREATE TABLE COMFORT_TEST (
City          VARCHAR2(13) NOT NULL,
SampleDate    DATE NOT NULL,
Measure       VARCHAR2(10),
Value         NUMBER(3,1)
);


rem *******************
rem The CONTINENT Table
rem *******************

CREATE TABLE CONTINENT (
 CONTINENT    VARCHAR2(30));


rem *****************
rem The COUNTRY Table
rem *****************

CREATE TABLE COUNTRY (
COUNTRY      VARCHAR2(30) NOT NULL,
CONTINENT    VARCHAR2(30));


rem ******************
rem The CUSTOMER Table
rem ******************

rem  Requires that the ADDRESS_TY and PERSON_TY types already
rem  exist.

CREATE TABLE CUSTOMER (
Customer_ID    NUMBER,
Person         PERSON_TY
);

INSERT INTO CUSTOMER VALUES
(1,
 PERSON_TY('NEIL MULLANE',
            ADDRESS_TY('57 MT PLEASANT ST',
                       'FINN', 'NH', 11111)));
INSERT INTO CUSTOMER VALUES
(2,
 PERSON_TY('SEYMOUR HESTER',
            ADDRESS_TY('1 STEPAHEAD RD',
                       'BRIANT', 'NH', 11111)));


rem ***************
rem The EMPTY Table
rem ***************

CREATE TABLE EMPTY (
Nothing       VARCHAR2(25),
LESS          NUMBER
);

REMARK No inserts. This table is empty.


rem *****************
rem The HOLIDAY Table
rem *****************

CREATE TABLE HOLIDAY (
HOLIDAY        VARCHAR2(25),
ActualDate     DATE,
CelebratedDate DATE
);

INSERT INTO HOLIDAY VALUES ('NEW YEARS DAY',
   TO_DATE('01-JAN-2004','DD-MON-YYYY'),
   TO_DATE('01-JAN-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('MARTIN LUTHER KING, JR.',
   TO_DATE('15-JAN-2004','DD-MON-YYYY'),
   TO_DATE('19-JAN-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('LINCOLNS BIRTHDAY',
   TO_DATE('12-FEB-2004','DD-MON-YYYY'),
   TO_DATE('16-FEB-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('WASHINGTONS BIRTHDAY',
   TO_DATE('22-FEB-2004','DD-MON-YYYY'),
   TO_DATE('16-FEB-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('FAST DAY, NEW HAMPSHIRE',
   TO_DATE('22-FEB-2004','DD-MON-YYYY'),
   TO_DATE('22-FEB-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('MEMORIAL DAY',
   TO_DATE('30-MAY-2004','DD-MON-YYYY'),
   TO_DATE('31-MAY-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('INDEPENDENCE DAY',
   TO_DATE('04-JUL-2004','DD-MON-YYYY'),
   TO_DATE('04-JUL-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('LABOR DAY',
   TO_DATE('06-SEP-2004','DD-MON-YYYY'),
   TO_DATE('06-SEP-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('COLUMBUS DAY',
   TO_DATE('12-OCT-2004','DD-MON-YYYY'),
   TO_DATE('11-OCT-2004','DD-MON-YYYY'));
INSERT INTO HOLIDAY VALUES ('THANKSGIVING',
   TO_DATE('25-NOV-2004','DD-MON-YYYY'),
   TO_DATE('25-NOV-2004','DD-MON-YYYY'));


rem ******************
rem The LOCATION Table
rem ******************

CREATE TABLE LOCATION (
City       VARCHAR2(25),
COUNTRY    VARCHAR2(25),
CONTINENT  VARCHAR2(25),
Latitude   NUMBER,
NorthSouth CHAR(1),
Longitude  NUMBER,
EastWest   CHAR(1)
);

INSERT INTO LOCATION VALUES (
  'ATHENS','GREECE','EUROPE',37.58,'N',23.43,'E');
INSERT INTO LOCATION VALUES (
  'CHICAGO','UNITED STATES','NORTH AMERICA',41.53,'N',87.38,'W');
INSERT INTO LOCATION VALUES (
  'CONAKRY','GUINEA','AFRICA',9.31,'N',13.43,'W');
INSERT INTO LOCATION VALUES (
  'LIMA','PERU','SOUTH AMERICA',12.03,'S',77.03,'W');
INSERT INTO LOCATION VALUES (
  'MADRAS','INDIA','INDIA',13.05,'N',80.17,'E');
INSERT INTO LOCATION VALUES (
  'MANCHESTER','ENGLAND','EUROPE',53.30,'N',2.15,'W');
INSERT INTO LOCATION VALUES (
  'MOSCOW','RUSSIA','EUROPE',55.45,'N',37.35,'E');
INSERT INTO LOCATION VALUES (
  'PARIS','FRANCE','EUROPE',48.52,'N',2.20,'E');
INSERT INTO LOCATION VALUES (
  'SHENYANG','CHINA','CHINA',41.48,'N',123.27,'E');
INSERT INTO LOCATION VALUES (
  'ROME','ITALY','EUROPE',41.54,'N',12.29,'E');
INSERT INTO LOCATION VALUES (
  'TOKYO','JAPAN','ASIA',35.42,'N',139.46,'E');
INSERT INTO LOCATION VALUES (
  'SYDNEY','AUSTRALIA','AUSTRALIA',33.52,'S',151.13,'E');
INSERT INTO LOCATION VALUES (
  'SPARTA','GREECE','EUROPE',37.05,'N',22.27,'E');
INSERT INTO LOCATION VALUES (
  'MADRID','SPAIN','EUROPE',40.24,'N',3.41,'W');


rem ******************
rem The MAGAZINE Table
rem ******************

CREATE TABLE MAGAZINE (
NAME       VARCHAR2(16),
Title      VARCHAR2(37),
AUTHOR     VARCHAR2(25),
IssueDate  DATE,
Page       NUMBER
);

INSERT INTO MAGAZINE VALUES (
  'BERTRAND MONTHLY','THE BARBERS WHO SHAVE THEMSELVES.',
  'BONHOEFFER, DIETRICH',
  TO_DATE('23-MAY-1988','DD-MON-YYYY'),70);
INSERT INTO MAGAZINE VALUES (
  'LIVE FREE OR DIE','"HUNTING THOREAU IN NEW HAMPSHIRE"',
  'CHESTERTON, G.K.',
  TO_DATE('26-AUG-1981','DD-MON-YYYY'),320);
INSERT INTO MAGAZINE VALUES (
  'PSYCHOLOGICA','THE ETHNIC NEIGHBORHOOD',
  'RUTH, GEORGE HERMAN',
  TO_DATE('18-SEP-1919','DD-MON-YYYY'),246);
INSERT INTO MAGAZINE VALUES (
  'FADED ISSUES','RELATIONAL DESIGN AND ENTHALPY',
  'WHITEHEAD, ALFRED',
  TO_DATE('20-JUN-1926','DD-MON-YYYY'),279);
INSERT INTO MAGAZINE VALUES (
  'ENTROPY WIT','"INTERCONTINENTAL RELATIONS."',
  'CROOKES, WILLIAM',
  TO_DATE('20-SEP-1950','DD-MON-YYYY'),20);


rem **************
rem The MATH Table
rem **************

CREATE TABLE MATH (
NAME          VARCHAR2(12),
Above         NUMBER,
Below         NUMBER,
EMPTY         NUMBER
);

INSERT INTO MATH VALUES ('WHOLE NUMBER',11,-22,NULL);
INSERT INTO MATH VALUES ('LOW DECIMAL',33.33,-44.44,NULL);
INSERT INTO MATH VALUES ('MID DECIMAL',55.5,-55.5,NULL);
INSERT INTO MATH VALUES ('HIGH DECIMAL',66.666,-77.777,NULL);


rem **************
rem The NAME Table
rem **************

CREATE TABLE NAME (
NAME         VARCHAR2(25)
);

INSERT INTO NAME VALUES ('HORATIO NELSON');
INSERT INTO NAME VALUES ('VALDO');
INSERT INTO NAME VALUES ('MARIE DE MEDICIS');
INSERT INTO NAME VALUES ('FLAVIUS JOSEPHUS');
INSERT INTO NAME VALUES ('EDYTHE P. M. GAMMIERE');


rem *******************
rem The NEWSPAPER Table
rem *******************

CREATE TABLE NEWSPAPER (
Feature      VARCHAR2(15) NOT NULL,
SECTION      CHAR(1),
Page         NUMBER
);

INSERT INTO NEWSPAPER VALUES ('National News', 'A', 1);
INSERT INTO NEWSPAPER VALUES ('Sports', 'D', 1);
INSERT INTO NEWSPAPER VALUES ('Editorials', 'A', 12);
INSERT INTO NEWSPAPER VALUES ('Business', 'E', 1);
INSERT INTO NEWSPAPER VALUES ('Weather', 'C', 2);
INSERT INTO NEWSPAPER VALUES ('Television', 'B', 7);
INSERT INTO NEWSPAPER VALUES ('Births', 'F', 7);
INSERT INTO NEWSPAPER VALUES ('Classified', 'F', 8);
INSERT INTO NEWSPAPER VALUES ('Modern Life', 'B', 1);
INSERT INTO NEWSPAPER VALUES ('Comics', 'C', 4);
INSERT INTO NEWSPAPER VALUES ('Movies', 'B', 4);
INSERT INTO NEWSPAPER VALUES ('Bridge', 'B', 2);
INSERT INTO NEWSPAPER VALUES ('Obituaries', 'F', 6);
INSERT INTO NEWSPAPER VALUES ('Doctor Is In', 'F', 6);


rem ********************
rem The NUMBERTEST Table
rem ********************

CREATE TABLE NUMBERTEST (
Value1        NUMBER,
Value2        NUMBER,
Value3        NUMBER(10,2)
);

INSERT INTO NUMBERTEST VALUES (0,0,0);
INSERT INTO NUMBERTEST VALUES (.0001,.0001,.0001);
INSERT INTO NUMBERTEST VALUES (1234,1234,1234);
INSERT INTO NUMBERTEST VALUES (1234.5,1234.5,1234.5);
INSERT INTO NUMBERTEST VALUES (NULL,NULL,NULL);
INSERT INTO NUMBERTEST VALUES (1234.56,1234.56,1234.56);
INSERT INTO NUMBERTEST VALUES (1234.567,1234.567,1234.567);
INSERT INTO NUMBERTEST VALUES
     (98761234.567,98761234.567,98761234.567);


rem ****************
rem The PAYDAY Table
rem ****************

CREATE TABLE PAYDAY (
CycleDate      DATE
);

INSERT INTO PAYDAY VALUES (TO_DATE('15-JAN-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-FEB-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-MAR-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-APR-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-MAY-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-JUN-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-JUL-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-AUG-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-SEP-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-OCT-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-NOV-2004','DD-MON-YYYY'));
INSERT INTO PAYDAY VALUES (TO_DATE('15-DEC-2004','DD-MON-YYYY'));


rem ******************
rem The PROPOSAL Table
rem ******************

CREATE TABLE PROPOSAL
(Proposal_ID        NUMBER(10) PRIMARY KEY,
 Recipient_Name     VARCHAR2(25),
 Proposal_Name      VARCHAR2(25),
 Short_Description  VARCHAR2(1000),
 Proposal_Text      CLOB,
 Budget             BLOB,
 Cover_Letter       BFILE);


rem *********************
rem The RADIUS_VALS Table
rem *********************

CREATE TABLE RADIUS_VALS
(Radius      NUMBER(5));

INSERT INTO RADIUS_VALS VALUES (3);


rem ****************
rem The RATING Table
rem ****************

CREATE TABLE RATING
(RATING  VARCHAR2(2),
RatingDescription VARCHAR2(50));

INSERT INTO RATING VALUES ('1','ENTERTAINMENT');
INSERT INTO RATING VALUES ('2','BACKGROUND INFORMATION');
INSERT INTO RATING VALUES ('3','RECOMMENDED');
INSERT INTO RATING VALUES ('4','STRONGLY RECOMMENDED');
INSERT INTO RATING VALUES ('5','REQUIRED READING');
COMMIT;


rem **************
rem The ROSE Table
rem **************

CREATE TABLE ROSE (
Lodging       VARCHAR2(12)
);

INSERT INTO ROSE VALUES ('ROSELYN');
INSERT INTO ROSE VALUES ('ROSE HILL');
INSERT INTO ROSE VALUES ('ROSE GARDEN');
INSERT INTO ROSE VALUES ('ROSE');


rem ******************
rem The SHIPPING Table
rem ******************

CREATE TABLE SHIPPING (
Client        VARCHAR2(13),
Weight        NUMBER
);

INSERT INTO SHIPPING VALUES ('JOHNSON TOOL',59);
INSERT INTO SHIPPING VALUES ('DAGG SOFTWARE',27);
INSERT INTO SHIPPING VALUES ('TULLY ANDOVER',NULL);


rem ***************
rem The STOCK Table
rem ***************

CREATE TABLE STOCK (
Company      VARCHAR2(20),
Symbol       VARCHAR2(6),
Industry     VARCHAR2(15),
CloseYesterday NUMBER(6,2),
CloseToday     NUMBER(6,2),
Volume         NUMBER
);

INSERT INTO STOCK VALUES (
  'AD SPECIALTY', 'ADSP', 'ADVERTISING',  31.75, 31.75,
   18333876);
INSERT INTO STOCK VALUES (
  'APPLE CANNERY', 'APCN', 'AGRICULTURE',  33.75, 36.50,
   25787229);
INSERT INTO STOCK VALUES (
  'AT SPACE', 'ATR' , 'MEDICAL', 46.75, 48.00,
   11398323);
INSERT INTO STOCK VALUES (
  'AUGUST ENTERPRISES', 'AGE', 'MEDICAL', 15.00, 15.00,
   12221711);
INSERT INTO STOCK VALUES (
  'BRANDON ELLIPSIS', 'BELP', 'SPACE', 32.75, 33.50,
  25789769);
INSERT INTO STOCK VALUES (
  'GENERAL ENTROPY','GENT', 'SPACE', 64.25, 66.00,
   7598562);
INSERT INTO STOCK VALUES (
  'GENEVA ROCKETRY', 'GENR', 'SPACE', 22.75, 27.25,
   22533944);
INSERT INTO STOCK VALUES (
  'HAYWARD ANTISEPTIC',  'HAYW', 'MEDICAL', 104.25,  106.00,
   3358561);
INSERT INTO STOCK VALUES (
  'IDK', 'IDK', 'ELECTRONICS',  95.00, 95.25,
   9443523);
INSERT INTO STOCK VALUES (
  'INDIA COSMETICS','INDI', 'COSMETICS', 30.75, 30.75,
   8134878);
INSERT INTO STOCK VALUES (
  'ISAIAH JAMES STORAGE', 'IJS', 'TRANSPORTATION', 13.25, 13.75,
   22112171);
INSERT INTO STOCK VALUES (
  'KDK AIRLINES',  'KDK', 'TRANSPORTATION', 85.00, 85.25,
   7481566);
INSERT INTO STOCK VALUES (
  'KENTGEN BIOPHYSICS',  'KENT', 'MEDICAL', 18.25, 19.50,
   6636863);
INSERT INTO STOCK VALUES (
  'LAVAY COSMETICS', 'LAVA', 'COSMETICS', 21.50, 22.00,
   3341542);
INSERT INTO STOCK VALUES (
  'LOCAL DEVELOPMENT',  'LOCD', 'AGRICULTURE',  26.75, 27.25,
   2596934);
INSERT INTO STOCK VALUES (
  'MAXTIDE'  , 'MAXT', 'TRANSPORTATION', 8.25, 8.00,
   2836893);
INSERT INTO STOCK VALUES (
  'MBK COMMUNICATIONS', 'MBK', 'ADVERTISING',  43.25, 41.00,
   10022980);
INSERT INTO STOCK VALUES (
  'MEMORY GRAPHICS', 'MEMG', 'ELECTRONICS',  15.50, 14.25,
   4557992);
INSERT INTO STOCK VALUES (
'MICRO TOKEN', 'MICT', 'ELECTRONICS',  77.00, 76.50,
   25205667);
INSERT INTO STOCK VALUES (
  'NANCY LEE FEATURES', 'NLF', 'ADVERTISING',  13.50, 14.25,
   14222692);
INSERT INTO STOCK VALUES (
  'NORTHERN BOREAL', 'NBOR', 'SPACE', 26.75, 28.00,
   1348323);
INSERT INTO STOCK VALUES (
  'OCKHAM SYSTEMS', 'OCKS', 'SPACE', 21.50, 22.00,
   7052990);
INSERT INTO STOCK VALUES (
  'OSCAR COAL DRAYAGE', 'OCD', 'TRANSPORTATION', 87.00, 88.50,
   25798992);
INSERT INTO STOCK VALUES (
  'ROBERT JAMES APPAREL', 'RJAP', 'GARMENT', 23.25, 24.00,
   19032481);
INSERT INTO STOCK VALUES (
  'SOUP SENSATIONS','SOUP', 'AGRICULTURE',  16.25, 16.75,
   22574879);
INSERT INTO STOCK VALUES (
  'WONDER LABS', 'WOND', 'SPACE', 5.00, 5.00,
   2553712);


rem ***********************
rem The STOCK_ACCOUNT table
rem ***********************

CREATE TABLE STOCK_ACCOUNT
(ACCOUNT  NUMBER(10),
AccountLongName  VARCHAR2(50));

INSERT INTO STOCK_ACCOUNT VALUES (
1234, 'ADAMS');
INSERT INTO STOCK_ACCOUNT VALUES (
7777, 'BURLINGTON');
COMMIT;


rem *******************
rem The STOCK_TRX Table
rem *******************

CREATE TABLE STOCK_TRX (
ACCOUNT  NUMBER(10),
Symbol  VARCHAR2(20),
Price  NUMBER(6,2),
Quantity  NUMBER(6),
Trx_Flag  VARCHAR2(1));

INSERT INTO STOCK_TRX VALUES (
  1234, 'ADSP', 31.75, 100, 'B');
INSERT INTO STOCK_TRX VALUES (
  7777, 'ADSP', 31.50, 300, 'S');
INSERT INTO STOCK_TRX VALUES (
  1234, 'ADSP', 31.55, 100, 'B');
INSERT INTO STOCK_TRX VALUES (
  7777, 'OCKS', 21.75, 1000, 'B');
COMMIT;


rem *****************
rem The TROUBLE Table
rem *****************

CREATE TABLE TROUBLE (
City          VARCHAR2(13) NOT NULL,
SampleDate    DATE NOT NULL,
Noon          NUMBER(4,1),
Midnight      NUMBER(3,1),
Precipitation NUMBER
);

INSERT INTO TROUBLE VALUES ('PLEASANT LAKE',
  '21-MAR-01', 39.99, -1.31, 3.6);
INSERT INTO TROUBLE VALUES ('PLEASANT LAKE',
  '22-JUN-01', 101.44, 86.2, 1.63);
INSERT INTO TROUBLE VALUES ('PLEASANT LAKE',
  '23-SEP-01', 92.85, 79.6, 1.00003);
INSERT INTO TROUBLE VALUES ('PLEASANT LAKE',
  '22-DEC-01', -17.445, -10.4, 2.4);


rem *****************
rem The TWONAME Table
rem *****************

CREATE TABLE TWONAME (
FirstName    VARCHAR2(25),
LastName     VARCHAR2(25)
);


rem *****************
rem The WEATHER Table
rem *****************

CREATE TABLE WEATHER (
City         VARCHAR2(11),
Temperature  NUMBER,
Humidity     NUMBER,
Condition    VARCHAR2(9)
);

INSERT INTO WEATHER VALUES ('LIMA',45,79,'RAIN');
INSERT INTO WEATHER VALUES ('PARIS',81,62,'CLOUDY');
INSERT INTO WEATHER VALUES ('MANCHESTER',66,98,'FOG');
INSERT INTO WEATHER VALUES ('ATHENS',97,89,'SUNNY');
INSERT INTO WEATHER VALUES ('CHICAGO',66,88,'RAIN');
INSERT INTO WEATHER VALUES ('SYDNEY',69,99,'SUNNY');
INSERT INTO WEATHER VALUES ('SPARTA',74,63,'CLOUDY');
	

rem *****************
rem The LEDGER Table
rem *****************

CREATE TABLE LEDGER
(
  ACTIONDATE    DATE,
  ACTION        VARCHAR2(8 BYTE),
  ITEM          VARCHAR2(30 BYTE),
  QUANTITY      NUMBER,
  QUANTITYTYPE  VARCHAR2(10 BYTE),
  RATE          NUMBER,
  AMOUNT        NUMBER(9,2),
  PERSON        VARCHAR2(25 BYTE)
);

INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/03/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'HOMINY', 1, 'BUSHEL', 1.25, 1.25, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/04/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'GERHARDT KENTGEN');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/09/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'LICE KILLER', 1, 'BOX', 0.5, 0.5, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/11/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'MENDING BRACE', 1, 'EACH', 0.15, 0.15, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/11/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'STOVE BLACKING', 1, 'BOX', 0.05, 0.05, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/12/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'GEORGE OSCAR');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/14/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'LANTERN GLOBE', 1, 'EACH', 0.1, 0.1, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/14/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BEEF HIDE', 1, 'EACH', 5.46, 5.46, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/14/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'CHEESE FLAT', 13, 'EACH', 3.15, 40.95, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/15/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'STAMP FOR LETTER', 1, 'EACH', 0.02, 0.02, 'POST OFFICE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/15/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'STOCKING', 2, 'PAIR', 0.15, 0.3, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/16/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'OIL', 4, 'GALLON', 0.1, 0.4, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/16/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'MOLASSES', 1, 'GALLON', 0.6, 0.6, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/16/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'CARD OF THANKS', 1, 'EACH', 0.3, 0.3, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/16/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SUGAR', 25, 'LB', 0.07, 1.75, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/17/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'HORSE SHODDING', 1, 'EACH', 0.85, 0.85, 'LIVERY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/17/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'CORN', 230, 'LB', 0.01, 2.3, 'FEED STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'CORN MEAL', 213, 'LB', 0.01, 2.13, 'FEED STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'PAPER', 50, 'SHEETS', 0.01, 0.5, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'COFFEE', 1, 'LB', 0.3, 0.3, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'COTTON STOCKING', 3, 'PAIR', 0.08, 0.24, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SEEDED RAISINS', 1, 'LB', 0.12, 0.12, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/19/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'COTTON STOCKING', 3, 'PAIR', 0.08, 0.24, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/19/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SALT PETER', 1, 'TABLET', 0.08, 0.08, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/19/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'CREOAL', 2, 'QUART', 0.37, 0.74, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/19/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'ENVELOPES', 6, 'EACH', 0.02, 0.12, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/19/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'HAT', 1, 'EACH', 0.1, 0.1, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/19/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'GRINDING BAT', 24, 'EACH', 0.03, 0.72, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/19/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'TELEPHONE CALL', 1, 'EACH', 0.15, 0.15, 'PHONE COMPANY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/19/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'TEA', 0.5, 'LB', 0.5, 0.25, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/23/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'WOOD', 1, 'CORD', 2, 2, 'METHODIST CHURCH');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/24/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SCHOOLING', 1, 'TERM', 1, 1, 'SCHOOL');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/24/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'HOMINY', 186, 'TERM', 0.01, 1.86, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/28/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'GRINDING', 1, 'EACH', 0.9, 0.9, 'MILL');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('01/28/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'POPCORN', 5, 'LB', 0.04, 0.2, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/02/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SULPHER', 5, 'LB', 0.25, 1.25, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/03/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'OIL', 4, 'GALLON', 0.13, 0.52, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/03/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SWAMP ROOT', 1, 'BOTTLE', 0.75, 0.75, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/04/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SHOEING NED', 1, 'EACH', 0.5, 0.5, 'BLACKSMITH');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/04/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'GRINDING', 1, 'EACH', 0.47, 0.47, 'MILL');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/04/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 0.5, 'DAY', 1, 0.5, 'ELBERT TALBOT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/05/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'PILLS', 1, 'BOX', 0.25, 0.25, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/07/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'THREAD', 2, 'SPOOLS', 0.05, 0.1, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/08/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SHIRTS', 2, 'EACH', 0.5, 1, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/10/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BUTTER', 9, 'LB', 0.25, 2.25, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'HORSE MEDISON', 1, 'ENVELOPE', 0.13, 0.13, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'ELBO STOVE PIPE', 1, 'EACH', 0.15, 0.15, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'CALF', 1, 'EACH', 4, 4, 'LILY CARLSTROM');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/25/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BUTTER', 21, 'LB', 0.25, 5.25, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('02/28/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'SWAMP ROOT', 1, 'BOTTLE', 0.75, 0.75, 'GENERAL STORE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('04/01/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'PLOWING', 1, 'DAY', 3, 3, 'RICHARD KOCH AND BROTHERS');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('04/05/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'DICK JONES');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('05/02/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'DICK JONES');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('06/03/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'ELBERT TALBOT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('06/13/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'PETER LAWSON');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('07/14/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1.2, 1.2, 'WILFRED LOWELL');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('07/15/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 2.25, 2.25, 'KAY AND PALMER WALLBOM');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('08/06/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'PLOWING', 1, 'DAY', 1.8, 1.8, 'VICTORIA LYNN');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('08/06/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'PLOWING', 2, 'DAY', 2, 4, 'ANDREW DYE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('08/10/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'HELEN BRANDT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('08/11/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 2, 2, 'HELEN BRANDT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('09/09/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'ADAH TALBOT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('09/11/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 0.75, 0.75, 'ROLAND BRANDT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('10/03/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BOOT BETWEEN HORSES', 1, 'EACH', 12.5, 12.5, 'GARY KENTGEN');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('10/07/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'PLOWING', 0.5, 'DAY', 3, 1.5, 'RICHARD KOCH AND BROTHERS');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('10/09/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 0.5, 'DAY', 1.25, 0.63, 'DONALD ROLLO');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/01/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'CALF', 2, 'EACH', 2, 4, 'GARY KENTGEN');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/02/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'MARE', 1, 'EACH', 5, 5, 'JAMES COLE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/03/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'PIG', 1, 'EACH', 2, 2, 'ANDREW DYE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/04/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'HAY', 1, 'WAGON', 5, 5, 'ANDREW DYE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/05/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'HAY', 4, 'WAGON', 5, 20, 'ANDREW DYE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/05/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'LINE', 1, 'SET', 0.75, 0.75, 'ANDREW DYE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/06/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'COLT', 2, 'COLT', 4.5, 9, 'ANDREW DYE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/07/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'SAWED WOOD', 1, 'DAY', 0.5, 0.5, 'ANDREW DYE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/09/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'COLT', 1, 'EACH', 10, 10, 'ANDREW DYE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/10/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1.25, 1.25, 'JOHN PEARSON');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/10/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'HEFER', 1, 'EACH', 28, 28, 'PAT LAVAY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/11/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BOOT BETWEEN HORSES', 1, 'EACH', 6, 6, 'PAT LAVAY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/11/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BUTTER', 1, 'LB', 0.15, 0.15, 'PAT LAVAY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/12/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 2, 'DAY', 0.75, 1.5, 'PAT LAVAY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/13/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'CUT LOGS', 0.5, 'DAY', 0.5, 0.25, 'PAT LAVAY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/13/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'DRAWED LOGS', 1.5, 'DAY', 0.5, 0.75, 'PAT LAVAY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/14/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'HEFER', 1, 'EACH', 35, 35, 'MORRIS ARNOLD');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/15/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BEEF', 37, 'LB', 0.04, 1.48, 'FRED FULLER');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/16/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BUTTER', 5, 'LB', 0.16, 0.8, 'VICTORIA LYNN');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/18/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BUTTER', 6, 'LB', 0.16, 0.96, 'JOHN PEARSON');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/20/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'HEFER', 1, 'EACH', 30, 30, 'PALMER WALLBOM');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/21/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BEEF', 116, 'LB', 0.06, 6.96, 'ROLAND BRANDT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('11/22/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SOLD', 'BEEF', 118, 'LB', 0.06, 7.08, 'GERHARDT KENTGEN');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/01/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'BEEF', 138, 'LB', 0.05, 6.9, 'VICTORIA LYNN');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/01/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'BEEF', 130, 'LB', 0.06, 7.8, 'GEORGE B. MCCORMICK');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/03/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'BEEF', 130, 'LB', 0.05, 6.5, 'PETER LAWSON');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/03/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'BEEF', 125, 'LB', 0.06, 7.5, 'HELEN BRANDT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/05/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'BEEF', 140, 'LB', 0.05, 7, 'ROBERT JAMES');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/05/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'BEEF', 145, 'LB', 0.05, 7.25, 'ISAIAH JAMES');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/07/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'HORSE', 1, 'EACH', 30, 30, 'GEORGE AUGUST');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/07/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'REAPER/BINDER', 1, 'EACH', 47.5, 47.5, 'JANICE TALBOT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/12/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'WORK', 1, 'DAY', 1, 1, 'BART SARJEANT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/13/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'SAWED WOOD', 1, 'DAY', 0.5, 0.5, 'PAT LAVAY');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('12/17/1901 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PAID', 'SAWING', 1, 'DAY', 0.75, 0.75, 'DICK JONES');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('03/10/2001 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'STOVE PIPE THIMBLES', 2, 'EACH', 0.5, 1, 'VERNA HARDWARE');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('03/15/2001 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'RECEIVED', 'BOOT BETWEEN HORSES', 1, 'EACH', 10, 10, 'ADAH TALBOT');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('06/09/2001 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOUGHT', 'USE OF PASTURE', 1, 'EACH', 10, 10, 'GEORGE B. MCCORMICK');
INSERT INTO LEDGER
   (ACTIONDATE, ACTION, ITEM, QUANTITY, QUANTITYTYPE, RATE, AMOUNT, PERSON)
 VALUES
   (TO_DATE('10/18/2001 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'RECEIVED', 'BOOT BETWEEN HORSES', 1, 'EACH', 10, 10, 'ADAH TALBOT');
COMMIT;


CREATE TABLE WORKER
(
  NAME     VARCHAR2(25 BYTE)                    NOT NULL,
  AGE      NUMBER,
  LODGING  VARCHAR2(15 BYTE)
);

INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('BART SARJEANT', 22, 'CRANMER');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('ELBERT TALBOT', 43, 'WEITBROCHT');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('DONALD ROLLO', 16, 'MATTS');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('JED HOPKINS', 33, 'MATTS');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('WILLIAM SWING', 15, 'CRANMER');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('JOHN PEARSON', 27, 'ROSE HILL');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('GEORGE OSCAR', 41, 'ROSE HILL');
INSERT INTO WORKER
   (NAME, LODGING)
 VALUES
   ('KAY AND PALMER WALLBOM', 'ROSE HILL');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('PAT LAVAY', 21, 'ROSE HILL');
INSERT INTO WORKER
   (NAME, LODGING)
 VALUES
   ('RICHARD KOCH AND BROTHERS', 'WEITBROCHT');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('DICK JONES', 18, 'ROSE HILL');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('ADAH TALBOT', 23, 'PAPA KING');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('ROLAND BRANDT', 35, 'MATTS');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('PETER LAWSON', 25, 'CRANMER');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('VICTORIA LYNN', 32, 'MULLERS');
INSERT INTO WORKER
   (NAME, AGE)
 VALUES
   ('WILFRED LOWELL', 67);
INSERT INTO WORKER
   (NAME, AGE)
 VALUES
   ('HELEN BRANDT', 15);
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('GERHARDT KENTGEN', 55, 'PAPA KING');
INSERT INTO WORKER
   (NAME, AGE, LODGING)
 VALUES
   ('ANDREW DYE', 29, 'ROSE HILL');
COMMIT;


CREATE TABLE WORKERSKILL
(
  NAME     VARCHAR2(25 BYTE)                    NOT NULL,
  SKILL    VARCHAR2(25 BYTE)                    NOT NULL,
  ABILITY  VARCHAR2(15 BYTE)
);

INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('DICK JONES', 'SMITHY', 'EXCELLENT');
INSERT INTO WORKERSKILL
   (NAME, SKILL)
 VALUES
   ('JOHN PEARSON', 'COMBINE DRIVER');
INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('JOHN PEARSON', 'SMITHY', 'AVERAGE');
INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('HELEN BRANDT', 'COMBINE DRIVER', 'VERY FAST');
INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('JOHN PEARSON', 'WOODCUTTER', 'GOOD');
INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('VICTORIA LYNN', 'SMITHY', 'PRECISE');
INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('ADAH TALBOT', 'WORK', 'GOOD');
INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('WILFRED LOWELL', 'WORK', 'AVERAGE');
INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('ELBERT TALBOT', 'DISCUS', 'SLOW');
INSERT INTO WORKERSKILL
   (NAME, SKILL, ABILITY)
 VALUES
   ('WILFRED LOWELL', 'DISCUS', 'AVERAGE');
COMMIT;