#
# mSQL Dump  (requires mSQL-1.0.6 or better)
#
# Host: localhost    Database: company
#--------------------------------------------------------


#
# Table structure for table 'project'
#
CREATE TABLE project (
  pname CHAR(15),
  pnumber CHAR(5) NOT NULL PRIMARY KEY,
  plocation CHAR(10),
  dnum CHAR(1)
) \g


#
# Dumping data for table 'project'
#

INSERT INTO project VALUES ('ProductX','1','Bellaire','5')\g
INSERT INTO project VALUES ('ProductY','2','Sugarland','5')\g
INSERT INTO project VALUES ('ProductZ','3','Houston','5')\g
INSERT INTO project VALUES ('Computerization','10','Stafford','4')\g
INSERT INTO project VALUES ('Reorganization','20','Houston','1')\g
INSERT INTO project VALUES ('Newbenefits','30','Stafford','4')\g

#
# Table structure for table 'employee'
#
CREATE TABLE employee (
  fname CHAR(10),
  minit CHAR(1),
  lname CHAR(10),
  ssn CHAR(9) NOT NULL PRIMARY KEY,
  bdate CHAR(9),
  address CHAR(15),
  sex CHAR(1),
  salary INT,
  superssn CHAR(9),
  dno CHAR(1)
) \g


#
# Dumping data for table 'employee'
#

INSERT INTO employee VALUES ('John','B','Smith','123456789','09-Jan-55','Houston,TX','M',30000,'333445555','5')\g
INSERT INTO employee VALUES ('Frank','T','Wong','333445555','08-DEC-45','Houston,TX','M',40000,'888665555','5')\g
INSERT INTO employee VALUES ('Alicia','J','Zelaya','999887777','19-JUL-58','Spring,TX','F',25000,'987654321','4')\g
INSERT INTO employee VALUES ('Jennifer','S','Wallace','987654321','20-JUN-31','Bellaire,TX','F',43000,'888665555','4')\g
INSERT INTO employee VALUES ('Ramesh','K','Narayan','666884444','15-SEP-52','Humble,TX','M',38000,'333445555','5')\g
INSERT INTO employee VALUES ('Joyce','A','English','453453453','31-JUL-62','Houston, TX','F',25000,'333445555','5')\g
INSERT INTO employee VALUES ('Ahmad','V','Jabbar','987987987','29-MAR-59','Houston,TX','M',25000,'987654321','4')\g
INSERT INTO employee VALUES ('James','E','Borg','888665555','10-NOV-27','Houston,TX','M',55000,NULL,'1')\g

#
# Table structure for table 'department'
#
CREATE TABLE department (
  dname CHAR(15),
  dnumber CHAR(1) NOT NULL PRIMARY KEY,
  mgrssn CHAR(9),
  mgrstartdate CHAR(9)
) \g


#
# Dumping data for table 'department'
#

INSERT INTO department VALUES ('Reserch','5','333445555','22-MAY-78')\g
INSERT INTO department VALUES ('Administration','4','987654321','01-JAN-85')\g
INSERT INTO department VALUES ('Headquarters','1','888665555','19-JUN-71')\g

#
# Table structure for table 'dependent'
#
CREATE TABLE dependent (
  essn CHAR(9) NOT NULL,
  dependent_name CHAR(12) NOT NULL,
  sex CHAR(1),
  bdate CHAR(9),
  relationship CHAR(10)
) \g


#
# Dumping data for table 'dependent'
#

INSERT INTO dependent VALUES ('333445555','Alice','F','05-APR-76','Daughter')\g
INSERT INTO dependent VALUES ('333445555','Theodore','M','25-OCT-73','Son')\g
INSERT INTO dependent VALUES ('333445555','Joy','F','03-MAY-48','Spouse')\g
INSERT INTO dependent VALUES ('987654321','Abner','M','29-FEB-32','Spouse')\g
INSERT INTO dependent VALUES ('123456789','Michael','M','01-JAN-78','Son')\g
INSERT INTO dependent VALUES ('123456789','Alice','F','31-DEC-78','Daughter')\g
INSERT INTO dependent VALUES ('123456789','Elizabeth','F','05-MAY-57','Spouse')\g

#
# Table structure for table 'works_on'
#
CREATE TABLE works_on (
  essn CHAR(9) NOT NULL,
  pno CHAR(5) NOT NULL,
  hours REAL
) \g


#
# Dumping data for table 'works_on'
#

INSERT INTO works_on VALUES ('123456789','1',32.5)\g
INSERT INTO works_on VALUES ('123456789','2',7.5)\g
INSERT INTO works_on VALUES ('666884444','3',40)\g
INSERT INTO works_on VALUES ('453453453','1',20)\g
INSERT INTO works_on VALUES ('453453453','2',20)\g
INSERT INTO works_on VALUES ('333445555','2',10)\g
INSERT INTO works_on VALUES ('333445555','3',10)\g
INSERT INTO works_on VALUES ('333445555','10',10)\g
INSERT INTO works_on VALUES ('999887777','30',30)\g
INSERT INTO works_on VALUES ('999887777','10',10)\g
INSERT INTO works_on VALUES ('987987987','10',35)\g
INSERT INTO works_on VALUES ('987987987','30',5)\g
INSERT INTO works_on VALUES ('987654321','30',20)\g
INSERT INTO works_on VALUES ('987654321','20',15)\g
INSERT INTO works_on VALUES ('888665555','20',NULL)\g

#
# Table structure for table 'dept_locations'
#
CREATE TABLE dept_locations (
  dnumber CHAR(1) NOT NULL,
  dlocation CHAR(10) NOT NULL
) \g


#
# Dumping data for table 'dept_locations'
#

INSERT INTO dept_locations VALUES ('1','Houston')\g
INSERT INTO dept_locations VALUES ('4','Stafford')\g
INSERT INTO dept_locations VALUES ('5','Bellaire')\g
INSERT INTO dept_locations VALUES ('5','Sugarland')\g
INSERT INTO dept_locations VALUES ('5','Houston')\g