DROP TABLE STOCKDATES CASCADE CONSTRAINTS ; 
DROP TABLE STOCKHISTORY CASCADE CONSTRAINTS ; 
DROP TABLE STOCKNAME CASCADE CONSTRAINTS ; 

CREATE TABLE STOCKNAME ( 
  TICKER       CHAR (6)      NOT NULL, 
  DESCRIPTION  VARCHAR2 (200), 
  CONSTRAINT PK_STOCKNAME
  PRIMARY KEY ( TICKER )); 

CREATE TABLE STOCKHISTORY ( 
  TICKER        CHAR (6)      NOT NULL, 
  QUOTEDATE     DATE          NOT NULL, 
  CLOSEPRICE    FLOAT         NOT NULL, 
  OPENPRICE     FLOAT         NOT NULL, 
  HIGHPRICE     FLOAT         NOT NULL, 
  LOWPRICE      FLOAT         NOT NULL, 
  AVERAGEPRICE  FLOAT         NOT NULL, 
  CONSTRAINT PK_STOCKHISTORY
  PRIMARY KEY ( TICKER, QUOTEDATE )); 

CREATE TABLE STOCKDATES ( 
  LASTDATE  DATE, 
  CURDATE   DATE);