Data Architecture

CREATE TABLE Application_Key (
    KEY_VARIABLE VARCHAR2(3) NOT NULL,
    KEY_DESCRIPTION VARCHAR2(100),
CONSTRAINT Application_Key_PK PRIMARY KEY(KEY_VARIABLE));
 
CREATE TABLE Departments(
    DEPTABREV VARCHAR2(50) NOT NULL,
    DEPARTMENT VARCHAR2(250),
CONSTRAINT Departments_PK PRIMARY KEY(DEPTABREV));
 
CREATE TABLE Faculty(
    ID1 NUMBER(3) NOT NULL,
    LASTNAME VARCHAR2(100),
    FIRSTNAME VARCHAR2(100),
    MIDINITL VARCHAR2(10),
    TITLE VARCHAR2(100),
    RANK VARCHAR2(100),
    DEPTABREV VARCHAR2(10),
    REQUESTED_MEMBERSHIP VARCHAR2(10),
    MEMBERSHIP_TERMINATED BOOLEAN,
    TERMINATION_DATE DATE,
    CURRENT_MEMBERSHIP VARCHAR2(2),
    APPLICATION_DATE DATE,
    PART_OR_FULL_TIME VARCHAR2(10),
    EDUCATION VARCHAR2(255),
    OTHER_AFFILIATIONS_POSITIONS VARCHAR2(255),
    PRIOR_GRADUATE_TEACHING BOOLEAN,
    COMPLETED_MASTER_THESES_DIRECTED_OR_CO NUMBER(2),
    COMPLETED_DISSERTATIONS_DIRECTED_OR_CO NUMBER(2),
    ACCOMPLISHMENTS VARCHAR2(255),
    ASSOC_MEMBER_YEARS VARCHAR2(2),
    DEPARTMENT_CHAIR VARCHAR2(35),
    COMPLETED_MASTER_THESES_NOT_DIRECTED NUMBER(2),
    CURRENT_MASTER_THESES_DIRECTOR NUMBER(2),
    CURRENT_MASTER_THESES_CO_DIRECTED NUMBER(2),
    CURRENT_MASTER_THESES_NO_DIRECTED NUMBER(2),
    COMPLETED_DISSERTATIONS_NOT_DIRECTED NUMBER(2),
    CURRENT_DISSERTATIONS_DIRECTED NUMBER(2),
    CURRENT_DISSERTATIONS_CO_DIRECTED NUMBER(2),
    CURRENT_DISSERTATIONS_NOT_DIRECTED NUMBER(2),
CONSTRAINT FACULTY_PK PRIMARY KEY(ID1));
 
CREATE TABLE PROGRAMS(
    FIELD1 NUMBER(3) NOT NULL,
    PROGRAM_DESC VARCHAR2(50),
    PROGRAM_CODE VARCHAR2(4),
    GPD VARCHAR2(30),
    GPD_TELEPHONE VARCHAR2(15),
    GPD_EMAIL VARCHAR2(50),
    GPD_MAIL_ADDRESS VARCHAR2(50),
    SUPPORT_STAFF VARCHAR2(40),
    STAFF_PHONE VARCHAR2(15),
    STAFF_EMAIL VARCHAR2(30),
    STAFF_MAIL_ADDRESS VARCHAR2(50),
    DEPARTMENT_CHAIR VARCHAR2(50),
    DEPARTMENT_1 VARCHAR2(50),
    DEPARTMENT_2 VARCHAR2(50),
    DEPARTMENT_3 VARCHAR2(50),
    DEPARTMENT_4 VARCHAR2(50),
    PHD BOOLEAN,
    MA BOOLEAN,
    MS BOOLEAN,
    MPS BOOLEAN,
    MFA BOOLEAN,
    CERTIFICATE BOOLEAN,
    OTHER VARCHAR2(50),
    TRACKS MEMO,
CONSTRAINT PROGRAMS_PK PRIMARY KEY(FIELD1));

The below DDL is totally incorrect and old. Tables in a newer version have been revamped and rearranged and new stuff added. Real DDL will follow soon.

CREATE TABLE FACULTY (
    FACULTY _ID NUMBER(10) NOT NULL,
    LASTNAME VARCHAR2(20) NOT NULL,
    FIRSTNAME VARCHAR2(20) NOT NULL,
    MIDINITL VARCHAR2(2),
    TITLE VARCHAR2(20) NOT NULL,
    STATUS VARCHAR2(15),
CONSTRAINT FACULTY_FACULTY_ID_PK PRIMARY KEY(FACULTY_ID));
 
CREATE TABLE FACULTY_EDUCATION (
    FACULTYEDU_ID NUMBER(10) NOT NULL,
    FACULTY _ID NUMBER(10) NOT NULL,
    Degree_Type VARCHAR2(20) NOT NULL,
    Other_Affliation VARCHAR2(20) NOT NULL,
    Totalyrs_Tought NUMBER(5),
CONSTRAINT FACULTY_EDUCATION_FACULTYEDU_ID_FACULTY_ID_PK PRIMARY KEY(FACULTYEDU_ID, FACULTY_ID));
 
CREATE TABLE DEPARTMENT(
    Depart_Name VARCHAR2(20) NOT NULL,
    FACULTY _ID NUMBER(10) NOT NULL,
    Department_Telephone VARCHAR2(20) NOT NULL,
    Department_Email VARCHAR2(20),
    Department_Address VARCHAR2(30) NOT NULL,
    Department_Chair VARCHAR2(20),
CONSTRAINT DEPARTMENT_DEPART_NAME_FACULTY_ID_PK PRIMARY KEY(DEPART_NAME, FACULTY_ID));
 
CREATE TABLE PROGRAM(
    PROGRAM_ID NUMBER(10) NOT NULL,
    FACULTY _ID NUMBER(10) NOT NULL,
    Program_Desc VARCHAR2(20) NOT NULL,
    GPD Telephone NUMBER(14),
    GPD_Email VARCHAR2(20) NOT NULL,
    GPD_Address VARCHAR2(20) NOT NULL,
    Program_Type VARCHAR2(20) NOT NULL,
    Certification VARCHAR2(20) NOT NULL,
    Other VARCHAR2(20) NOT NULL,
CONSTRAINT PROGRAM_PROGRAM_ID_FACULTY_ID_PK PRIMARY KEY(PROGRAM_ID, FACULTY_ID));
 
CREATE TABLE FACULTY_SKILL(
    FacultySkill_ID NUMBER(10) NOT NULL,
    FACULTY _ID NUMBER(10) NOT NULL,
    Skill_Type VARCHAR2(20) NOT NULL,
    Skill_Desc VARCHAR2(20),
CONSTRAINT FACULTY_SKILL_FACULTYSKILL_ID_FACULTY_ID_PK PRIMARY KEY(FACULTYSKILL_ID, FACULTY_ID));