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

/* -- */
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);

/* -- */

