Schema of database used by Elmasri, Navathe

create table employee (
    fname varchar(20),
    minit varchar(40),
    lname varchar(20),
    ssn int,
    bdate date,
    address varchar(50),
    sex char,
    salary float,
    super_ssn int,
    dno int,
    primary key(ssn)
);

create table department (
    dname varchar(20),
    dnumber int,
    mgr_ssn int,
    mgr_start_date date,
    primary key(dnumber)
);

create table dept_locations (
    dnumber int,
    dlocation varchar(20),
    primary key (dnumber, dlocation)
);

create table project (
    pname varchar(20),
    pnumber int,
    plocation varchar(20),
    dnum int,
    primary key(pnumber)
);

create table works_on (
    essn int,
    pno int,
    hours time,
    primary key (essn, pno)
);

create table dependent (
    essn int,
    dependent_name varchar(20),
    sex char,
    bdate date,
    relationship varchar(20),
    primary key (essn, dependent_name)
);

alter table employee add constraint foreign key (dno) references department(dnumber);
alter table employee add constraint foreign key (super_ssn) references employee(ssn);
alter table dept_locations add constraint foreign key (dnumber) references department(dnumber);
alter table project add constraint foreign key (dnum) references department(dnumber);
alter table works_on add constraint foreign key (essn) references employee(ssn);
alter table works_on add constraint foreign key (pno) references project(pnumber);
alter table dependent add constraint foreign key (essn) references employee(ssn);