CREATE table "AREA" (
    "AREAID"     VARCHAR2(4000),
    "AREANAME"       VARCHAR2(4000),
    "DESCRIPTION"      VARCHAR2(4000),
    constraint  "AREA_PK" primary key ("AREAID")
);


CREATE table "DIRECTORS" (
    "DIRECTORID"     VARCHAR2(4000),
    "LNAME"       VARCHAR2(4000),
    "FNAME"      VARCHAR2(4000),
    constraint  "DIRECTORS_PK" primary key ("DIRECTORID")
);



CREATE table "SCHOOLS" (
    "SCHOOLID"     VARCHAR2(4000),
    "SCHOOLNAME"       VARCHAR2(4000),
    constraint  "SCHOOLS_PK" primary key ("SCHOOLID")
);


CREATE table "RESEARCHERS" (
    "RESEARCHERID"     VARCHAR2(4000),
    "LNAME"       VARCHAR2(4000),
	"FNAME"		 VARCHAR2(4000),
	"SCHOOLID"    VARCHAR2(4000) REFERENCES "SCHOOLS" ("SCHOOLID"),
    constraint  "RESEARCHERS_PK" primary key ("RESEARCHERID")
);

CREATE table "PROGRAMS" (
    "PROGID"     VARCHAR2(4000),
    "PNAME"       VARCHAR2(4000),
	"STARTED"		DATE,
	"DIRECTORID"    VARCHAR2(4000) REFERENCES "DIRECTORS" ("DIRECTORID"),
    constraint  "PROGRAMS_PK" primary key ("PROGID")
);


CREATE table "GRANTS" (
    "GRANTID"     VARCHAR2(4000),
    "TITLE"       VARCHAR2(4000),
	"STARTED"		DATE,
	"ENDED"			DATE,
	"AMOUN"			NUMBER
	"DESCRIPTION"      VARCHAR2(4000),
	"SCHOOLID"    VARCHAR2(4000) REFERENCES "SCHOOLS" ("SCHOOLID"),
	"PI"            VARCHAR2(4000) 
    constraint  "GRANTS_PK" primary key ("GRANTID"),
	);