w7WDDhfZ

1DROP DATABASE IF EXISTS jettime;
2CREATE DATABASE jettime;
3USE jettime;
4
5CREATE TABLE `employee` (
6  `employee_id` int(11) NOT NULL AUTO_INCREMENT,
7  `title` varchar(45) NOT NULL,
8  `first_name` varchar(45) NOT NULL,
9  `last_name` varchar(45) NOT NULL,
10  `certifications` varchar(45) DEFAULT NULL,
11  PRIMARY KEY (`employee_id`)
12) 
13
14CREATE TABLE `employee_schedule` (
15  `employee_schedule_id` int(11) NOT NULL AUTO_INCREMENT,
16  `day` varchar(255) NOT NULL,
17  `time` varchar(255) NOT NULL,
18  `subject` varchar(255) NOT NULL,
19  `instructor_name` varchar(255) NOT NULL,
20  `homework` varchar(255) DEFAULT NULL,
21  `test_passed` varchar(255) DEFAULT NULL,
22  PRIMARY KEY (`employee_schedule_id`)
23) 
24
25CREATE TABLE `instructor` (
26  `instructor_id` int(11) NOT NULL AUTO_INCREMENT,
27  `title` varchar(45) NOT NULL,
28  `first_name` varchar(45) NOT NULL,
29  `last_name` varchar(45) NOT NULL,
30  `certifications` varchar(45) DEFAULT NULL,
31  PRIMARY KEY (`instructor_id`)
32) 
33
34CREATE TABLE `instructor_schedule` (
35  `instructor_schedule_id` int(11) NOT NULL,
36  `instructor_id` int(11) NOT NULL,
37  `monday` varchar(255) NOT NULL,
38  `tuesday` varchar(255) NOT NULL,
39  `wednesday` varchar(255) NOT NULL,
40  `thursday` varchar(255) NOT NULL,
41  `friday` varchar(255) NOT NULL,
42  `saturday` varchar(255) NOT NULL,
43  `sunday` varchar(255) NOT NULL,
44  PRIMARY KEY (`instructor_schedule_id`)
45) 
46
47CREATE TABLE `participants` (
48  `participants_id` int(11) NOT NULL,
49  `first_name` varchar(45) NOT NULL,
50  `last_name` varchar(45) NOT NULL,
51  `certifications` varchar(45) DEFAULT NULL,
52  PRIMARY KEY (`participants_id`)
53)