# CocoaMySQL dump
# Version 0.7b5
# http://cocoamysql.sourceforge.net
#
# Host: localhost (MySQL 5.0.27-standard)
# Database: Company_Database
# Generation Time: 2007-05-02 00:48:17 +0200
# ************************************************************

# Dump of table DEPARTMENT
# ------------------------------------------------------------

CREATE TABLE `DEPARTMENT` (
  `DNAME` varchar(15) NOT NULL,
  `DNUMBER` int(11) NOT NULL,
  `MGRSSN` char(9) NOT NULL,
  `MGRSTARTDATE` date default NULL,
  PRIMARY KEY  (`DNUMBER`),
  UNIQUE KEY `DNAME` (`DNAME`),
  KEY `MGRSSN` (`MGRSSN`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `DEPARTMENT` (`DNAME`,`DNUMBER`,`MGRSSN`,`MGRSTARTDATE`) VALUES ('Research','5','333445555','1988-05-22');
INSERT INTO `DEPARTMENT` (`DNAME`,`DNUMBER`,`MGRSSN`,`MGRSTARTDATE`) VALUES ('Administration','4','987654321','1995-01-01');
INSERT INTO `DEPARTMENT` (`DNAME`,`DNUMBER`,`MGRSSN`,`MGRSTARTDATE`) VALUES ('Headquarters','1','888665555','1981-06-19');


# Dump of table DEPENDENT
# ------------------------------------------------------------

CREATE TABLE `DEPENDENT` (
  `ESSN` char(9) NOT NULL,
  `DEPENDENT_NAME` varchar(15) NOT NULL,
  `SEX` char(1) default NULL,
  `BDATE` date default NULL,
  `RELATIONSHIP` varchar(8) default NULL,
  PRIMARY KEY  (`ESSN`,`DEPENDENT_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `DEPENDENT` (`ESSN`,`DEPENDENT_NAME`,`SEX`,`BDATE`,`RELATIONSHIP`) VALUES ('333445555','Alice','F','1986-04-05','DAUGHTER');
INSERT INTO `DEPENDENT` (`ESSN`,`DEPENDENT_NAME`,`SEX`,`BDATE`,`RELATIONSHIP`) VALUES ('333445555','Theodore','M','1983-10-25','SON');
INSERT INTO `DEPENDENT` (`ESSN`,`DEPENDENT_NAME`,`SEX`,`BDATE`,`RELATIONSHIP`) VALUES ('333445555','Joy','F','1958-05-03','SPOUSE');
INSERT INTO `DEPENDENT` (`ESSN`,`DEPENDENT_NAME`,`SEX`,`BDATE`,`RELATIONSHIP`) VALUES ('987654321','Abner','M','1942-02-28','SPOUSE');
INSERT INTO `DEPENDENT` (`ESSN`,`DEPENDENT_NAME`,`SEX`,`BDATE`,`RELATIONSHIP`) VALUES ('123456789','Michael','M','1988-01-04','SON');
INSERT INTO `DEPENDENT` (`ESSN`,`DEPENDENT_NAME`,`SEX`,`BDATE`,`RELATIONSHIP`) VALUES ('123456789','Alice','F','1988-12-30','DAUGHTER');
INSERT INTO `DEPENDENT` (`ESSN`,`DEPENDENT_NAME`,`SEX`,`BDATE`,`RELATIONSHIP`) VALUES ('123456789','Elizabeth','F','1967-05-05','SPOUSE');


# Dump of table DEPT_LOCATIONS
# ------------------------------------------------------------

CREATE TABLE `DEPT_LOCATIONS` (
  `DNUMBER` int(11) NOT NULL,
  `DLOCATION` varchar(15) NOT NULL,
  PRIMARY KEY  (`DNUMBER`,`DLOCATION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `DEPT_LOCATIONS` (`DNUMBER`,`DLOCATION`) VALUES ('1','Houston');
INSERT INTO `DEPT_LOCATIONS` (`DNUMBER`,`DLOCATION`) VALUES ('4','Stafford');
INSERT INTO `DEPT_LOCATIONS` (`DNUMBER`,`DLOCATION`) VALUES ('5','Bellaire');
INSERT INTO `DEPT_LOCATIONS` (`DNUMBER`,`DLOCATION`) VALUES ('5','Houston');
INSERT INTO `DEPT_LOCATIONS` (`DNUMBER`,`DLOCATION`) VALUES ('5','Sugarland');


# Dump of table EMPLOYEE
# ------------------------------------------------------------

CREATE TABLE `EMPLOYEE` (
  `FNAME` varchar(15) NOT NULL,
  `MINIT` char(1) default NULL,
  `LNAME` varchar(15) NOT NULL,
  `SSN` char(9) NOT NULL,
  `BDATE` date default NULL,
  `ADDRESS` varchar(30) default NULL,
  `SEX` char(1) default NULL,
  `SALARY` decimal(10,2) default NULL,
  `SUPERSSN` char(9) default NULL,
  `DNO` int(11) NOT NULL,
  PRIMARY KEY  (`SSN`),
  KEY `SUPERSSN` (`SUPERSSN`),
  KEY `DNO` (`DNO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `EMPLOYEE` (`FNAME`,`MINIT`,`LNAME`,`SSN`,`BDATE`,`ADDRESS`,`SEX`,`SALARY`,`SUPERSSN`,`DNO`) VALUES ('John','B','Smith','123456789','1965-01-09','731 Fondren, Houston, TX','M','30000','333445555','5');
INSERT INTO `EMPLOYEE` (`FNAME`,`MINIT`,`LNAME`,`SSN`,`BDATE`,`ADDRESS`,`SEX`,`SALARY`,`SUPERSSN`,`DNO`) VALUES ('Franklin','T','Wong','333445555','1955-12-08','638 Voss, Houston, TX','M','40000','888665555','5');
INSERT INTO `EMPLOYEE` (`FNAME`,`MINIT`,`LNAME`,`SSN`,`BDATE`,`ADDRESS`,`SEX`,`SALARY`,`SUPERSSN`,`DNO`) VALUES ('Alicia','J','Zelaya','999887777','1968-07-19','3321 Castle, Spring, TX','F','25000','987654321','4');
INSERT INTO `EMPLOYEE` (`FNAME`,`MINIT`,`LNAME`,`SSN`,`BDATE`,`ADDRESS`,`SEX`,`SALARY`,`SUPERSSN`,`DNO`) VALUES ('Jennifer','S','Wallace','987654321','1941-06-20','291 Berry, Bellaire, TX','F','43000','888665555','4');
INSERT INTO `EMPLOYEE` (`FNAME`,`MINIT`,`LNAME`,`SSN`,`BDATE`,`ADDRESS`,`SEX`,`SALARY`,`SUPERSSN`,`DNO`) VALUES ('Ramesh','K','Narayan','666884444','1962-09-15','975 Fire Oak, Humble, TX','M','38000','333445555','5');
INSERT INTO `EMPLOYEE` (`FNAME`,`MINIT`,`LNAME`,`SSN`,`BDATE`,`ADDRESS`,`SEX`,`SALARY`,`SUPERSSN`,`DNO`) VALUES ('Joyce','A','English','453453453','1972-07-31','5631 Rice, Houston, TX','F','25000','333445555','4');
INSERT INTO `EMPLOYEE` (`FNAME`,`MINIT`,`LNAME`,`SSN`,`BDATE`,`ADDRESS`,`SEX`,`SALARY`,`SUPERSSN`,`DNO`) VALUES ('Ahmad','V','Jabbar','987987987','1969-03-29','980 Dallas, Houston, TX','M','25000','987654321','4');
INSERT INTO `EMPLOYEE` (`FNAME`,`MINIT`,`LNAME`,`SSN`,`BDATE`,`ADDRESS`,`SEX`,`SALARY`,`SUPERSSN`,`DNO`) VALUES ('James','E','Borg','888665555','1937-11-10','450 Stone, Houston, TX','M','55000',NULL,'1');


# Dump of table PROJECT
# ------------------------------------------------------------

CREATE TABLE `PROJECT` (
  `PNAME` varchar(15) NOT NULL,
  `PNUMBER` int(11) NOT NULL,
  `PLOCATION` varchar(15) default NULL,
  `DNUM` int(11) NOT NULL,
  PRIMARY KEY  (`PNUMBER`),
  UNIQUE KEY `PNAME` (`PNAME`),
  KEY `DNUM` (`DNUM`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `PROJECT` (`PNAME`,`PNUMBER`,`PLOCATION`,`DNUM`) VALUES ('ProductX','1','Bellaire','5');
INSERT INTO `PROJECT` (`PNAME`,`PNUMBER`,`PLOCATION`,`DNUM`) VALUES ('ProductY','2','Sugarland','5');
INSERT INTO `PROJECT` (`PNAME`,`PNUMBER`,`PLOCATION`,`DNUM`) VALUES ('ProductZ','3','Houston','5');
INSERT INTO `PROJECT` (`PNAME`,`PNUMBER`,`PLOCATION`,`DNUM`) VALUES ('Computerization','10','Stafford','4');
INSERT INTO `PROJECT` (`PNAME`,`PNUMBER`,`PLOCATION`,`DNUM`) VALUES ('Reorganization','20','Houston','1');
INSERT INTO `PROJECT` (`PNAME`,`PNUMBER`,`PLOCATION`,`DNUM`) VALUES ('Newbenefits','30','Stafford','4');


# Dump of table WORKS_ON
# ------------------------------------------------------------

CREATE TABLE `WORKS_ON` (
  `ESSN` char(9) NOT NULL,
  `PNO` int(11) NOT NULL,
  `HOURS` decimal(3,1) NOT NULL,
  PRIMARY KEY  (`ESSN`,`PNO`),
  KEY `PNO` (`PNO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('123456789','1','32.5');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('123456789','2','7.5');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('666884444','3','40.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('453453453','1','20.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('453453453','2','20.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('333445555','2','10.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('333444555','3','10.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('333444555','10','10.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('333444555','20','10.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('999887777','30','30.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('999887777','10','10.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('987987987','10','35.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('987987987','30','5.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('987654321','30','20.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('987654321','20','15.0');
INSERT INTO `WORKS_ON` (`ESSN`,`PNO`,`HOURS`) VALUES ('888665555','20','0.0');