### This is the schema for  one of the example databases used in "Fundamentals
### of Database Systems", Elmasri and Navathe, Benjamin Cummings.
### Tim Finin, finin@Umbc.edu

DROP TABLE project \g
CREATE TABLE project 
     (pname char(15),
      pnumber char(5) primary key,
      plocation char(10),
      dnum char(1)) \g

DROP TABLE dept_locations \g
CREATE TABLE dept_locations 
     (dnumber char(1) not null,
      dlocation char(10) not null ) \g

DROP TABLE employee \g
CREATE TABLE employee 
     (fname char(10), 
      minit char(1),
      lname char(10),
      ssn char(9) primary key,
      bdate char(9), 
      address char(15),
      sex char(1),
      salary integer,
      superssn char(9),
      dno char(1))\g

DROP TABLE department \g
CREATE TABLE department 
     (dname char(15),
      dnumber char(1) primary key,
      mgrssn char(9), 
      mgrstartdate char(9)) \g

DROP TABLE dependent \g
CREATE TABLE dependent 
     (essn char (9) not null,
      dependent_name char(12) not null ,
      sex char(1),
      bdate char(9),
      relationship char(10)) \g


# note that the key is (essn,pno) but mSQL doesn't alow us to specify
# multi-field keys.
DROP TABLE works_on \g
CREATE TABLE works_on 
     (essn char(9) not null,
      pno char(5) not null,
      hours real) \g