-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 30, 2008 at 10:51 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: `exercise5_1`
--

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

--
-- Table structure for table `class`
--

CREATE TABLE IF NOT EXISTS `class` (
  `name` char(30) default NULL,
  `meets_at` time default NULL,
  `room` char(20) default NULL,
  `fid` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `class`
--

INSERT INTO `class` (`name`, `meets_at`, `room`, `fid`) VALUES
('Data Structures', '00:00:00', 'R128', 489456522),
('Database Systems', '00:00:00', '1320 DCL', 142519864),
('Operating System Design', '00:00:00', '20 AVW', 489456522),
('Archaeology of the Incas', '00:00:00', 'R128', 248965255),
('Aviation Accident Investigatio', '00:00:00', 'Q3', 11564812),
('Air Quality Engineering', '00:00:00', 'R15', 11564812),
('Introductory Latin', '00:00:00', 'R12', 248965255),
('American Political Parties', '00:00:00', '20 AVW', 619023588),
('Social Cognition', '00:00:00', 'R15', 159542516),
('Perception', '00:00:00', 'Q3', 489221823),
('Multivariate Analysis', '00:00:00', 'R15', 90873519),
('Patent Law', '00:00:00', 'R128', 90873519),
('Urban Economics', '00:00:00', '20 AVW', 489221823),
('Organic Chemistry', '00:00:00', 'R12', 489221823),
('Marketing Research', '00:00:00', '1320 DCL', 489221823),
('Seminar in American Art', '00:00:00', 'R15', 489221823),
('Orbital Mechanics', '00:00:00', '1320 DCL', 11564812),
('Dairy Herd Management', '00:00:00', 'R128', 356187925),
('Communication Networks', '00:00:00', '20 AVW', 141582651),
('Optical Electronics', '00:00:00', 'R15', 254099823),
('Intoduction to Math', '00:00:00', 'R128', 489221823);

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

--
-- Table structure for table `enrolled`
--

CREATE TABLE IF NOT EXISTS `enrolled` (
  `snum` int(11) default NULL,
  `cname` char(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `enrolled`
--

INSERT INTO `enrolled` (`snum`, `cname`) VALUES
(112348546, 'Database Systems'),
(115987938, 'Database Systems'),
(348121549, 'Database Systems'),
(322654189, 'Database Systems'),
(552455318, 'Database Systems'),
(455798411, 'Operating System Des'),
(552455318, 'Operating System Des'),
(567354612, 'Operating System Des'),
(112348546, 'Operating System Des'),
(115987938, 'Operating System Des'),
(322654189, 'Operating System Des'),
(567354612, 'Data Structures'),
(552455318, 'Communication Networ'),
(455798411, 'Optical Electronics'),
(301221823, 'Perception'),
(301221823, 'Social Cognition'),
(301221823, 'American Political P'),
(556784565, 'Air Quality Engineer'),
(99354543, 'Patent Law'),
(574489456, 'Urban Economics');

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

--
-- Table structure for table `faculty`
--

CREATE TABLE IF NOT EXISTS `faculty` (
  `fid` int(11) default NULL,
  `fname` char(20) default NULL,
  `deptid` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faculty`
--

INSERT INTO `faculty` (`fid`, `fname`, `deptid`) VALUES
(142519864, 'Ivana Teach', 20),
(242518965, 'James Smith', 68),
(141582651, 'Mary Johnson', 20),
(11564812, 'John Williams', 68),
(254099823, 'Patricia Jones', 68),
(356187925, 'Robert Brown', 12),
(489456522, 'Linda Davis', 20),
(287321212, 'Michael Miller', 12),
(248965255, 'Barbara Wilson', 12),
(159542516, 'William Moore', 33),
(90873519, 'Elizabeth Taylor', 11),
(486512566, 'David Anderson', 20),
(619023588, 'Jennifer Thomas', 11),
(489221823, 'Richard Jackson', 33),
(548977562, 'Ulysses Teach', 20);

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

--
-- Table structure for table `student`
--

CREATE TABLE IF NOT EXISTS `student` (
  `snum` int(5) default NULL,
  `sname` char(20) default NULL,
  `major` char(20) default NULL,
  `level` char(10) default NULL,
  `age` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`snum`, `sname`, `major`, `level`, `age`) VALUES
(51135593, 'Maria White', 'English', 'SR', 21),
(60839453, 'Charles Harris', 'Architecture', 'SR', 22),
(99354543, 'Susan Martin', 'Law', 'JR', 20),
(112348546, 'Joseph Thompson', 'Computer Science', 'SO', 19),
(115987938, 'Christopher Garcia', 'Computer Science', 'JR', 20),
(132977562, 'Angela Martinez', 'History', 'SR', 20),
(269734834, 'Thomas Robinson', 'Psychology', 'SO', 18),
(280158572, 'Margaret Clark', 'Animal Science', 'FR', 18),
(301221823, 'Juan Rodriguez', 'Psychology', 'JR', 20),
(318548912, 'Dorthy Lewis', 'Finance', 'FR', 18),
(320874981, 'Daniel Lee', 'Electrical Engineeri', 'FR', 17),
(322654189, 'Lisa Walker', 'Computer Science', 'SO', 17),
(348121549, 'Paul Hall', 'Computer Science', 'JR', 18),
(351565322, 'Nancy Allen', 'Accounting', 'JR', 19),
(451519864, 'Mark Young', 'Finance', 'FR', 18),
(455798411, 'Luis Hernandez', 'Electrical Engineeri', 'FR', 17),
(462156489, 'Donald King', 'Mechanical Engineeri', 'SO', 19),
(550156548, 'George Wright', 'Education', 'SR', 21),
(552455318, 'Ana Lopez', 'Computer Engineering', 'SR', 19),
(556784565, 'Kenneth Hill', 'Civil Engineering', 'SR', 21),
(567354612, 'Karen Scott', 'Computer Engineering', 'FR', 18),
(573284895, 'Steven Green', 'Kinesiology', 'SO', 19),
(574489456, 'Betty Adams', 'Economics', 'JR', 20),
(578875478, 'Edward Baker', 'Veterinary Medicine', 'SR', 21);