     ON DELETE NO ACTION
     ON UPDATE NO ACTION);
 
+CREATE TABLE `reservation_system`.`administrators` (
+  `administratorid` INT NOT NULL,
+  `last_name` VARCHAR(45) NOT NULL,
+  `first_name` VARCHAR(45) NOT NULL,
+  `middle_name` VARCHAR(45) NOT NULL,
+  `admin_departmentid` INT NOT NULL,
+  PRIMARY KEY (`administratorid`),
+  INDEX `admin_departmentid_idx` (`admin_departmentid` ASC),
+	CONSTRAINT `admin_departmentid`
+	FOREIGN KEY (`admin_departmentid`)
+	REFERENCES `reservation_system`.`departments` (`departmentid`)
+	ON DELETE NO ACTION
+	ON UPDATE NO ACTION);
 
+CREATE TABLE `reservation_system`.`moderators` (
+  `moderatorid` INT NOT NULL,
+  `last_name` VARCHAR(45) NOT NULL,
+  `first_name` VARCHAR(45) NOT NULL,
+  `middle_name` VARCHAR(45) NOT NULL,
+  `mod_departmentid` INT NOT NULL,
+  PRIMARY KEY (`moderatorid`),
+  INDEX `mod_departmentid_idx` (`mod_departmentid` ASC),
+	CONSTRAINT `mod_departmentid`
+	FOREIGN KEY (`mod_departmentid`)
+	REFERENCES `reservation_system`.`departments` (`departmentid`)
+	ON DELETE NO ACTION
+	ON UPDATE NO ACTION);
 
 /*dummy data*/
 INSERT INTO `reservation_system`.`buildings` (`name`)

  `name` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`buildingid`));

CREATE TABLE `reservation_system`.`rooms` (
  `roomid` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL,
  `buildingid` INT NOT NULL,
  `department` VARCHAR(30) NOT NULL DEFAULT 'ITS',
  PRIMARY KEY (`roomid`),
  INDEX `buildingid_idx` (`buildingid` ASC),
  CONSTRAINT `buildingid`
    FOREIGN KEY (`buildingid`)
    REFERENCES `reservation_system`.`buildings` (`buildingid`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);


       (1, 11425520, "kevin_gray_chan@dlsu.edu.ph", "2016-10-20", "11:00:00", "11:14:59", 2, 2, "45t45y0965134213yktreioet54j211"),
	   (1, 11425520, "kevin_gray_chan@dlsu.edu.ph", "2016-10-20", "11:15:00", "11:29:59", 2, 2, "45t45y0965134213yktreioet54j211"),
       (1, 11425520, "kevin_gray_chan@dlsu.edu.ph", "2016-10-21", "11:00:00", "11:14:59", 2, 2, "45t45y0965134213yktreioet54j212"),
	   (1, 11425520, "kevin_gray_chan@dlsu.edu.ph", "2016-10-21", "11:15:00", "11:29:59", 2, 2, "45t45y0965134213yktreioet54j212");
