-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 20, 2008 at 08:38 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `midterm`
--

-- --------------------------------------------------------

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `DeptID` char(1) NOT NULL,
  `Dept` char(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`DeptID`, `Dept`) VALUES
('A', '101'),
('B', '102'),
('C', '103'),
('D', '104');

-- --------------------------------------------------------

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `EmpID` char(3) NOT NULL,
  `First` varchar(10) NOT NULL,
  `Last` varchar(10) NOT NULL,
  `DOB` date NOT NULL,
  `CNum` char(4) NOT NULL,
  `DateHire` date NOT NULL,
  `DeptID` char(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`EmpID`, `First`, `Last`, `DOB`, `CNum`, `DateHire`, `DeptID`) VALUES
('201', 'Sam', 'Smith', '1980-01-02', 'C201', '2000-12-05', 'A'),
('202', 'Sue', 'Jones', '1982-02-01', 'C202', '1999-01-05', 'D'),
('203', 'Joe', 'Smith', '1960-03-04', 'C203', '2002-04-08', 'C'),
('204', 'Adam', 'Guidry', '1968-04-03', 'C204', '2006-06-06', 'A'),
('205', 'Mary', 'Smith', '1946-10-10', 'C205', '2002-04-01', 'B'),
('206', 'Sally', 'Rand', '1948-08-08', 'C206', '2001-07-07', 'B'),
('207', 'Joe', 'Adam', '1949-09-09', 'C207', '2002-08-08', 'C'),
('208', 'Bill', 'Brown', '1955-11-12', 'C208', '2003-09-09', 'D'),
('209', 'Sally', 'Jones', '1960-12-12', 'C209', '2004-11-11', 'A'),
('210', 'Dave', 'Landry', '1970-01-09', 'C210', '2005-12-12', 'B'),
('211', 'Fred', 'Martin', '1980-02-02', 'C211', '1999-01-15', 'C'),
('212', 'Greg', 'Norman', '1985-03-03', 'C212', '2006-02-02', 'D');

-- --------------------------------------------------------

--
-- Table structure for table `empproj`
--

CREATE TABLE `empproj` (
  `ProjID` char(4) NOT NULL,
  `EmpID` char(3) NOT NULL,
  `StartDate` date NOT NULL,
  `TotalHours` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `empproj`
--

INSERT INTO `empproj` (`ProjID`, `EmpID`, `StartDate`, `TotalHours`) VALUES
('P101', '202', '2003-06-10', 70),
('P101', '204', '2001-01-01', 140),
('P101', '206', '2001-01-01', 140),
('P102', '201', '2006-01-21', 60),
('P102', '203', '2007-08-01', 80),
('P102', '205', '2006-01-21', 120),
('P102', '212', '2008-10-10', 60),
('P103', '207', '2006-02-18', 50),
('P105', '206', '2007-07-04', 80),
('P105', '203', '2007-07-04', 60),
('P105', '211', '2007-07-04', 150),
('P105', '209', '2007-07-04', 140);

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `ProjID` char(4) NOT NULL,
  `Title` varchar(10) NOT NULL,
  `PStart` date NOT NULL,
  `PEnd` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`ProjID`, `Title`, `PStart`, `PEnd`) VALUES
('P101', 'AP', '2001-01-01', '2009-12-31'),
('P102', 'BP', '2006-01-21', '2010-01-20'),
('P103', 'CP', '2006-02-18', '2009-02-17'),
('P104', 'DP', '2009-05-26', '2010-12-10'),
('P105', 'EP', '2007-07-04', '2010-10-10'),
('P106', 'FP', '2008-12-01', '2009-04-15');