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


/* -- */
CREATE TABLE EVALDATA (
ID int,
INSTRUCTOR varchar (25),
DEPARTMENT varchar (12),
MEAN float,
SEMESTER varchar (10)
);

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

/* -- */

CREATE TABLE FACHIST (
ID int,
INSTRUCTOR varchar (50),
DEPARTMENT varchar (50),
LAST1SEM varchar (50),
LAST1MEAN float,
LAST2SEM varchar (50),
LAST2MEAN float,
LAST3SEM varchar (50),
LAST3MEAN float,
LAST4SEM varchar (50),
LAST4MEAN float
);

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

/* -- */

