-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 30, 2008 at 11:57 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `exercise504`
--

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

--
-- Table structure for table `dept`
--

CREATE TABLE IF NOT EXISTS `dept` (
  `did` int(10) NOT NULL,
  `budget` decimal(10,2) NOT NULL,
  `managerid` int(10) NOT NULL,
  `dname` char(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dept`
--

INSERT INTO `dept` (`did`, `budget`, `managerid`, `dname`) VALUES
(1, 0.00, 1048572, '141582651'),
(2, 0.00, 12099101, '287321212'),
(3, 0.00, 222988, '248965255'),
(4, 0.00, 538100, '548977562'),
(5, 0.00, 400011, '141582651'),
(6, 0.00, 12099101, '578875478'),
(7, 0.00, 5, '489456522');

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

--
-- Table structure for table `emp`
--

CREATE TABLE IF NOT EXISTS `emp` (
  `eid` int(10) NOT NULL,
  `ename` char(30) NOT NULL,
  `age` int(5) NOT NULL,
  `salary` decimal(7,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `emp`
--

INSERT INTO `emp` (`eid`, `ename`, `age`, `salary`) VALUES
(142519864, 'Susan Martin', 39, 56990.00),
(242518965, 'James Smith', 68, 27099.00),
(141582651, 'Mary Johnson', 44, 94011.00),
(11564812, 'John Williams', 35, 74098.00),
(254099823, 'Patricia Jones', 28, 42783.00),
(356187925, 'Robert Brown', 28, 35431.00),
(489456522, 'Linda Davis', 26, 25971.00),
(287321212, 'Michael Miller', 62, 99999.99),
(248965255, 'Barbara Wilson', 48, 95021.00),
(159542516, 'Matt Nelson', 33, 48990.00),
(90873519, 'Elizabeth Taylor', 27, 33055.00),
(486512566, 'David Anderson', 20, 25199.00),
(619023588, 'Jennifer Thomas', 24, 34654.00),
(112348546, 'Joseph Thompson', 26, 24998.00),
(115987938, 'Christopher Garcia', 60, 24998.00),
(132977562, 'Angela Martinez', 31, 24998.00),
(269734834, 'Rick Carter', 38, 24998.00),
(280158572, 'Margaret Clark', 40, 24998.00),
(301221823, 'Juan Rodriguez', 30, 32175.00),
(318548912, 'Ann Mitchell', 23, 32175.00),
(320874981, 'Daniel Lee', 23, 32175.00),
(322654189, 'Lisa Walker', 38, 32175.00),
(348121549, 'Trey Phillips', 69, 32175.00),
(351565322, 'Nancy Allen', 30, 39910.00),
(451519864, 'Mark Young', 34, 39910.00),
(455798411, 'Luis Hernandez', 44, 39910.00),
(550156548, 'George Wright', 42, 41008.00),
(552455318, 'Ana Lopez', 35, 41008.00),
(556784565, 'Kenneth Hill', 81, 41008.00),
(567354612, 'Karen Scott', 70, 39910.00),
(573284895, 'Steven Green', 29, 39910.00),
(574489456, 'Betty Adams', 39, 39910.00),
(15645489, 'Daniel Evans', 25, 40312.00),
(15487874, 'Gene Edwards', 51, 41008.00),
(54879887, 'Dorthy Lewis', 33, 41008.00),
(98784544, 'Eric Collins', 23, 41008.00),
(74454898, 'Scott Bell', 23, 70100.00),
(156489494, 'Gil Richardson', 32, 70100.00),
(179887498, 'Dorthy Howard', 28, 40312.00),
(156465461, 'Eric Cooper', 26, 24998.00),
(128778823, 'William Ward', 33, 24998.00),
(178949844, 'Chad Stewart', 29, 24998.00),
(298489484, 'Lisa Gray', 31, 24998.00),
(274878974, 'Harry Watson', 30, 24998.00),
(267894232, 'Paul Hall', 25, 24998.00),
(254898318, 'Gim Rogers', 25, 32175.00),
(489221823, 'Richard Jackson', 33, 32996.00),
(548977562, 'Donald King', 43, 92048.00),
(289562686, 'Thomas Robinson', 34, 32175.00),
(291795563, 'Haywood Kelly', 36, 32175.00),
(578875478, 'Edward Baker', 50, 99999.99),
(51135593, 'Maria White', 22, 24998.00),
(60839453, 'Charles Harris', 24, 24998.00),
(334568786, 'William Moore', 32, 32175.00),
(355548984, 'Tom Murphy', 41, 32175.00),
(310454876, 'Milo Brooks', 22, 39910.00),
(390487451, 'Mark Coleman', 42, 39910.00),
(454565232, 'Louis Jenkins', 20, 39910.00),
(141582657, 'Stanley Browne', 23, 14093.00);

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

--
-- Table structure for table `works`
--

CREATE TABLE IF NOT EXISTS `works` (
  `eid` int(10) NOT NULL,
  `did` int(10) NOT NULL,
  `pct_time` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `works`
--

INSERT INTO `works` (`eid`, `did`, `pct_time`) VALUES
(142519864, 2, 100),
(242518965, 1, 100),
(141582651, 1, 50),
(141582651, 5, 50),
(141582657, 1, 25),
(141582657, 5, 75),
(11564812, 3, 100),
(254099823, 3, 100),
(356187925, 2, 100),
(489456522, 7, 100),
(287321212, 2, 100),
(248965255, 3, 100),
(159542516, 4, 100),
(90873519, 2, 100),
(486512566, 4, 100),
(619023588, 1, 100),
(489221823, 2, 100),
(548977562, 4, 100),
(578875478, 6, 100),
(51135593, 2, 100),
(60839453, 2, 100),
(112348546, 2, 100),
(115987938, 2, 100),
(132977562, 2, 100),
(269734834, 2, 100),
(280158572, 2, 100),
(301221823, 2, 100),
(318548912, 2, 100),
(320874981, 2, 100),
(322654189, 2, 100),
(348121549, 2, 100),
(351565322, 2, 100),
(451519864, 2, 100),
(455798411, 2, 100),
(550156548, 2, 50),
(552455318, 2, 25),
(556784565, 2, 25),
(567354612, 2, 75),
(573284895, 2, 50),
(574489456, 2, 50),
(15645489, 6, 100),
(15487874, 6, 100),
(54879887, 6, 100),
(98784544, 6, 100),
(74454898, 6, 100),
(156489494, 6, 100),
(179887498, 6, 100),
(156465461, 6, 100),
(128778823, 6, 100),
(178949844, 6, 100),
(298489484, 6, 100),
(274878974, 6, 100),
(267894232, 6, 100),
(254898318, 6, 100),
(289562686, 6, 100),
(291795563, 6, 100),
(334568786, 6, 100),
(355548984, 6, 100),
(310454876, 6, 100),
(390487451, 6, 100),
(454565232, 6, 50);