/* Database Systems, Coronel/Morris */
/* Type of SQL : Oracle */

ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';

/* -- */

CREATE TABLE EVALDATA (
ID integer,
INSTRUCTOR varchar2(25),
DEPARTMENT varchar2(12),
MEAN number(6,2),
SEMESTER varchar2(10));
INSERT INTO EVALDATA VALUES('2090','Alton','INFS','2.51','2006F');
INSERT INTO EVALDATA VALUES('2091','Ames','INFS','2.84','2006F');
INSERT INTO EVALDATA VALUES('2092','Dumas','MGMT','3.67','2006F');
INSERT INTO EVALDATA VALUES('2214','Alton','INFS','1.91','2006S');
INSERT INTO EVALDATA VALUES('2215','Ames','INFS','2.76','2006S');
INSERT INTO EVALDATA VALUES('2216','Dumas','MGMT','3.66','2006S');
INSERT INTO EVALDATA VALUES('2218','Rolman','INFS','3.5','2006S');
INSERT INTO EVALDATA VALUES('2331','Alton','INFS','2.3','2007F');
INSERT INTO EVALDATA VALUES('2332','Ames','INFS','2.79','2007F');
INSERT INTO EVALDATA VALUES('2333','Dumas','MGMT','3.8','2007F');
INSERT INTO EVALDATA VALUES('2449','Alton','INFS','2.77','2007S');
INSERT INTO EVALDATA VALUES('2450','Ames','INFS','2.74','2007S');
INSERT INTO EVALDATA VALUES('2452','Dumas','MGMT','3.79','2007S');
INSERT INTO EVALDATA VALUES('2572','Alton','INFS','2.99','2008F');
INSERT INTO EVALDATA VALUES('2573','Ames','INFS','2.6','2008F');
INSERT INTO EVALDATA VALUES('2574','Dumas','MGMT','3.91','2008F');
INSERT INTO EVALDATA VALUES('2575','Lohar','ECON','3.53','2008F');
INSERT INTO EVALDATA VALUES('2698','Alton','INFS','2.7','2008S');
INSERT INTO EVALDATA VALUES('2699','Ames','INFS','2.92','2008S');
INSERT INTO EVALDATA VALUES('2700','Dumas','MGMT','3.9','2008S');
INSERT INTO EVALDATA VALUES('2822','Alton','INFS','3.01','2009F');
INSERT INTO EVALDATA VALUES('2823','Ames','INFS','2.09','2009F');
INSERT INTO EVALDATA VALUES('2824','Dumas','MGMT','3.76','2009F');
INSERT INTO EVALDATA VALUES('2825','Landon','BMOM','3.57','2009F');
INSERT INTO EVALDATA VALUES('2826','Lohar','ECON','3.53','2009F');
INSERT INTO EVALDATA VALUES('2947','Alton','INFS','2.35','2009S');
INSERT INTO EVALDATA VALUES('2948','Ames','INFS','2.98','2009S');
INSERT INTO EVALDATA VALUES('2949','Dumas','MGMT','3.81','2009S');
INSERT INTO EVALDATA VALUES('3070','Alton','INFS','2.76','2010F');
INSERT INTO EVALDATA VALUES('3071','Ames','INFS','3.35','2010F');
INSERT INTO EVALDATA VALUES('3073','Dumas','MGMT','3.7','2010F');
INSERT INTO EVALDATA VALUES('3074','Landon','BMOM','3.22','2010F');
INSERT INTO EVALDATA VALUES('3204','Alton','INFS','2.86','2010S');
INSERT INTO EVALDATA VALUES('3205','Ames','INFS','2.92','2010S');
INSERT INTO EVALDATA VALUES('3207','Dumas','MGMT','3.66','2010S');
INSERT INTO EVALDATA VALUES('3208','Landon','BMOM','3.32','2010S');
INSERT INTO EVALDATA VALUES('3336','Alton','INFS','2.81','2011F');
INSERT INTO EVALDATA VALUES('3337','Ames','INFS','3.24','2011F');
INSERT INTO EVALDATA VALUES('3338','Dumas','MGMT','3.86','2011F');
INSERT INTO EVALDATA VALUES('3339','Landon','BMOM','3.54','2011F');
INSERT INTO EVALDATA VALUES('3472','Alton','INFS','2.72','2011S');
INSERT INTO EVALDATA VALUES('3473','Ames','INFS','2.79','2011S');
INSERT INTO EVALDATA VALUES('3474','Dumas','MGMT','3.83','2011S');
INSERT INTO EVALDATA VALUES('3475','Landon','BMOM','3.47','2011S');
INSERT INTO EVALDATA VALUES('3613','Crandon','INFS','3.79','2012F');
INSERT INTO EVALDATA VALUES('3621','Dumas','MGMT','3.69','2012F');
INSERT INTO EVALDATA VALUES('3656','Landon','BMOM','3.42','2012F');
INSERT INTO EVALDATA VALUES('3668','Ames','INFS','3.28','2012F');
INSERT INTO EVALDATA VALUES('3730','Alton','INFS','2.2','2012F');
INSERT INTO EVALDATA VALUES('3764','Alton','INFS','2.69','2012S');
INSERT INTO EVALDATA VALUES('3765','Ames','INFS','3.24','2012S');
INSERT INTO EVALDATA VALUES('3766','Dumas','MGMT','3.69','2012S');
INSERT INTO EVALDATA VALUES('3767','Landon','BMOM','3.22','2012S');
INSERT INTO EVALDATA VALUES('3928','Landon','BMOM','3.57','2013F');
INSERT INTO EVALDATA VALUES('3975','Alton','INFS','2.51','2013F');
INSERT INTO EVALDATA VALUES('3976','Ames','INFS','3.19','2013F');
INSERT INTO EVALDATA VALUES('3977','Crandon','INFS','3.88','2013F');
INSERT INTO EVALDATA VALUES('4000','Dumas','MGMT','3.56','2013F');
INSERT INTO EVALDATA VALUES('4040','Crandon','INFS','3.79','2013S');
INSERT INTO EVALDATA VALUES('4047','Dumas','MGMT','3.72','2013S');
INSERT INTO EVALDATA VALUES('4095','Landon','BMOM','3.36','2013S');
INSERT INTO EVALDATA VALUES('4155','Ames','INFS','2.59','2013S');
INSERT INTO EVALDATA VALUES('4172','Alton','INFS','2.13','2013S');
INSERT INTO EVALDATA VALUES('4199','Crandon','INFS','3.91','2014S');
INSERT INTO EVALDATA VALUES('4217','Dumas','MGMT','3.69','2014S');
INSERT INTO EVALDATA VALUES('4257','Landon','BMOM','3.39','2014S');
INSERT INTO EVALDATA VALUES('4269','Ames','INFS','3.31','2014S');
INSERT INTO EVALDATA VALUES('4323','Alton','INFS','2.55','2014S');
INSERT INTO EVALDATA VALUES('4346','Crandon','INFS','3.95','2014F');
INSERT INTO EVALDATA VALUES('4365','Dumas','MGMT','3.66','2014F');
INSERT INTO EVALDATA VALUES('4369','Landon','BMOM','3.64','2014F');
INSERT INTO EVALDATA VALUES('4414','Ames','INFS','3.26','2014F');
INSERT INTO EVALDATA VALUES('4450','Alton','INFS','2.84','2014F');
INSERT INTO EVALDATA VALUES('4519','Landon','BMOM','3.57','2015S');
INSERT INTO EVALDATA VALUES('4571','Alton','INFS','2.91','2015S');
INSERT INTO EVALDATA VALUES('4572','Ames','INFS','3.24','2015S');
INSERT INTO EVALDATA VALUES('4573','Crandon','INFS','3.93','2015S');

/* -- */

CREATE TABLE FACHIST (
ID integer,
INSTRUCTOR varchar2(50),
DEPARTMENT varchar2(50),
LAST1SEM varchar2(10),
LAST1MEAN number(6,2),
LAST2SEM varchar2(10),
LAST2MEAN number(6,2),
LAST3SEM varchar2(10),
LAST3MEAN number(6,2),
LAST4SEM varchar2(10),
LAST4MEAN number(6,2));

INSERT INTO FACHIST VALUES('59602','Alton','INFS','2015S','2.91','2014F','2.84','2014S','2.55','2013F','2.51');
INSERT INTO FACHIST VALUES('59603','Ames','INFS','2015S','3.24','2014F','3.26','2014S','3.31','2013F','3.19');
INSERT INTO FACHIST VALUES('59605','Crandon','INFS','2015S','3.93','2014F','3.95','2014S','3.91','2013F','3.88');
INSERT INTO FACHIST VALUES('59607','Dumas','MGMT','2014F','3.66','2014S','3.69','2013F','3.56','2013S','3.72');
INSERT INTO FACHIST VALUES('59608','Landon','BMOM','2015S','3.57','2014F','3.64','2014S','3.39','2013F','3.57');
INSERT INTO FACHIST VALUES('59610','Lohar','ECON','2009F','3.53','2008F','3.53','','','','');
INSERT INTO FACHIST VALUES('59611','Rolman','INFS','2006S','3.5','','','','','','');

/* -- */

