Notes

use employee;
create table employee
( FNAME varchar(15) NOT NULL,
MINIT char(9),
LNAME varchar(15) NOT NULL,
SSN char(9) NOT NULL,
BDATE date,
ADDRESS varchar(30),
SEX char(9),
SALARY decimal(10,2),
SUPERSSN char(9),
DNO int(4) NOT NULL,
primary key(SSN),
foreign key(SUPERSSN) references employee(SSN));

/*foreign key(DNO) references department(DNUMBER));*/
create table department
( DNAME varchar(15) NOT NULL,
DNUMBER int NOT NULL,
MGRSSN char(9) NOT NULL,
MGRSTARTDATE date,
primary key(DNUMBER),
unique(DNAME),
foreign key(MGRSSN) references employee(SSN));
create table dept_locations
( DNUMBER int NOT NULL,
DLOCATIONS varchar(15) NOT NULL,
primary key(DNUMBER,DLOCATIONS),
foreign key(DNUMBER) references department(DNUMBER));
create table project
( PNAME varchar(15) NOT NULL,
PNUMBER int NOT NULL,
PLOCATIONS varchar(15),
DNUM int NOT NULL,
primary key(PNUMBER),
unique(PNAME),
foreign key(DNUM) references department(DNUMBER));
create table Works_on
(ESSN char(9) NOT NULL,
PNO int NOT NULL,
HOURS decimal(3,1) NOT NULL,
primary key(ESSN,PNO),
foreign key(ESSN) references employee(SSN),
foreign key(PNO) references project(PNUMBER));
create table dependent
(ESSN char(9) NOT NULL,
DEPENDENT_NAME varchar(15) NOT NULL,
SEX char(10),
BDATE date,
RELATIONSHIP varchar(8),
primary key(ESSN,DEPENDENT_NAME),
foreign key(ESSN) references employee(SSN));