Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your comments (see the practice solution for an example of the format). There will be a 5% deduction for scripts that cannot be pasted into MySQL and run without edits. 1. List employees (use employeelD) and their years of service. Sort the results by years of service in descending order. 2. Provide a distinct list of faculty (use faculty ID) who teach MWF. Sort the results by faculty ID in ascending order. 3. Provide a count of students by student type. 4. List the capacity of the largest classroom in each building (use building ID). Sort the results by capacity in descending order. 5. Provide a list of classrooms (use classroom ID) that have an overhead and computer, or a whiteboard. 6. Provide a list of staff (use staff ID) who are skilled at programming. 7. List the first name, last name, and full address for all employees who are also students. Sort the results by last name, first name in ascending order. 8. List the designator, course name, and description for all freshman-level (100-199) courses. Sort the results by designator in ascending order. + Faculty 1 PK, FK FacultyID Discipline Tenure TrackYN Date Tenured FK CollegeDeptid + College Dept PK CollegeDeptid CollegeDeptName * Description FK ChairID Course FK Collegelb PK # Employee PK, FK Employeeld Date Hired [YOS] Employee Type CourseID CourseName d Staff Person PK, FK StaffID + FK University Deptid (Skills) + College PK CollegelD College Name Description FK DeanID Designator Description Credits FK CollegeDeptid OH 0 H PK PersonlD FirstName LastName Middle Name SSN Address City State ZipCode PhoneNbr Date of Birth Student YN Employee YN University Dept PK University Deptid University DeptName FK Supervisorid OH Section PK SectionID FK CourselD FK FacultyID RoomID Class Time Student Enroll HFK PK, FK Studenti AcceptanceDate GraduationDate 11 OFK AdvisorID StudentType PK, FK Studenti OPK, FK SectionID Grade Lab PK, FK Labin NbrOfComputers GasYN AirYN PrinterYN Overhead YN Room d PK Roomid RoomName d Graduate PK, FK GraduatelD Degree Program UnderGrad PK, FK UndergradID Major Room Type Number Capacity FK Buildingid Minor Building PK Buildingid BuildingName Location Classroom PK, FK ClassroomID OverheadYN Whiteboard YN Computer YN VisualizerYN Drop Table If Exists Enroll; Drop Table If Exists Section; Drop Table If Exists Course; Drop Table If Exists Classroom; Drop Table If Exists Lab; Drop Table If Exists Room; Drop Table If Exists Building; Drop Table If Exists Undergrad; Drop Table If Exists Graduate; Drop Table If Exists Student; Drop Table If Exists Staff; Drop Table If Exists Faculty; Drop Table If Exists CollegeDept; Drop Table If Exists College; Drop Table If Exists University Dept; Drop Table If Exists Employee; Drop Table If Exists Person; INT, CREATE TABLE Person PersonID INT NOT NULL, FirstName VARCHAR (30) NOT NULL, LastName VARCHAR (30) NOT NULL, MiddleName VARCHAR(30) SSN INT NOT NULL Address VARCHAR(50), City VARCHAR(50), State CHAR(2), ZipCode PhoneNbr VARCHAR(12), DateOfBirth DATE, StudentYN CHAR(1) NOT NULL, Employee YN CHAR(1) NOT NULL, CONSTRAINT PersonPK PRIMARY KEY (PersonID), CONSTRAINT PersonStudentYnValues CHECK (StudentYN IN ('Y', 'N')), CONSTRAINT PersonEmployeeYNValues CHECK (EmployeeYN IN ('Y', 'N'))); CREATE TABLE Employee EmployeeID INT NOT NULL, DateHired DATE, Employee Type CHAR(1), CONSTRAINT EmployeePK PRIMARY KEY (EmployeeID), CONSTRAINT Employee FK FOREIGN KEY (EmployeeID) REFERENCES Person (PersonID), CONSTRAINT EmployeeTypeValue CHECK (EmployeeType IN ('A', 'F', 'S')); CREATE TABLE UniversityDept University DeptID INT NOT NULL, University DeptName VARCHAR (50) NOT NULL, SupervisorID INT NOT NULL, CONSTRAINT UniversityDept PK PRIMARY KEY (UniversityDeptID), CONSTRAINT UniversitySupervisorFK FOREIGN KEY (SupervisorID) REFERENCES Employee (EmployeeID)); CREATE TABLE College College ID CollegeName Description INT VARCHAR(100) VARCHAR (250), NOT NULL, NOT NULL, DeanID INT NOT NULL, CONSTRAINT College PK PRIMARY KEY (CollegeID), CONSTRAINT College FK FOREIGN KEY (DeanID) REFERENCES Employee (EmployeeID)); CREATE TABLE CollegeDept ( CollegeDeptID INT NOT NULL, CollegeDeptName VARCHAR (100) NOT NULL, Description VARCHAR (250), ChairID INT CollegeID INT NOT NULL, CONSTRAINT CollegeDepartmentPK PRIMARY KEY (CollegeDeptID), CONSTRAINT CollegeDepartmentFK1 FOREIGN KEY (CollegeID) REFERENCES College (CollegeID), CONSTRAINT College DepartmentFK2 FOREIGN KEY (ChairID) REFERENCES Employee (EmployeeID)); CREATE TABLE Faculty FacultyID INT NOT NULL Discipline VARCHAR(50), TenureTrackYN CHAR(1) NOT NULL, DateTenured DATE, CollegeDeptID INT NOT NULL, CONSTRAINT FacultyPK PRIMARY KEY (FacultyID), CONSTRAINT FacultyFK FOREIGN KEY (CollegeDeptID) REFERENCES CollegeDept (CollegeDeptID), CONSTRAINT FacultyFK2 FOREIGN KEY (FacultyID) REFERENCES Employee (EmployeeID), CONSTRAINT FacultyTenureTrackYNValue CHECK (TenureTrackYN IN ('Y', 'N'))); CREATE TABLE Staff StaffID INT NOT NULL, University DeptID INT NOT NULL Skills VARCHAR (250) CONSTRAINT StaffPK PRIMARY KEY (StaffID), CONSTRAINT StaffFKI FOREIGN KEY (UniversityDeptID) REFERENCES UniversityDept (UniversityDeptID), CONSTRAINT StaffFK2 FOREIGN KEY (StaffID) REFERENCES Employee (EmployeeID)); INT, CREATE TABLE Studenti StudentID INT NOT NULL, AcceptanceDate DATE, GraduationDate DATE, AdvisorID StudentType CHAR(1) NOT NULL CONSTRAINT Student PK PRIMARY KEY (StudentID), CONSTRAINT Student FKI FOREIGN KEY (StudentID) REFERENCES Person (PersonID), CONSTRAINT Student FK2 FOREIGN KEY (AdvisorID) REFERENCES Faculty (FacultyID), CONSTRAINT StudentTypeValue CHECK (StudentType IN ('U', 'G'))); CREATE TABLE Graduate GraduateID INT NOT NULL, Degree VARCHAR (50), Program VARCHAR(50), CONSTRAINT Graduate PK PRIMARY KEY (GraduateID), CONSTRAINT GraduateFK FOREIGN KEY (GraduateID) REFERENCES Student (StudentID)); CREATE TABLE Undergrad UndergradID INT NOT NULL, Major VARCHAR(50), Minor VARCHAR(50) CONSTRAINT UndergradPK PRIMARY KEY (UndergradID), CONSTRAINT UndergradFK FOREIGN KEY (UndergradID) REFERENCES Student (StudentID)); CREATE TABLE Building BuildingID INT NOT NULL, BuildingName VARCHAR (50) NOT NULL, Location VARCHAR(30), CONSTRAINT BuildingPK PRIMARY KEY (BuildingID)); CREATE TABLE Room RoomID INT NOT NULL RoomName VARCHAR(50), RoomType CHAR(1) NOT NULL, Number INT NOT NULL, Capacity BuildingID INT NOT NULL, CONSTRAINT RoomPK PRIMARY KEY (RoomID), CONSTRAINT RoomFK FOREIGN KEY (BuildingID) REFERENCES Building (BuildingID), CONSTRAINT RoomTypeValue CHECK (RoomType IN ('L', 'C'))); INT, CREATE TABLE Lab LabID INT NOT NULL, NbrofComputers INT NOT NULL, Gas YN CHAR(1) NOT NULL AirYN CHAR(1) NOT NULL, PrinterYN CHAR(1) NOT NULL, OverheadYN CHAR(1) NOT NULL CONSTRAINT LabPK PRIMARY KEY (LabID), CONSTRAINT LabFK FOREIGN KEY (LabID) REFERENCES Room (RoomID),| CONSTRAINT LabGasYNValue CHECK (GasYN IN ('Y', 'N')). CONSTRAINT LabAirYNValue CHECK (ALTYN IN ('Y', 'N)), CONSTRAINT LabPrinterYNValue CHECK (PrinterYN IN ('Y', 'N')), CONSTRAINT LaboverheadYNValue CHECK (OverheadYN IN ('Y', 'N')); CREATE TABLE Classroom ClassroomID INT NOT NULL, OverheadYN CHAR(1) NOT NULL WhiteboardyN CHAR(1) NOT NULL ComputerYN CHAR(1) NOT NULL, VisualizerYN CHAR(1) NOT NULL, CONSTRAINT ClassroomPK PRIMARY KEY (ClassroomID), CONSTRAINT ClassroomFK FOREIGN KEY (ClassroomID) REFERENCES Room (RoomID) CONSTRAINT ClassroomOverheadYnValue CHECK (OverheadYN IN ('Y', 'N')), CONSTRAINT ClassroomwhiteboardynValue CHECK (WhiteboardyN IN ('Y', 'N')), CONSTRAINT ClassroomComputerYNValue CHECK (ComputerYN IN ('Y', 'N')), CONSTRAINT ClassroomVisualizerYNValue CHECK (VisualizerYN IN ('Y', 'N')); CREATE TABLE Course CourseID INT NOT NULL, CourseName VARCHAR(100) NOT NULL Designator VARCHAR (7) NOT NULL, Description VARCHAR(250), Credits INT NOT NULL, CollegeDeptID INT NOT NULL, CONSTRAINT CoursePK PRIMARY KEY (CourseID), CONSTRAINT CourseFK FOREIGN KEY (CollegeDeptID) REFERENCES CollegeDept (CollegeDeptID)); CREATE TABLE Section SectionID INT NOT NULL, CourseID INT NOT NULL, FacultyID INT NOT NULL, RoomID INT NOT NULL Classtime VARCHAR(30) NOT NULL CONSTRAINT SectionPK PRIMARY KEY (SectionID), CONSTRAINT SectionFKI FOREIGN KEY (CourseID) REFERENCES Course (CourseID), CONSTRAINT SectionFK2 FOREIGN KEY (FacultyID) REFERENCES Faculty (FacultyID) CONSTRAINT SectionFK3 FOREIGN KEY (RoomID) REFERENCES Room (RoomID)); CREATE TABLE Enroll( StudentID INT NOT NULL, SectionID INT NOT NULL, Grade VARCHAR(2), CONSTRAINT EnrollPK PRIMARY KEY (StudentID, SectionID), CONSTRAINT EnrollFK1 FOREIGN KEY (Section ID) REFERENCES Section (SectionID), CONSTRAINT EnrollFK2 FOREIGN KEY (StudentID) REFERENCES Student (StudentID)); INSERT INTO Person VALUES (1, 'Jake', 'Grimes', 'William', 232749743, '8235 High St.', 'Mt. Pleasant', 'MI', 48858, '402-491-5000', '1993-3-2', 'Y', 'N'); INSERT INTO Person VALUES (2, 'Isabella', 'Jones', 'Sohpia', 905882891, '3638 Main St.', 'Detroit', 'MI', 48201, '187-249-5503', '1992-1-25', 'Y', 'N'); INSERT INTO Person VALUES (3, 'Jennifer', Schnider', 'Samantha',957619406, '2734 Shady Ln.', 'Detroit', 'MI', 48201, '526-964-6200', '1991-6-18','Y', 'N'); INSERT INTO Person VALUES (4, 'Emma', 'Witucki', 'Elizabeth', 422465558, '3188 Park In.', 'Mt. Pleasant', 'MI', 48858, '552-135-3844', '1991-8-16', 'Y', 'N'); INSERT INTO Person VALUES (5, 'Ethan', 'Misner', 'Ryan',711768703,'793 Preston St.', 'Grand Rapids', 'M', 49501, '615-983-1050', '1991-3-3', 'Y', 'N'); INSERT INTO Person VALUES (6, 'Will', 'Miller', 'Robert', 638034797,'1318 Mission St.', 'Grand Rapids', 'MI', 49501, '264-761-0960', '1992-3-4', 'Y', 'N'); INSERT INTO Person VALUES (7, 'Alex', 'Bowman', 'Noah', 390330967, '7643 State St.', 'Lansing', 'MI', 48901, '152-808-7061', '1992-10-5', 'Y', 'N'); INSERT INTO Person VALUES (8, 'Noah', 'Ware', 'Nathaniel',344718626, '2688 Cottonwood Dr.', 'Bay City', 'MI', 48706, '500-563-7948', '1993-11-6','Y', 'N'); INSERT INTO Person VALUES (9, 'Olivia', 'Mannarino', 'Jo',786272316, '9894 Maple Ave.', 'Farmington Hills', 'MI', 48331, '220-930-3449', '1992-1-12', 'Y', 'N'); INSERT INTO Person VALUES (10,'Emily', 'White', 'Mason', 663145296, '953 Wexford Dr.', 'Saginaw', 'MI', 48601, '688-529-1258', '1953-5-5', 'Y', 'N'); INSERT INTO Person VALUES (11, 'Madison', 'Ceccacci', 'Whitney', 238333251, '4382 Bank St.', 'Muskegon', 'MI', 49440, '574-193-4178', '1992-8-16','Y','N); INSERT INTO Person VALUES (12, 'Chloe', 'Toerper', 'Marie', 342251330, '1070 Main St.','Traverse City', 'MI', 49684, '338-928-2001','1956-7-28', 'N','Y'); INSERT INTO Person VALUES (13, 'Aiden', 'Kelly', 'James', 523447216, '9050 Cottonwood Dr.', 'Muskegon', 'MI', 49440, '879-404-9361', '1972-3-2','N','Y'); INSERT INTO Person VALUES (14, 'Dan', 'Borne', 'Jacob', 848471140, '4839 Main St.', 'Lansing', 'MI', 48901, '253-022-4289', '1977-1-25', 'N', 'Y'); INSERT INTO Person VALUES (15, 'Anthony', 'Dickerson', 'Michael',559255730, '7028 Bellows St.', 'Midland', 'MI', 48640, '671-722-7606', '1975-6-18', 'N','Y'); INSERT INTO Person VALUES (16, 'Joe', 'Miles', 'Phillip', 400209377, '9699 High St.', 'Flint','MI', 48501, '649-272-3596', '1964-8-16', 'N','Y'); INSERT INTO Person VALUES (17, 'Matt', 'Adas', 'Ethan',233649260, '8409 Mission St.', 'Bay City', 'MI', 48706,'119-208-1432', '1990-12-15', 'Y','Y'); INSERT INTO Person VALUES (18, 'Edward', 'Ward', 'Francis',712639178, '6045 Madison Ave.', 'Grand Rapids', 'MI', 49501, '936-876-9347', '1962-3-4', 'N','Y'); INSERT INTO Person VALUES (19, 'James', 'Justice', 'Ian',959298695, '4341 State St.', 'Mt. Pleasant', 'MI', 48858, '476-244-5435', '1958-10-5', 'N', 'Y'); INSERT INTO Person VALUES (20, 'Ryan', 'Summers', 'Edward', 738864084, '6780 Hillcrest Dr.', 'Saginaw', 'MI', 48601, '690-667-2956', '1973-11-6', 'N','Y'); INSERT INTO Person VALUES (21, 'Chris', 'Carlson', 'Thomas', 618794404, '4191 Westminister Ct.', 'Flint', 'MI', 48501, '742-041-7957', '1975-1-12','N','Y'); INSERT INTO Person VALUES (22, 'Mason', 'Whitley', 'Joseph', 263588235, '2851 Bellows St.', 'Flint','MI', 48501, '600-321-4847', '1974-5-5', 'N','Y'); INSERT INTO Person VALUES (23, 'Addison', 'Malner', 'Danielle', 641392556, '5516 Broadway Ave.', 'Traverse City', 'MI',49684,'498-847-6410', '1970-8- 16', 'N', 'Y'); INSERT INTO Person VALUES (24, 'Steven', 'Johnson', 'Christopher', 173165133, '4264 High St.', 'Bay City', 'MI', 48706, '243-404-9957', '1954-7-28', 'N','Y'); INSERT INTO Person VALUES (25, 'Natalie', 'Jackson', 'Chloe',360136676, '5230 Elm St.', 'Muskegon', 'MI', 49440, 638-351-1311','1957-3-2', 'N', 'Y'); INSERT INTO Person VALUES (26, 'Sam', 'Winslow', 'Anthony', 261631001, '6517 Bank St.', 'Traverse City', 'MI', 49684, '188-305-1614', '1976-1-25', 'N', 'Y'); INSERT INTO Person VALUES (27, 'Samantha', 'Samsford', 'Alexis',228483375,'4502 College Dr.', 'Farmington Hills', 'MI', 48331, '983-267-2569', '1967-6- 18', 'N','Y'); INSERT INTO Person VALUES (28, 'Elizabeth', 'Gateaux', 'Susan',279737259,'686 Clairmont Ave.', 'Grand Rapids', 'MI', 49501,'777-380-5593', '1977-8- 16', 'N', 'Y'); INSERT INTO Person VALUES (29, 'Bobby', 'Curtis', 'Aiden', 593397401, '8899 College Dr.', 'Grand Rapids', 'MI', 49501, '351-910-6231', '1956-3-3', 'N','Y'); INSERT INTO Person VALUES (30, 'Grace', 'Rose', 'Addison',916158980, '1836 Main St.', 'Saginaw', 'MI', 48601, '638-475-9077', '1960-3-4', 'N','Y'); INSERT INTO Person VALUES (31, 'Will', 'Nolan', 'Jeffrey', 816830623, '3216 Mission St.', 'Mt. Pleasant', 'MI', 48858, '354-572-8039', '1975-3-4', 'N','Y'); INSERT INTO Person VALUES (32, 'Sohpia', 'Vento', 'Marie',312998913, '8439 Broadway Ave.', 'Detroit', 'MI', 48201, '993-278-4173', '1956-10-5', 'N', 'Y'); INSERT INTO Person VALUES (33,'Peter', 'Doyal', 'Erik', 630363387, '4229 Maple Ave.', 'Detroit', 'MI', 48201, '224-896-5886', '1991-7-8','Y', 'Y'); INSERT INTO Person VALUES (34, 'Derek', 'Warner', 'Shane', 470139983, '2445 Preston St.', 'Mt. Pleasant', 'M', 48858, '783-932-2430', '1973-1-12', 'N','Y'); INSERT INTO Person VALUES (35, 'Ryan', 'Lewandowski', 'Lynn',536686924, '1467 Broadway Ave.', 'Grand Rapids', 'MI', 49501, '288-871-2804', '1958-5-5', 'N','Y'); INSERT INTO Person VALUES (36, 'Olivia', 'Misner','Taylor',228652644, '7124 Cottonwood Dr.', 'Grand Rapids', 'MI', 49501, '262-921-3784', '1962-8- 16', 'N','Y'); INSERT INTO Person VALUES (37,'Zach', 'Johnson', 'Michael',243382744, '7796 High St.', 'Flint', 'MI', 48501, '179-251-9950', '1961-7-28', 'N','Y'); INSERT INTO Person VALUES (38, 'Mary', 'white', 'Joan',903196110, '9184 College Dr.', 'Bay City', 'MI', 48706, '147-420-2347', '1973-3-2', 'N', 'Y'); INSERT INTO Person VALUES (39, 'Jason', 'Palmer', 'Bryce',154399164, '762 Elm St.', 'Farmington Hills', 'MI',48331, '303-243-7549', '1973-1-25', 'N','Y'); INSERT INTO Person VALUES (40, 'Elizabeth', 'Paksi', 'Oprah',949787756, '6685 Wexford Dr.', 'Saginaw', 'MI', 48601, '868-924-7027', '1955-6-18', 'N','Y'); INSERT INTO Person VALUES (41, 'Ed', 'Brennan', 'Shaw', 129320162, '255 College Dr.', 'Muskegon', 'MI', 49440, '686-861-5139', '1964-8-16', 'N','Y'); INSERT INTO Person VALUES (42, 'Dan', 'Smart', 'Austin',931802838, '5462 Bellows St.', 'Traverse City', 'MI', 49684, '946-023-5994', '1964-7-28', 'N','Y'); INSERT INTO Person VALUES (43, 'Chris', 'Jones', 'Thomas', 678176459, 3582 High St.', 'Muskegon', 'MI', 49440, '582-675-3502', '1955-3-2', 'N', 'Y'); INSERT INTO Person VALUES (44, 'Emily', 'Vos', 'Rose',206839100, '5094 College Dr.', 'Lansing', 'MI', 48901, '316-534-3605', '1957-1-25', 'N', 'Y'); INSERT INTO Person VALUES (45, 'Anthony', 'Husby', 'Karl',246743511, '1838 Park Ln.', 'Midland', 'MI', 48640, '266-411-4725','1975-6-18', 'N','Y'); INSERT INTO Person VALUES (46, 'Bryce', 'Heuvel', 'Steven', 646549866, '5327 Cottonwood Dr.', 'Muskegon', 'MI', 49440, '582-750-8968', '1960-8-16', 'N','Y'); INSERT INTO Person VALUES (47, 'Mason', 'Prouty', 'Edward', 575514537, '1174 College Dr.', 'Traverse City', 'MI',49684, '285-092-1351', '1992-10-14', 'Y','Y'); INSERT INTO Person VALUES (48, 'Madison', 'Copus', 'Sarah',720183118, '3171 Preston St.', 'Farmington Hills', 'MI', 48331, '855-073-9268', '1964-3- 4', 'N','Y'); INSERT INTO Person VALUES (49, 'Joe', 'Wiaduck', 'Kirby',204765542, '1937 Bellows St.', 'Grand Rapids', 'MI', 49501, '739-909-8182', '1973-1-12', 'N', 'Y'); INSERT INTO Person VALUES (50,'James', 'Fowler', 'Brian', 675986070, '1939 Madison Ave.', 'Grand Rapids', 'MI', 49501, '659-719-3368', '1965-5-5', 'N','Y'); INSERT INTO Employee VALUES (12, '2005-2-15', 'F'); INSERT INTO Employee VALUES (13,'2010-8-28', 'F'); INSERT INTO Employee VALUES (14, '2010-8-5','S'); INSERT INTO Employee VALUES (15, '2006-2-21', 'F'); INSERT INTO Employee VALUES (16, '1994-4-9', 'F'); INSERT INTO Employee VALUES (17, '2012-6-23','S'); INSERT INTO Employee VALUES (19, '1999-8-13', 'F'); INSERT INTO Employee VALUES (19, '2000-10-20', 'F'); INSERT INTO Employee VALUES (20, '2005-10-14', 'F'); INSERT INTO Employee VALUES (21, '2010-6-3','A'); INSERT INTO Employee VALUES (22, '2006-1-4', 'F'); INSERT INTO Employee VALUES (23, '2004-1-13', 'A'); INSERT INTO Employee VALUES (24, '2002-8-8', 'F'); INSERT INTO Employee VALUES (25, '2004-6-9', 'F'); INSERT INTO Employee VALUES (26, '2007-4-25', 'A'); INSERT INTO Employee VALUES (27, '2007-6-4','S'); INSERT INTO Employee VALUES (28, '2008-10-12', 'F'); INSERT INTO Employee VALUES (29, '2001-10-25', 'F'); INSERT INTO Employee VALUES (30,'2008-3-22', 'A'); INSERT INTO Employee VALUES (31, '2005-4-1','S'); INSERT INTO Employee VALUES (32,'1997-11-23', 'F'); INSERT INTO Employee VALUES (33, '2012-4-24','S'); INSERT INTO Employee VALUES (34, '2004-5-25', 'F'); INSERT INTO Employee VALUES (35, '2001-10-20', 'F'); INSERT INTO Employee VALUES (36, '2002-11-14', 'A'); INSERT INTO Employee VALUES (37, '2001-12-23', 'F'); INSERT INTO Employee VALUES (38, '2003-6-13', 'F'); INSERT INTO Employee VALUES (39, '2004-3-16','S'); INSERT INTO Employee VALUES (40, '1998-2-11', 'F'); INSERT INTO Employee VALUES (41, '2001-218', 'F'); INSERT INTO Employee VALUES (42, '2004-3-13', 'F'); INSERT INTO Employee VALUES (43, '2003-2-10','F'); INSERT INTO Employee VALUES (44, '2005-2-9','S'); INSERT INTO Employee VALUES (45, '2010-6-8','A'); INSERT INTO Employee VALUES (46, '2001-12-29','F'); INSERT INTO Employee VALUES (47, '2012-8-11','S'); INSERT INTO Employee VALUES (48, '2001-6-9', 'F'); INSERT INTO Employee VALUES (49, '2002-10-14', 'F'); INSERT INTO Employee VALUES (50, '2012-11-16','S'); INSERT INTO UniversityDept VALUES (1, 'Information Technology', 36); INSERT INTO UniversityDept VALUES (2, 'Maintenance',45);|| INSERT INTO UniversityDept VALUES (3, 'Personnel',23); INSERT INTO College VALUES (1, 'Arts & Science', 'The college devoted to providing students with a foundation in the liberal arts and basic sciences', 26); INSERT INTO College VALUES (2, 'Business', 'The college devoted to providing students with an understanding of modern business practices',30); INSERT INTO College VALUES (3, 'Education', 'The college devoted to developing future teachers through exposure to the theory and practice of education', 21); INSERT INTO CollegeDept VALUES (1, 'Art & Music', 'Focuses on the study of art and music and their development through time',18,1); INSERT INTO CollegeDept VALUES (2, 'Chemistry', 'Focuses on the study and use of chemicals', 19,1); INSERT INTO CollegeDept VALUES (3, 'History', 'Focuses on the history and evolution of human civilization',24,1); INSERT INTO CollegeDept VALUES (4, 'Math', 'Focuses on developing basic and advanced math skills', 16, 1); INSERT INTO CollegeDept VALUES (5, 'Accounting', 'Focuses on the study of accounting principles and practices', 41,2); INSERT INTO CollegeDept VALUES (6, 'Information Systems', 'Focuses on the design, implementation, and management of information systems',29,2); INSERT INTO CollegeDept VALUES (7, 'Marketing', 'Focuses on the development of marketing skills and methods of research for marketing situations', 12,2); INSERT INTO CollegeDept VALUES (8, 'Management', 'Focuses on management techniques for administrative and manager positions', 43, 2); INSERT INTO CollegeDept VALUES (9, 'Early Childhood', 'Focuses on the study of education for pre-k and kinder cen', 49,3); INSERT INTO CollegeDept VALUES (10, 'Elementary Education', 'Focuses the study of education in grades 1-6', 40,3); INSERT INTO Faculty VALUES (18, 'Art', 'Y', '2005-1-1',1); INSERT INTO Faculty VALUES (25, 'Music', 'N',NULL, 1); INSERT INTO Faculty VALUES (48, 'Chemistry','Y', '2007-1-1',2); INSERT INTO Faculty VALUES (19, 'Chemistry', 'Y', '2006-1-1',2); INSERT INTO Faculty VALUES (24, 'History', 'Y', '2008-1-1', 3); INSERT INTO Faculty VALUES (22, 'History','Y', '2012-1-1',3); INSERT INTO Faculty VALUES (32, 'Math', 'Y', '2003-1-1', 4); INSERT INTO Faculty VALUES (16, 'Math', 'Y', '2000-1-1', 4); INSERT INTO Faculty VALUES (20, 'Math', 'N',NULL, 4); INSERT INTO Faculty VALUES (41, 'Accounting', 'y', '2007-1-1',5); INSERT INTO Faculty VALUES (13, 'Accounting', 'Y',NULL, 5); INSERT INTO Faculty VALUES (46, 'Information Systems', 'y', '2007-1-1',6); INSERT INTO Faculty VALUES (29, 'Information Systems', 'Y', '2007-1-1',6); INSERT INTO Faculty VALUES (38, 'Information Systems', 'N',NULL, 6); INSERT INTO Faculty VALUES (12, 'Marketing', 'Y', '2011-1-1',7); INSERT INTO Faculty VALUES (28, 'Marketing', 'Y',NULL, 7); INSERT INTO Faculty VALUES (43, 'Management','Y', '2009-1-1',8); INSERT INTO Faculty VALUES (42, 'Management','Y', '2010-1-1',8); INSERT INTO Faculty VALUES (15, 'Management', 'N',NULL, 8); INSERT INTO Faculty VALUES (49, 'Early Childhood', 'Y', '2008-1-1',9); INSERT INTO Faculty VALUES (34, 'Early Childhood', 'Y', '2010-1-1',9); INSERT INTO Faculty VALUES (37, 'Elementary Education', 'Y', '2007-1-1',10); INSERT INTO Faculty VALUES (35, 'Elementary Education', 'Y', '2007-1-1',10); INSERT INTO Faculty VALUES (40, 'Elementary Education', 'Y','2004-1-1', 10); INSERT INTO Staff VALUES (14,3, 'HR, Benefits'); INSERT INTO Staff VALUES (17,2, 'Gardening/Lawn Care'); INSERT INTO Staff VALUES (23,3, 'Management, HR'); INSERT INTO Staff VALUES (27,2, 'Painting'); INSERT INTO Staff VALUES (31,3, 'Benefits'); INSERT INTO Staff VALUES (33,1, 'Customer Support, Programming'); INSERT INTO Staff VALUES (36,1, 'Management, Database Administration'); INSERT INTO Staff VALUES (39,2, 'Carpentry, Plumbing'); INSERT INTO Staff VALUES (44,2, 'Plumbing'); INSERT INTO Staff VALUES (45, 2, 'Management, Painting'); INSERT INTO Staff VALUES (47,1, 'Database Administration, Programming'); INSERT INTO Staff VALUES (50,1, 'Programming'); INSERT INTO Student VALUES (1, '2008-4-17', '2012-5-5',NULL,'U'); INSERT INTO Student VALUES (2, '2007-6-1','2011-5-5',NULL, 'G'); INSERT INTO Student VALUES (3,'2010-3-20',NULL, 24, 'U'); INSERT INTO Student VALUES (4,'2011-8-17',NULL, 41, 'U'); INSERT INTO Student VALUES (5, '2006-6-1', '2010-5-5',NULL,'U'); INSERT INTO Student VALUES (6, '2011-3-20',NULL, 37,'U'); INSERT INTO Student VALUES (7, '2008-5-15', '2012-5-5',NULL, 'G'); INSERT INTO Student VALUES (8,'2009-5-17',NULL, 43, 'U'); INSERT INTO Student VALUES (9,'2010-6-1',NULL, 49, 'U'); INSERT INTO Student VALUES (10, '2008-3-20', '2012-5-5',NULL, 'G'); INSERT INTO Student VALUES (11, '2009-7-15',NULL, 19,'U'); INSERT INTO Student VALUES (17,'2011-4-21',NULL, 22, 'U'); INSERT INTO Student VALUES (33, '2010-6-15',NULL, 13,'U'); INSERT INTO Student VALUES (47, '2006-5-25', '2010-5-5',NULL, 'G'); INSERT INTO Graduate VALUES (2, 'BS Information Systems', 'MSIS'); INSERT INTO Graduate VALUES (7,'BS Business Administration', 'MBA'); INSERT INTO Graduate VALUES (10,'BS Information Systems', 'MSIS'); INSERT INTO Graduate VALUES (47, 'BS Information Systems', 'MSIS'); INSERT INTO Undergrad VALUES (1, 'Marketing', 'Management'); INSERT INTO Undergrad VALUES (3, 'History',''); INSERT INTO Undergrad VALUES (4, 'Accounting', 'Information Systems'); INSERT INTO Undergrad VALUES (5,'Information Systems','');|| INSERT INTO Undergrad VALUES (6, 'Elementary Education',''); INSERT INTO Undergrad VALUES (8, 'Management','Information Systems'); INSERT INTO Undergrad VALUES (9, 'Early Childhood',''); INSERT INTO Undergrad VALUES (11, 'Chemistry', 'Math'); INSERT INTO Undergrad VALUES (17, 'History',''); INSERT INTO Undergrad VALUES (33, 'Accounting',''); INSERT INTO Building VALUES (1, 'Miller', 'North Campus'); INSERT INTO Building VALUES (2, 'Smith', 'North Campus'); INSERT INTO Building VALUES (3, 'Phelps', 'South Campus'); INSERT INTO Building VALUES (4, 'Kettinger', 'East Campus'); INSERT INTO Room VALUES (1, 'Lecture', 'C',153, 30,1); INSERT INTO Room VALUES (2, 'Tiered Lecture', 'C', 426,100,1); INSERT INTO Room VALUES (3, 'Computer Lab 1','1',303, 42,1); INSERT INTO Room VALUES (4, 'Computer Lab 2', 'L',254, 45,1); INSERT INTO Room VALUES (5, 'Lecture 1', 'C', 136, 30,2); INSERT INTO Room VALUES (6, 'Lecture 2', 'C', 102,35,2); INSERT INTO Room VALUES (7, 'Lecture 3','C',314, 48,2); INSERT INTO Room VALUES (8, 'Tiered Lecture', 'C',316,100,2); INSERT INTO Room VALUES (9, 'Chemistry Lab','1',365,20,3); INSERT INTO Room VALUES (10, 'Lecture 1','C',145,55,3); INSERT INTO Room VALUES (11, 'Lecture 2', 'C',258, 65,3); INSERT INTO Room VALUES (12, 'Studio', 'L',315, 22, 4); INSERT INTO Room VALUES (13, 'Auditorium 1', 'C',456,200, 4); INSERT INTO Room VALUES (14, 'Auditorium 2', 'C',254, 325, 4); INSERT INTO Lab VALUES (3,40, 'N','N','Y','Y'); INSERT INTO Lab VALUES (4, 45, 'N','N','Y','Y'); INSERT INTO Lab VALUES 19,2,'Y', 'Y','N','Y'); INSERT INTO Lab VALUES (12,0, 'N','N','N','Y'); INSERT INTO Classroom VALUES (1,'Y','Y','Y', 'Y'); INSERT INTO Classroom VALUES (2, 'Y','Y', 'N', 'N'); INSERT INTO Classroom VALUES (5,'Y', 'N', 'N', 'N'); INSERT INTO Classroom VALUES (6, 'Y', 'N','Y', 'Y'); INSERT INTO Classroom VALUES (7,'Y','Y','Y','Y'); INSERT INTO Classroom VALUES (8,'Y', 'N','Y', 'Y'); INSERT INTO Classroom VALUES (10, 'Y', 'Y','N', 'N'); INSERT INTO Classroom VALUES (11, 'N','Y', 'N', 'N'); INSERT INTO Classroom VALUES (13,'Y', 'Y','Y','Y'); INSERT INTO Classroom VALUES (14, 'N','Y', 'N', 'N'); INSERT INTO Course VALUES (1, 'Art Appreciation', 'ART100', 'An introduction to the wide world of art', 3, 1); INSERT INTO Course VALUES (2, 'Survey of Modern Art', 'ART200', 'A broad review of art produced since the middle of the 20th century',3,1); INSERT INTO Course VALUES (3, 'Music Appreciation', 'MUS100', 'An introduction to music including its development over time',3,1); INSERT INTO Course VALUES (4,'Introduction to Musical Composition', 'MUS101', 'An introduction to reading and writing music', 4,1); INSERT INTO Course VALUES (5,'Introduction to Chemistry', 'CHEM100', 'An introduction to elementary chemistry',3,2); INSERT INTO Course VALUES (6, 'Organic Chemistry', 'CHEM200', 'An in-depth review of carbon-based chemical compounds', 4,2); INSERT INTO Course VALUES (7, 'American History I', 'HIST100', "American history until the end of the Civil War',3,3); INSERT INTO Course VALUES (8, 'American History II', 'HIST101', 'American history from the end of the Civil to the present',3,3); INSERT INTO Course VALUES (9, 'History of Western Civilization I','HIST200', 'A history of western civilization from the birth of Greek society to the Fall of Rome', 3,3); INSERT INTO Course VALUES (10, 'History of Western Civilization II','HIST201', 'A history of western civilization from the Fall of Rome to the Renaissance',3,3); INSERT INTO Course VALUES (11, 'College Algebra', 'MTH100', 'An introduction to algebra', 3, 4); INSERT INTO Course VALUES (12, 'Statistics', 'MTH200', 'An introduction to statistics', 3, 4); INSERT INTO Course VALUES (13, 'Calculus', 'MTH300', 'A introduction to calculus', 3, 4); INSERT INTO Course VALUES (14, 'Managerial Accounting', 'ACCT200', 'Accounting principles and rules used in managing a business',3,5); INSERT INTO Course VALUES (15, 'Financial Accounting', 'ACCT201', 'Accounting principles and rules that apply to financial decision making',3,5); INSERT INTO Course VALUES (16, 'Tax Accounting', 'ACCT300', 'A review of tax laws applicable to accounting practice',3,5); INSERT INTO Course VALUES (17, 'Applications Development','IS100', 'An introduction to applications development using an object-oriented programming language', 3,6); INSERT INTO Course VALUES (18, 'Systems Analysis & Design','IS200', 'A review of the System Development Life Cycle',3,6); INSERT INTO Course VALUES (19, 'Database Management','IS300', 'An introduction to the design, development, and use of relational databases in business', 3,6); INSERT INTO Course VALUES (20,'Introduction to Marketing', 'MKT100', 'A review of common business theories to manipulate target markets and large demographics',3,7); INSERT INTO Course VALUES (21, 'Market Strategy', 'MKT200', 'A review of market analysis and its use in developing competitive business strategies',3,7); INSERT INTO Course VALUES (22, 'M Research', 'MKT300', 'An introduction market research techniques',3,7); INSERT INTO Course VALUES (23, 'Principles of Management', 'MGMT100', 'An introduction to the common management principles used in organizations',3,8); INSERT INTO Course VALUES (24, 'Organizational Behavior', 'MGMT200', 'A review of theories related to how people behave within organizations', 3,8); INSERT INTO Course VALUES (25, 'Theory of Pre-K Education', 'EC100', 'A review of theories related to pre-k education',3,9); INSERT INTO Course VALUES (26, 'Practicum', 'EC200', 'The application of educational theory in practice', 4,9); INSERT INTO Course VALUES (27, 'Elementary Education 1-3', 'ELEM100', "An introduction to educational practice for grades 1-3',3,10); INSERT INTO Course VALUES (28, 'Elementary Education 4-6', 'ELEM101', 'An introduction to educational practice for grades 4-6,3,10); INSERT INTO Section VALUES (1,1,18,10,'MWE 9:00-9:50'); INSERT INTO Section VALUES (2,2,18,10,'MWF 4:00-4:50'); INSERT INTO Section VALUES (3,3,25, 12, 'TTH 3:30-4:45'); INSERT INTO Section VALUES (4,4,25,12, 'MWE 3:00-3:50'); INSERT INTO Section VALUES (5,5,19,9, 'MWF 10:00-10:50'); INSERT INTO Section VALUES (6,6, 48,9, 'MWF 1:00-1:50'); INSERT INTO Section VALUES (7,7,24,13, 'TTH 11:00-12:15'); INSERT INTO Section VALUES (8,7,22,13, 'TTH 12:30-1:45'); INSERT INTO Section VALUES (9,8,22,14, 'MWE 10:00-10:50'); INSERT INTO Section VALUES (10,8,24,14, 'MWF 4:00-4:50'); INSERT INTO Section VALUES (11,9,24,13, 'MWF 3:00-3:50'); to INSERT INTO Section VALUES (12,10,24,14, 'MWF 2:00-2:50'); INSERT INTO Section VALUES (13,11,20,10,'TTH 11:00-12:15'); INSERT INTO Section VALUES (14, 11, 32,10,'TTH 2:00-3:15'); INSERT INTO Section VALUES (15,12,16,11, 'MWF 4:00-4:50'); INSERT INTO Section VALUES (16,13, 32, 11, 'TTH 2:00-3:15'); INSERT INTO Section VALUES (17,14, 41, 2, 'MWF 2:00-2:50'); INSERT INTO Section VALUES (18,14, 41, 2, 'TTH 11:00-12:15'); INSERT INTO Section VALUES (19,14,41,2, 'ITH 3:30-4:45'); INSERT INTO Section VALUES (20,15,13,1, 'MWF 10:00-10:50'); INSERT INTO Section VALUES (21,16,13,1, 'TTH 11:00-12:15'); INSERT INTO Section VALUES (22,17,29,3, 'MWE 10:00-10:50'); INSERT INTO Section VALUES (23, 18, 38,1, 'TTH 2:00-3:15'); INSERT INTO Section VALUES (24,19,46,4, 'MWE 2:00-2:50'); INSERT INTO Section VALUES (25,20,12,2, 'MWF 1:00-1:50'); INSERT INTO Section VALUES (26,20,12,2, 'TTH 2:00-3:15'); INSERT INTO Section VALUES (27,21,28,1, 'MWF 4:00-4:50'); INSERT INTO Section VALUES (28,22,28,1, 'MWE 9:00-9:50'); INSERT INTO Section VALUES (29,23,15,2, 'MWF 3:00-3:50'); INSERT INTO Section VALUES (30,23, 42,2, 'TTH 9:30-10:45'); INSERT INTO Section VALUES (31, 23, 42,2, 'TTH 12:30-1:45'); INSERT INTO Section VALUES (32,24,43,1, 'MWF 2:00-2:50'); INSERT INTO Section VALUES (33, 25, 49,8, 'TTH 9:30-10:45'); INSERT INTO Section VALUES (34,25,49,8, 'TTH 11:00-12:15'); INSERT INTO Section VALUES (35,26,34,7, 'MWF 3:00-3:50'); INSERT INTO Section VALUES (36,26, 49,7,'TTH 12:30-1:45'); INSERT INTO Section VALUES (37,27,35,6, 'MWF 3:00-3:50'); INSERT INTO Section VALUES (38,27,35,5, 'ITH 11:00-12:15'); INSERT INTO Section VALUES (39, 28, 40,6, 'MWE 10:00-10:50'); INSERT INTO Section VALUES (40,28,40,5, 'TTH 3:30-4:45'); INSERT INTO Enroll VALUES (3,1, 'B+'); INSERT INTO Enroll VALUES (3,9,'A'); INSERT INTO Enroll VALUES (3,11, 'A-'); INSERT INTO Enroll VALUES (3, 13, 'B'); INSERT INTO Enroll VALUES (4,17, 'A-'); INSERT INTO Enroll VALUES (4,21, 'B'); INSERT INTO Enroll VALUES (4,22, 'A-'); INSERT INTO Enroll VALUES (4,23, 'B+'); INSERT INTO Enroll VALUES (4,29,'B'); INSERT INTO Enroll VALUES (6,1, 'A-'); INSERT INTO Enroll VALUES (6,3, 'D-'); INSERT INTO Enroll VALUES (6,8, 'E'); INSERT INTO Enroll VALUES (6, 37, 'B'); INSERT INTO Enroll VALUES (6, 39, 'B+'); INSERT INTO Enroll VALUES (8,18, 'C'); INSERT INTO Enroll VALUES (8,26, 'B'); INSERT INTO Enroll VALUES (8,29, 'A-'); INSERT INTO Enroll VALUES (8,32, 'B+'); INSERT INTO Enroll VALUES (9,2, 'B+'); INSERT INTO Enroll VALUES (9,4, 'B'); INSERT INTO Enroll VALUES (9, 34, 'A-'); INSERT INTO Enroll VALUES (9,36, 'A'); INSERT INTO Enroll VALUES (11,2,'B-'); INSERT INTO Enroll VALUES (11,6, 'B+'); INSERT INTO Enroll VALUES (11,8, 'A'); INSERT INTO Enroll VALUES (11,11, 'A-'); INSERT INTO Enroll VALUES (11,16,'B'); INSERT INTO Enroll VALUES (17,1, 'A-'); INSERT INTO Enroll VALUES (17,10,'A'); INSERT INTO Enroll VALUES (17,12, 'B+'); INSERT INTO Enroll VALUES (17,14, 'C-'); INSERT INTO Enroll VALUES (33,20, 'D-'); INSERT INTO Enroll VALUES (33,21, 'D'); INSERT INTO Enroll VALUES (33,25, 'B-'); INSERT INTO Enroll VALUES (33,29,'C')