Monson University 1 - Data Manipulation Language

-- Monson University 1 - Data Manipulation Language --

-- =============================================
-- Database: Monson University1
-- Author:   FunctionX
-- Date:	 Wednesday 13 June 2012
-- =============================================
USE MonsonUniversity1;
GO

INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'ADMN', N'Administration, Admissions, and Students Affairs');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'HRMN', N'Human Resources and Management');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'ITEC', N'Information Technology');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'LNGS', N'Languages and Linguistics');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'MATH', N'Mathematics and Statistics');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'FINA', N'Finances');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'ACCT', N'Accounting');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'EBCM', N'Economics, Business, Commerce, and Marketing');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'PSOP', N'Psychology, Sociology, and Philosophy');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'CHBT', N'Chemistry, Biology, and Biotechnology');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'CMSC', N'Computer Sciences and Computer Engineering');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'CMST', N'Computer Studies');
GO
INSERT INTO Departments(DepartmentCode, DepartmentName) VALUES(N'HGPS', N'History, Geography, and Political Sciences');
GO

INSERT INTO Employees VALUES(N'279227', N'Donald', N'Henry', N'Leighton', N'ADMN', N'President', NULL);
GO
INSERT INTO Employees VALUES(N'502494', N'Anthony', N'Robert', N'Parrish', N'ADMN', N'Provost', NULL);
GO
INSERT INTO Employees VALUES(N'927486', N'Robert', N'John', N'Preston', N'CMST', N'Dean of Computer Studies', NULL);
GO
INSERT INTO Employees VALUES(N'930248', N'Jeannette', N'Veronica', N'Holms', N'ADMN', N'Vice President for Government Relations', NULL);
GO
INSERT INTO Employees VALUES(N'204850', N'Simon', NULL, 'Lew', N'FINA', N'Vice-President and Chief Financial Officer', NULL);
GO
INSERT INTO Employees VALUES(N'275594', N'Kellie', N'Joan', N'Tierney', N'ADMN', N'Vice-President and Dean of Undergraduate Studies', NULL);
GO
INSERT INTO Employees VALUES(N'381882', N'Charles', NULL, 'McAhan', N'ITEC', N'Vice-President and Chief Technology Officer', NULL);
GO
INSERT INTO Employees VALUES(N'908047', N'Ann', N'Laura', N'Tenney', N'FINA', N'Cashier', NULL);
GO
INSERT INTO Employees VALUES(N'248842', N'Judith', N'Suzie', N'London', N'EBCM', N'Dean of Commercial, Business, and Economic Studies', NULL);
GO
INSERT INTO Employees VALUES(N'161138', N'Laura', N'Fannie', N'Joansen', N'ADMN', N'Dean of Litterary Studies', NULL);
GO
INSERT INTO Employees VALUES(N'113958', N'Richard', N'Matthew', N'Little', N'ITEC', N'IT Support', NULL);
GO
INSERT INTO Employees VALUES(N'697300', N'Albert', NULL, 'Harney', N'FINA', N'Dean of Financial and Accounting Studies', NULL);
GO
INSERT INTO Employees VALUES(N'308407', N'Fatima', N'Georgia', N'Williams', N'FINA', N'Accountant', NULL);
GO
INSERT INTO Employees VALUES(N'974173', N'Eleanor', N'Virginia', N'Pearlman', N'ITEC', N'Webmaster', NULL);
GO
INSERT INTO Employees VALUES(N'200005', N'Catherine', NULL, 'Lehmann', N'ADMN', N'Intern', NULL);
GO
INSERT INTO Employees VALUES(N'247591', N'Leonid', NULL, 'Hawthorne', N'HGPS', N'Dean of History, Geography, and Political Sciences', NULL);
GO
INSERT INTO Employees VALUES(N'640207', N'Kimberly', N'Carlette', N'Edelman', N'PSOP', N'Dean of Psychology, Sociology, and Philosophy', NULL);
GO
INSERT INTO Employees VALUES(N'942249', N'Martin', N'Andrew', N'Schweinstenman', N'FINA', N'Cashier', NULL);
GO
INSERT INTO Employees VALUES(N'793847', N'Seraphine', N'Angie', N'Roeper', N'MATH', N'Dean of Mathematics and Statistics Studies', NULL);
GO
INSERT INTO Employees VALUES(N'582007', N'Alexander', NULL, 'Nolan', N'CMSC', N'Dean of Computer Sciences and Computer Engineering', NULL);
GO
INSERT INTO Employees VALUES(N'400384', N'Jennifer', NULL, 'Palermo', N'HRMN', N'Dean of Human Resources and Management Studies', NULL);
GO

INSERT INTO Semesters(Semester) VALUES(N'SPRING 2012');
GO
INSERT INTO Semesters(Semester) VALUES(N'SUMMER 2012');
GO
INSERT INTO Semesters(Semester) VALUES(N'FALL 2012');
GO
INSERT INTO Semesters(Semester) VALUES(N'SPRING 2013');
GO
INSERT INTO Semesters(Semester) VALUES(N'SUMMER 2013');
GO
INSERT INTO Semesters(Semester) VALUES(N'FALL 2013');
GO
INSERT INTO Semesters(Semester) VALUES(N'SPRING 2014');
GO
INSERT INTO Semesters(Semester) VALUES(N'SUMMER 2014');
GO
INSERT INTO Semesters(Semester) VALUES(N'FALL 2014');
GO
 
INSERT INTO CourseDeliveryTypes
VALUES(N'F', N'Face-to-Face', N'The course will be taught in a classroom. Consult the schedule to find out how often the class will meet.');
GO
INSERT INTO CourseDeliveryTypes
VALUES(N'L', N'Online', N'The course will de delivered over the Web and other means of remote communications such as video and/or conference call.');
GO
INSERT INTO CourseDeliveryTypes
VALUES(N'H', N'Hybrid', N'The course will be taught face-to-face part-time and online part-time. For example, the teacher and students may meet face-to-face in one 

session and online for the next section. Consult the course schedule or the teacher communicate how the class will be conducted.');
GO
    
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'ADMAS', N'Administration & Auxiliary Services');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'HMNSS', N'Humanities & Social Sciences Building');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'FSOPR', N'Facilities Services & Operations');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'SEAMT', N'Science, Engineering, and Mathematics Building');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'NAASB', N'Natural & Applied Sciences Building');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'PACTR', N'Performing Arts Center');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'PEAHL', N'Physical Education and Health Building');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'LATAC', N'Literatrue & Academic Building');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'SPASC', N'Space Science Center');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'SMALC', N'Sun, Moon, & Life Center');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'LIBRM', N'Libraries & Media Building');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'DSSSS', N'Disability Support Services');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'SECRB', N'Security Building');
GO
INSERT INTO Locations(LocationCode, LocationName) VALUES(N'ONLNE', N'Online');
GO

INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'English', N'161138');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Journalism', N'161138');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Mathematics', N'793847');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Statistics', N'793847');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Finance', N'697300');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Economics', N'908047');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Marketing', N'908047');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Accounting', N'697300');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Human Resource Management', N'400384');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Sociology', N'640207');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Psychology', N'640207');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Gerontology', N'640207');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'History', N'247591');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Geography', N'247591');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Political Science', N'247591');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Emergency Management', N'400384');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Computer Science', N'582007');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Computer Information Systems', N'927486');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Information Systems Management', N'927486');
GO
INSERT INTO UndergraduateMajors(Major, Dean) VALUES(N'Computer Information Technology', N'927486');
GO
  
INSERT INTO Minors(Minor) VALUES(N'English');
GO
INSERT INTO Minors(Minor) VALUES(N'Spanish');
GO
INSERT INTO Minors(Minor) VALUES(N'Finance');
GO
INSERT INTO Minors(Minor) VALUES(N'Forensics');
GO
INSERT INTO Minors(Minor) VALUES(N'Economics');
GO
INSERT INTO Minors(Minor) VALUES(N'Computing');
GO
INSERT INTO Minors(Minor) VALUES(N'Marketing');
GO
INSERT INTO Minors(Minor) VALUES(N'Philosophy');
GO
INSERT INTO Minors(Minor) VALUES(N'Accounting');
GO
INSERT INTO Minors(Minor) VALUES(N'Art History');
GO
INSERT INTO Minors(Minor) VALUES(N'African American Studies');
GO
INSERT INTO Minors(Minor) VALUES(N'Business Administration');
GO
INSERT INTO Minors(Minor) VALUES(N'Criminal Justice');
GO
INSERT INTO Minors(Minor) VALUES(N'Mathematicals');
GO
INSERT INTO Minors(Minor) VALUES(N'Political Science');
GO
INSERT INTO Minors(Minor) VALUES(N'Psychology');
GO
INSERT INTO Minors(Minor) VALUES(N'Sociology');
GO
INSERT INTO Minors(Minor) VALUES(N'Speech Communication');
GO
INSERT INTO Minors(Minor) VALUES(N'Biology');
GO
INSERT INTO Minors(Minor) VALUES(N'Business Supply Chain Management');
GO
INSERT INTO Minors(Minor) VALUES(N'Customer Service Management');
GO
INSERT INTO Minors(Minor) VALUES(N'Communication Studies');
GO
INSERT INTO Minors(Minor) VALUES(N'Gerontology');
GO
INSERT INTO Minors(Minor) VALUES(N'Women''s Studies');
GO

INSERT INTO TeachersStatus
VALUES(N'A', N'Active', N'The teacher is currently available.');
GO
INSERT INTO TeachersStatus
VALUES(N'N', N'Not Available', N'The teacher is not available to teach in the current semester, for any reason.');
GO
INSERT INTO TeachersStatus
VALUES(N'S', N'Suspended', N'The teacher''s teaching ability is currently problematic or under question.');
GO

INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'293800', N'Sarah', N'Annette', N'Corso', N'BS, MA, MS, PhD', N'CMST', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode)
VALUES(N'839228', N'Donna', N'Yoder', N'BA, MA', N'PSOP');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'297004', N'Steven', N'Post', N'BS, MA, MS', N'CMST', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'409286', N'Katalina', N'Gabriella', N'Osorio', N'MA, PhD', N'HGPS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'928007', N'Joseph', N'Layman', N'MA', N'MATH', N'N');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'928377', N'Eric', N'Muldoor', N'BS, MS, PhD', N'ACCT', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'796137', N'Patricia', N'Leslie', N'Brief', N'PhD', N'LNGS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'700800', N'Zachary', N'Philemon', N'Jurgens', N'MS, PhD', N'CMSC', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'397480', N'Maleekha', N'Hinson', N'MA, MS', N'EBCM', N'A');
GO                 
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode)
VALUES(N'203080', N'Ayinda', N'Kaihibu', N'BS, MA, PhD', N'EBCM');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'283048', N'Helene', N'Judith', N'Lansing', N'MA, PhD', N'CMST', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'800704', N'Steve', N'Klaus', N'MS, PhD', N'MATH', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'868400', N'Kimberley', N'Avery', N'BS, MA, MS', N'LNGS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'588030', N'Carmen', N'Jeannette', N'Blake', N'MA, PhD', N'LNGS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'297940', N'Thomas', N'Phillips', N'BS, MS, PhD', N'MATH', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'802604', N'Ellena', N'Annabella', N'Vasquez', N'MA', N'HGPS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'494020', N'Patrick', N'Eichel', N'MS, PhD', N'MATH', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'620966', N'Adienne', N'Justine', N'Wing', N'MA, PhD', N'CMSC', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'297035', N'Stephanie', N'Lopez', N'MS', N'ACCT', N'N');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'697300', N'Albert', N'Harney', N'PhD', N'FINA', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'461739', N'Veronica', N'Bethanie', N'Pitts', N'PhD', N'FINA', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, DepartmentCode, Degrees, TeacherStatusCode)
VALUES(N'428395', N'Joseph', N'Dylan', N'LNGS', N'MS, PhD', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'729380', N'Jay', N'Donald', N'Prince', N'BS, MA, MS', N'FINA', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'520203', N'Anne', N'Wine', N'MS, PhD', N'MATH', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'293804', N'Stephen', N'Martins', N'MA, PhD', N'LNGS', N'N');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'297200', N'Anne', N'Bambous', N'MS', N'FINA', N'S');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'160205', N'Steve', N'Alexander', N'Rosner', N'MA, PhD', N'CMSC', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'592073', N'Rolando', N'Andrews', N'MS, PhD', N'FINA', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'917039', N'Amy', N'Stahl', N'PhD', N'PSOP', N'S');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'640840', N'Maryam', N'Whittaker', N'MA, MS, PhD', N'MATH', N'A');
GO
INSERT INTO Teachers(TeacherNumber, LastName, TeacherStatusCode)
VALUES(N'280385', N'Thomas', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'520830', N'Jay', N'Lewis', N'MA', N'CMST', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'293294', N'Christiana','Lopez', N'PhD', N'HGPS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, TeacherStatusCode)
VALUES(N'203814', N'Jeremy', N'Adolphe', N'Hartfield', N'MS, PhD', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'820796', N'James', N'Leach', N'MD', N'CHBT', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'860384', N'Wendie', N'Walker', N'MS, MA', N'EBCM', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'620390', N'Ann', N'Whoolery', N'MA, PhD', N'HRMN', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, TeacherStatusCode)
VALUES(N'860374', N'Steve', N'Roland', N'Rosner', N'MS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'296305', N'Tony', N'Mullins', N'JD', N'CMST', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'927144', N'Annabelle', N'Coen', N'MS, MS, PhD', N'CMSC', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'283029', N'Donald', N'Fisher', N'MS', N'HGPS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, TeacherStatusCode)
VALUES(N'282642', N'Angelina', N'Hansen', N'MD, PhD', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'229374', N'Luke', N'Herbert', N'Parkinson', N'MA, PhD', N'HGPS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'482685', N'Michael', N'Dooley', N'PhD', N'PSOP', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'339429', N'Lisa', N'Williamson', N'PhD', N'EBCM', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'249382', N'Johanna', N'Possemato', N'PhD', N'HGPS', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'924839', N'Ryan', N'Duck', N'MS', N'ACCT', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, DepartmentCode, TeacherStatusCode)
VALUES(N'629537', N'Krista', N'Cole', N'CMST', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, DepartmentCode)
VALUES(N'572753', N'Paula', N'Suarez', N'HRMN');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, DepartmentCode)
VALUES(N'186935', N'Luisa', N'Vanecek', N'CMST');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'925794', N'Elisabeth', N'Lilie', N'Kirchner', N'PhD', N'PSOP', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, Degrees, DepartmentCode)
VALUES(N'928849', N'Wendy', N'Juliette', N'Huntsmann', N'MS, PhD', N'MATH');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, TeacherStatusCode)
VALUES(N'182038', N'Kathie', N'Elliott', N'MA, PhD', N'S');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, TeacherStatusCode)
VALUES(N'820384', N'Marianne', N'Oslin', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName)
VALUES(N'202080', N'Anne-Marie', N'Monte');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, MiddleName, LastName, TeacherStatusCode)
VALUES(N'828248', N'Megan', N'Julie', N'Williams', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'797229', N'Wesley', N'Schaeublum', N'BS, MS, PhD', N'CMSC', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, DepartmentCode, TeacherStatusCode)
VALUES(N'847025', N'Krysta', N'Humpfries', N'FINA', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, TeacherStatusCode)
VALUES(N'857374', N'Kathya', N'Chen', N'N');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, DepartmentCode, TeacherStatusCode)
VALUES(N'692247', N'Ginger', N'Welessley', N'CMST', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, TeacherStatusCode)
VALUES(N'377468', N'Michael', N'Olney', N'PhD', N'A');
GO
INSERT INTO Teachers(TeacherNumber, FirstName, LastName, Degrees, DepartmentCode, TeacherStatusCode)
VALUES(N'516624', N'Santina', N'Mathis', N'PhD', N'CMSC', N'A');
GO

INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BEHS 220', N'Diversity Awareness', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BEHS 365', N'Individuals, Society and Environmental Sustainability', 3);
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BMGT 304', N'Managing E-Commerce in Organizations', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BMGT 312', N'Women in Business', 3);
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BMGT 110', N'Introduction to Business and Management', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ENGL 101', N'Academic Writing', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'SPCH 101', N'Introduction to Oral Communication', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'SPCH 122', N'Introduction to Interpersonal Communication', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 101', N'Introduction to History and Historical Research', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 102', N'Introduction to Archaeology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 103', N'Introduction to Middle East', 3, N'HIST 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 104', N'Pre-Modern Japan', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 107', N'Introduction to Latin American and Latino Studies', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 108', N'Colonial Latin America', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 112', N'Modern Japanese History', 3, N'HIST 104');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 120', N'Introduction to Religions', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 121', N'Introduction to Christianity', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 122', N'Introduction to Judaism', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 123', N'Introduction to Islamic Studies', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 204', N'History of the Modern Business Corporation', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 215', N'World History I', 3, N'HIST 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 216', N'World History II', 3, N'HIST 215');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 302', N'Principles of War', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 311', N'History of Globalization', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 321', N'World War I', 3, N'HIST 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 322', N'World War II', 3, N'HIST 322');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 323', N'Rise and Fall of the Third Reich', 3, N'HIST 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 326', N'The Cold War', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 331', N'Christian Reformation', 3, N'HIST 121');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 342', N'Slavery, Race, & Revolution in the Atlantic World', 3, N'HIST 

101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 351', N'Late Imperial China', 3, N'HIST 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 352', N'History of Modern China', 3, N'HIST 351');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HIST 412', N'Human Rights and History', 3, N'HIST 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 414', N'Comparative History of Genocide', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HIST 415', N'Comparative History of Terrorism', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 101', N'Introduction to Geography', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 102', N'History and Development of Maps', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 112', N'Causes and Implications of Global Change', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 120', N'Introduction to Methods of Geospatial Intelligence and Analysis', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 200', N'Introduction to Human Geography', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 201', N'Introduction to Human Geography Laboratory', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 220', N'Quantitative Methods for the Geographic Environmental Sciences', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 230', N'Introduction to Biogeography', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 240', N'Introductory topics on Regional Geography', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 241', N'Coastal Regions', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 242', N'The Deserts', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 243', N'Human Migrations', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 244', N'Arctic Regional Geography', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 251', N'Regional Geography: North Africa', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 252', N'Regional Geography: Austral Africa', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 253', N'Regional Geography: Western Europe', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 254', N'Regional Geography: North Canada and Alaska', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 255', N'Regional Geography: North America', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 256', N'Regional Geography: China', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 257', N'Regional Geography: The Middle East', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 310', N'Geographic Information Systems', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 340', N'Introduction to Computer Programming for GIS', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 400', N'Advanced Topics on Climat', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 401', N'Land Use, Climate Change, and Sustainability', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 410', N'Climatology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GEOG 460', N'Geographic Information Systems and Spatial Analysis', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SPCH 200', N'Advanced Public Speaking', 3, N'SPCH 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SPCH 426', N'Conflict Management', 3, N'SPCH 122');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SPCH 468', N'Intercultural Communication', 3, N'SPCH 122');
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 105', N'Introduction to Rhetoric', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 154', N'English Romantic Literature', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 155', N'The Bible as Litterature', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 240', N'Introduction to Fiction, Poetry, and Drama', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 245', N'Introduction to Film and Culture', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 260', N'The English Language', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 302', N'Critical Methods of English Literature ', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 305', N'African American Literature', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 352', N'Intermediate Fiction', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 353', N'Advanced English Composition', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 362', N'Caribbean Literature in English', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 385', N'Concepts of Grammar', 3, N'ENGL 260, ENGL 352');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'ENGL 402', N'Modern Drama', 3, N'The student will be required to attended 

three plays and write forty pages of dramatic literature.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'ENGL 403', N'Advanced Poetry', 3, N'The student will be required to write 

20 original pieces of poetry.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'ENGL 404', N'Advanced Fiction', 3, N'The student will be required to write 

a forty-page original fiction.');
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 102', N'Introduction to Mass Communication', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 103', N'Introduction to Multimedia in Communication', 3, N'JRNL 102');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 202', N'News Writing and Reporting I', 3, N'SPCH 101, JRNL 102');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 212', N'Online Journalism', 3, N'JRNL 102');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 302', N'News Writing and Reporting II', 3, N'SPCH 101, JRNL 202');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 205', N'Introduction to News Editing', 3, N'JRNL 202');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 300', N'Journalism Ethics', 3, N'JRNL 202');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 305', N'Advanced News Editing', 3, N'JRNL 205');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 312', N'News Commentary and Critical Writing', 3, N'JRNL 102');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 341', N'Broadcast News Management', 3, N'JRNL 300');
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MATH 009', N'Introduction to Algebra', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 012', N'Intermediate Algebra', 3, N'MATH 009');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 102', N'Finite Mathematics', 3, N'MATH 012');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 103', N'College Algebra', 3, N'MATH 012');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 115', N'Pre-Calculus', 3, N'MATH 012');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 130', N'Calculus for the Life Sciences', 3, N'MATH 115');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 140', N'Calculus I', 3, N'MATH 115');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 141', N'Calculus II', 3, N'MATH 140');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 212', N'Elements of Numbers and Operations', 3, N'MATH 012');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 213', N'Elements of Geometry and Measurement', 3, N'MATH 140');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 214', N'Elements of Probability and Statistics', 3, N'MATH 012');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 220', N'Introduction to Linear Algebra', 4, N'MATH 103');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 241', N'Calculus III', 4, N'MATH 141');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MATH 246', N'Differential Equations for Scientists and Engineers', 4, N'MATH 

241');
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 101', N'Introduction to Statistics', 3, N'MATH 103');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'STAT 110', N'Introduction to Probability', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 200', N'Introduction to Business Statistics', 3, N'MATH 103');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 201', N'Intermediate Statistics', 3, N'STAT 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 202', N'Statistical Methodology', 3, N'STAT 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 203', N'Introduction to Linear Statistical Models', 3, N'MATH 103, STAT 

101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 225', N'Introduction to Statistical Methods for the Behavioral Sciences', 

3, N'MATH 103');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 322', N'Mathematical Statistics', 3, N'STAT 101, STAT 110');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 330', N'Introduction to Nonparametric Methods and Log-linear Models', 3, 

N'STAT 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 425', N'Statistical Inference', 3, N'STAT 110');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 428', N'Stochastic Processes', 3, N'STAT 110');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 429', N'Stochastic Modeling', 3, N'STAT 110');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 431', N'Financial and Economic Time Series', 3, N'STAT 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 441', N'Fundamentals of Actuarial Science I', 3, N'MATH 103');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 442', N'Fundamentals of Actuarial Science II', 3, N'STAT 441');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 443', N'Actuarial Science', 3, N'MATH 140, STAT 441');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 444', N'Advanced Topics in Mathematical Statistics', 3, N'STAT 202');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 450', N'Bioinformatics', 3, N'STAT 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'STAT 452', N'Modern Regression for the Social and Environmental Sciences', 3, 

N'STAT 200');
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'FINA 101', N'Introduction to Money, Currency, and Finance', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'FINA 102', N'Introduction to Business Finance', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'FINA 104', N'Foundations of Investment Management', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 200', N'Behavioral Finance', 3, N'FINA 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 201', N'Financial Economics', 3, N'FINA 101, ECON 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 202', N'Financial Derivatives', 3, N'FINA 104, STAT 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 204', N'Advanced Corporate Finance', 3, N'FINA 104');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 205', N'Urban Real Estate Economics', 3, N'FINA 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 211', N'International Banking', 3, N'FINA 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 240', N'Venture Capital and the Finance of Innovation', 3, N'FINA 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 241', N'The Finance of Buyouts and Acquisitions', 3, N'FINA 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'FINA 300', N'Fundamentals of Building Wealth', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 301', N'Intermediate Corporate Finance', 3, N'FINA 102');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 303', N'Life and Health Insurance', 3, N'FINA 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 304', N'Financial Institutions', 3, N'ECON 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 320', N'Financial Risk Management', 3, N'FINA 102, ECON 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 321', N'Financial Analysis', 3, N'FINA 301');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 420', N'Security Analysis and Valuation', 3, N'FINA 301');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 422', N'Financial Derivatives and Portfolio Risk Management', 3, N'FINA 

301');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'FINA 412', N'International Corporate Finance', 3, N'FINA 301');
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 101', N'Business Economics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 152', N'Monetary Economics and the Global Economy', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 200', N'Principles of Microeconomics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 201', N'Principles of Macroeconomics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 211', N'Theory of International Economics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ECON 212', N'International Financial Markets', 3, N'ECON 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 260', N'Methods and Tools for Economic Analysis', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 300', N'Intermediate Microeconomic Theory', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 301', N'Intermediate Macroeconomic Theory and Policy', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 312', N'Economic Development', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 313', N'Global Economic Policies', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 314', N'Economic Statistics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 315', N'Financial Markets and the Macroeconomy', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 321', N'Intermediate Microeconomic Analysis', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 322', N'Intermediate Macroeconomic Analysis', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ECON 330', N'Money and Banking', 3, N'FINA 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 400', N'Computer Methods in Economics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 402', N'Macroeconomic Models and Forecasting', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 412', N'Globalization and Capital Markets', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 413', N'Public Finance and Public Policy', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 414', N'Law and Economics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ECON 421', N'Econometrics I', 3, N'ECON 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ECON 422', N'Econometrics II', 3, N'ECON 421');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ECON 444', N'Health Care Economics', 3);
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 101', N'Introduction to Marketing', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 211', N'Introduction to Marketing Research', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'MRKT 240', N'New Product Management', 3, N'MRKT 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'MRKT 251', N'Foundations of Advertising I', 2, 'This is the first part of 

a 4-credit course. In this part, the student will be introduced to the theories and fundamental techniques of advertising.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'MRKT 252', N'Foundations of Advertising II', 2, 'This is the second part 

of a 4-credit course. This part mainly consists of practicing to deliver advertising. The student will be involved in 2 project. First, the student will perform an oral 

advertising, using only spoken words and body language. Second, the student will perform visual adverting using speach, computer application, and any necessary visual 

object. Third, the student will create either a video (TV) commercial or web advertising (to be delivered on a website created by the user. Third, the student will 

participate in a group to create an advertisement.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 254', N'Advertising Management', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 255', N'Models for Marketing Strategy', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 256', N'Brand Management', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 261', N'Advertising, Law, and Ethics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 300', N'Retail Marketing', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 301', N'Electronic Marketing', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 311', N'Selling and Sales Management', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 421', N'Managing Customer Relationships', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'MRKT 422', N'Managing Consumer Behavior', 3);
GO  
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ACCT 220', N'Principles of Accounting I', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 221', N'Principles of Accounting II', 3, N'BMGT 110, ACCT 220');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ACCT 224', N'Accounting Software ', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 310', N'Intermediate Accounting I', 3, N'ACCT 221');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 311', N'Intermediate Accounting II', 3, N'ACCT 310');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ACCT 320', N'Fraud Detection and Deterrence', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 322', N'Accounting in Information Systems I', 3, N'ACCT 220');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 331', N'Income Tax I', 3, N'ACCT 220');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 410', N'Accounting for Government and Not-for-Profit Organizations', 3, 

N'ACCT 220');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 412', N'Professionalism and Ethics in Accounting', 3, N'ACCT 220');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 422', N'Accounting in Information Systems II', 3, N'ACCT 322');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 431', N'Income Tax II', 3, N'ACCT 331');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 432', N'Theory and Practice in Accounting Audit', 3, N'ACCT 310');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 440', N'Advanced Accounting', 3, N'ACCT 311');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 442', N'International  Accounting ', 3, N'ACCT 311');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 443', N'Fraud and Forensic Accounting', 3, N'ACCT 322');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ACCT 451', N'Government Accounting Management', 3, N'ACCT 322');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'ACCT 452', N'Government Auditing in Accounting', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HRMN 300', N'Introduction to Human Resource Management', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HRMN 302', N'Organizational Communication', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HRMN 360', N'Labor Relations', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HRMN 364', N'Conflict Management in Organizations', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HRMN 366', N'Organizational Culture', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HRMN 391', N'Stress Management in the Workplace', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HRMN 393', N'Rewards and Compensation Management ', 3, N'HRMN 300');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HRMN 400', N'Human Resource Management: Issues and Problems', 3, N'HRMN 300');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'HRMN 404', N'Employee Training and Development', 3, N'HRMN 300');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'HRMN 412', N'Employment Law for Business', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'SOCY 100', N'Introduction to Sociology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 311', N'The Individual and Society', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 322', N'Sociology and Gender', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 422', N'Race and Ethnic Relations', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 424', N'Social Movements', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 425', N'Global Conflict, Migrants, and Refugees', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 430', N'Sociology of the Family', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 431', N'Social Structure and Identity', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 433', N'Women in the Military', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 440', N'Sociology of Children', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 441', N'Sociology of Self', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 442', N'Sociology of Education', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 443', N'Sociology of Work', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SOCY 444', N'Sociology of War', 3, N'SOCY 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GERO 100', N'Introduction to Gerontology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GERO 211', N'Psychological Aspects of Aging', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GERO 300', N'Service and Program Management in Gerontology', 3, N'GERO 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GERO 321', N'Health and Aging', 3, N'GERO 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GERO 322', N'Gender and Aging', 3, N'GERO 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GERO 323', N'Health Promotion in Older Adults', 3, N'GERO 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GERO 332', N'Programs, Services, and Policies', 3, N'GERO 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GERO 333', N'Long-Term Care Administration', 3, N'GERO 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GERO 341', N'Management of the Senior Housing Environment', 3, N'GERO 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GERO 402', N'Cross-Cultural Perspectives of Aging', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GERO 411', N'Geriatric Nutrition', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GERO 412', N'Strategic Planning for Retirement', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 100', N'Introduction to Political Science', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 101', N'Introduction to Political Theory', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 105', N'Introduction to Political Systems', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 106', N'Religions and Politics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 201', N'International Political Relations', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 202', N'The United Nations', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 212', N'Non-Government Organizations (NGOs)', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 242', N'Comparative Politics and Government', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 300', N'U.N. Peacekeeping', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GVPT 341', N'Legislative Process and Lobbying Techniques', 3, N'GVPT 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 401', N'21st Century Global Challenges', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'GVPT 402', N'Law, Morality, and War', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GVPT 441', N'State Terrorism', 3, N'GVPT 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GVPT 442', N'Global Terrorism', 3, N'GVPT 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GVPT 445', N'Counterterrorism', 3, N'GVPT 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'GVPT 458', N'Terrorism and Anti-Terrorism', 3, N'GVPT 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 100', N'Introduction to Psychology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 300', N'Research Methods in Psychology', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 302', N'Biological Basis of Behavior', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 310', N'Psychology of Self', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 311', N'Psychology of Happiness', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 312', N'Introduction to of Parenting', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 313', N'Psychology of the Individual and Family', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 320', N'Social Psychology', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 321', N'Sensation and Perception', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 325', N'Psychology of Human Sexuality', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 330', N'Introduction to Traumatic Stress Disorder', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 332', N'nvarchar(max)ry and Cognition', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 340', N'Psychology of Interpersonal Relationships', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 341', N'Theories of Personality', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 342', N'Psychology of Gender', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 344', N'Adulthood and Aging ', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 355', N'Introduction to Black Psychology', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 350', N'Lifespan Development', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 351', N'Child and Adolescent Psychology', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 352', N'Abnormal Psychology', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 353', N'Cross-Cultural Psychology', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 410', N'Introduction to Parapsychology', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 412', N'Introduction to Witchcraft', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PSYC 413', N'Advanced Parapsychology and Witchcraft', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 440', N'Introduction to Counseling Psychology', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 441', N'Psychology of Stress', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 442', N'Introduction to Clinical Psychology', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PSYC 443', N'Positive Psychology', 3, N'PSYC 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'WRTG 101', N'Introduction to Writing', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 102', N'Introduction to Narraives', 3, N'WRTG 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 288', N'Standard English Grammar', 3, N'WRTG 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 292', N'Introduction to Professional Writing', 3, N'WRTG 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 388', N'Advanced Grammar and Style', 3, N'WRTG 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 390', N'Introduction to Technical Writing', 3, N'WRTG 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 392', N'Advanced Technical Writing', 3, N'WRTG 390');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 393', N'Legal Writing', 3, N'WRTG 292');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 490', N'Grant and Proposal Writing', 3, N'WRTG 292');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 491', N'Writing for Government and Public Policies', 3, N'WRTG 292, WRTG 

388');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 492', N'Writing for Science and Technology', 3, N'WRTG 292, WRTG 390');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'WRTG 493', N'Writing for Health Professions', 3, N'WRTG 292, WRTG 390');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'SPCH 321', N'Professional Presentations', 3, N'SPCH 101, WRTG 292');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 490', N'Journalism for Government and Public Policies', 3, N'JRNL 312');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 492', N'Journalism for Science and Technology', 3, N'JRNL 312');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'JRNL 493', N'Journalism for Health Professions', 3, N'JRNL 312');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 294', N'Modern World Drama', 3, N'WRTG 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'ENGL 295', N'Reality and Documentary Television', 3, N'ENGL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'EMGT 300', N'Introduction to Emergency Management', 3, N'WRTG 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'EMGT 301', N'Emergency Response Preparedness and Planning', 3, N'EMGT 300');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'EMGT 302', N'The Business of Emergency Management', 3, N'EMGT 300');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'EMGT 304', N'Political and Policy Issues in Emergency Management', 3, N'EMGT 

300');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'EMGT 310', N'Social Dimensions of Disasters', 3, N'EMGT 301');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'EMGT 312', N'Terrorism Issues in Emergency Management', 3, N'EMGT 301');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'IFSM 200', N'Introduction to Information Systems', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'IFSM 201', N'Applications of Information Technology', 3, N'IFSM 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'IFSM 220', N'Information Systems in the Enterprise', 3, N'IFSM 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'IFSM 300', N'Introduction to Information Security', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'IFSM 311', N'Ethics and Policies in Information Technology', 3, N'IFSM 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'IFSM 321', N'Enterprise Architecture and Systems', 3, N'IFSM 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'IFSM 411', N'Planning and Assessing Needs in Information Security', 3, N'IFSM 

200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'IFSM 412', N'Information Systems Project Management', 3, N'IFSM 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'IFSM 450', N'Systems Analysis and Design', 3, N'IFSM 311');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 101', N'Introduction to Information Systems', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 102', N'Computer Organization and Design', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 103', N'Introduction to Problem Solving and Algorithm Design', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'CMIS 110', N'Introduction to Web Design', 3, N'This should be the first 

course for those who choose to pursue a Bachelor''s Degree program in web development.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'CMIS 121', N'Introduction to Desktop Relational Databases', 3, N'This is a 

course for students who want to develop client/server databases. The course gives a broad overview of various available database environments, including Microsoft 

Access, Oracle, Microsoft SQL Server, and MySQL. Students will learn to create tables, sort records, filter lists, and generate reports.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'CMIS 122', N'Introduction to Web-Database Applications', 3, N'This course 

is for students who want to develop web-based database applications. The course gives a broad overview of various available database environments, including Microsoft 

Access, Oracle, Microsoft SQL Server, and MySQL. Students will learn to create tables and views, sort records, filter lists, and generate reports.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 131', N'Social Networking', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 132', N'Web Publishing, Behaviors, and Ethics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIS 160', N'Introduction to XML', 3, N'CMIS 102');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'CMIS 200', N'Introduction to Programming', 3, N'This is a general course 

in programming with comparative studies of C#, Java, Visual Basic, JavaScript, PHP, Perl, etc. The student will be required to write in programming in two languages. 

This course should be selected only for students not familiar with programming languages or who cannot choose which ones to pursue.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 201', N'Introduction to Scripting Languages', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 205', N'Introduction to Ruby on Rails', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites, Notes) VALUES(N'CMIS 210', N'Foundations of Web-Based Application Development', 3, 

N'CMIS 110, CMIS 200', N'In this course, the student is introduced to web programming en general, using JavaScript, PHP, ASP, ASP.NET, and Perl.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites, Notes) VALUES(N'CMIS 221', N'Creating Microsoft SQL Server Databases', 3, N'CMIS 121', 

N'This is the second course for students who create client/server databases. Students must have a (strong) background in desktop databases. Using Microsoft SQL Server, 

students will create stored functions, stored procedures, triggers, and transactions.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites, Notes) VALUES(N'CMIS 222', N'Creating Oracle Databases', 3, N'CMIS 122', N'This is the 

second course for students who create client/server databases. Students must have a (strong) background in desktop databases. Using Oracle, students will create stored 

functions, stored procedures, triggers, and transactions.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIS 241', N'Web-Based Database Applications Using Microsoft SQL Server', 3, 

N'CMIS 121');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIS 242', N'Web-Based Database Applications Using Oracle', 3, N'CMIS 122');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 243', N'Introduction to Web Hosting', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIS 311', N'Web Development and Graphics', 3, N'CMIS 220');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, CourseDescription) VALUES(N'CMIS 421', N'Enterprise Database Development Using Microsoft SQL Server', 

3, N'In this course, students learn to create users, insure connectivity, and manage permissions.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIS 422', N'Enterprise Database Development Using Oracle', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIS 443', N'Advanced Web Hosting', 3, N'CMIS 243');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIS 460', N'Programming Web Services', 3, N'CMIS 220');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 101', N'Introduction to Biology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Notes) VALUES(N'BIOL 102', N'Laboratory in Biology', 1, 'This course accompanies BIOL 101. Although 

this course is optional, it cannot be taken by itself, only concurrently with BIOL 101 or following it.');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 121', N'Human Biology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 122', N'Oceanic Biology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 150', N'Introduction to Genetics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 151', N'Human Genetics', 3, N'BIOL 121');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 160', N'Introduction to Aging', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 215', N'Biology of Human Diseases', 3, N'BIOL 121');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 216', N'Bacteria, Viruses, and Health', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 300', N'Introduction to the Cancer', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 304', N'Cellular Biology and Biochemistry', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 310', N'Introduction to Vertebrate Physiology', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 312', N'Molecular Biology and Genetics', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 313', N'Animal Behavior', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 320', N'Introduction to Forensic Biology', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 324', N'Bioethics', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 330', N'Introduction to Epidemiology', 1);
GO
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 340', N'Introduction to Molecular and Cellular Biology', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 344', N'Bioinformatics', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 350', N'Foundations of Neurobiology', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 360', N'Foundations of Microbiology', 3, N'BIOL 101');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 380', N'Foundations of Epidemiology', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 390', N'Foundations of Immunobiology.', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 351', N'Nutrition in Cancer and Heart Disease', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 352', N'Bacteria, Fungi, and Fermentation', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 353', N'Pesticides and the Environment', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 354', N'Killer Viruses', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 355', N'Evolution', 1);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'BIOL 404', N'Biology of Infectious Diseases', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'BIOL 422', N'Molecular and Cellular Neurobiology', 3, N'BIOL 350');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 101', N'Introduction to Computer Architecture', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 102', N'Introduction to Desktop Operating Systems', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 104', N'Introduction to Windows Desktop Operating Systems', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 105', N'Introduction to UNIX and Linux', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 106', N'Introduction to Computer Networks', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 140', N'Introduction to Servers', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 200', N'Introduction to Computer Troubleshooting', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 201', N'Maintaining Windows Desktop Operating Systems', 3, N'CMIT 105');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 242', N'Fundamentals of Windows Server Administration', 3, N'CMIT 105');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 310', N'Introduction to Computer Network Security', 3, N'CMIT 105');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 311', N'Introduction to Digital Forensics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 312', N'Ethical Hacking', 3, N'CMIT 105');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 320', N'Linux Network Infrastructure', 3, N'CMIT 102');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 321', N'Linux System Administration', 3, N'CMIT 102');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 340', N'Windows Network Infrastructure', 3, N'CMIT 242');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 342', N'Windows Network Administration', 3, N'CMIT 242');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 343', N'Windows Directory Services Infrastructure', 3, N'CMIT 242');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 344', N'Windows Server Application Infrastructure', 3, N'CMIT 242');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 360', N'Designing Cisco Networks', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMIT 361', N'Interconnecting Cisco Devices', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 410', N'Advanced Information System Security', 3, N'CMIT 310');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 411', N'Advanced Digital Forensics', 3, N'CMIT 311');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'CMIT 422', N'Windows Server Enterprise Administration', 3, N'CMIT 242');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 101', N'Introduction to Computer Programming With C++', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 102', N'Introduction to Computer Programming With Java', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 103', N'Introduction to Computer Programming With C#', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 104', N'Introduction to Computer Programming With Visual Basic', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 140', N'Introduction to Discrete Structures', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 206', N'Smart Phone Application Development', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 220', N'Introduction to Game Development', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 236', N'Foundations of Embedded Systems', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 322', N'Advanced Game Design and Development', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 320', N'Introduction to Computer Graphics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 330', N'Advanced Programming Languages', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 332', N'Object-Oriented and Concurrent Programming', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 334', N'Data Structures and Analysis', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 360', N'Foundations of Artificial Intelligence', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 400', N'Foundations of Human Language Technology', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 420', N'Advanced Computer Graphics', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 422', N'Image and Signal Processing', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'CMSC 440', N'Compilers and Interpreters', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PHIL 100', N'Introduction to Philosophy', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PHIL 110', N'Introduction to Religions', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PHIL 140', N'Introduction to Social Contracts', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PHIL 160', N'Introduction to Reasoning', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PHIL 142', N'The Business of Family and Gender', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PHIL 144', N'Contemporary Moral Issues', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PHIL 200', N'Introduction to Ethics', 3, N'PHIL 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits) VALUES(N'PHIL 210', N'Introduction to Philosophy of Mind', 3);
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PHIL 216', N'Strategic Reasoning', 3, N'PHIL 160');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PHIL 218', N'Practical Reasoning', 3, N'PHIL 160');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PHIL 240', N'Fairness & Justice', 3, N'PHIL 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PHIL 312', N'Ethical Issues in Business', 3, N'ECON 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PHIL 314', N'Ethics and the Professions', 3, N'ECON 200');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PHIL 315', N'Justice, Law, & Morality', 3, N'PHIL 100');
GO
INSERT INTO UndergraduateCourses(CourseCode, CourseName, Credits, Prerequisites) VALUES(N'PHIL 410', N'Biological Philosophy', 3, N'PHIL 160');
GO

INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'293800', N'CMIT 410');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'293800', N'CMIT 411');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'293800', N'IFSM 300');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'293800', N'IFSM 311');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 240');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 245');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 260');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 302');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 352');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 353');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 362');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 385');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 402');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 403');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'588030', N'ENGL 404');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'796137', N'ENGL 101');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'796137', N'SPCH 101');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'796137', N'SPCH 122');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'796137', N'ENGL 105');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'796137', N'ENGL 105');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'796137', N'ENGL 154');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'796137', N'ENGL 155');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'796137', N'BMGT 110');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'FINA 101');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'FINA 102');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'FINA 104');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'ECON 101');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'FINA 200');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'FINA 202');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'FINA 204');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'FINA 205');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'729380', N'FINA 211');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'297200', N'FINA 240');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'297200', N'FINA 241');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'297200', N'FINA 300');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'297200', N'FINA 301');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'297200', N'FINA 303');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'297200', N'FINA 304');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'592073', N'FINA 320');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'592073', N'FINA 321');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'592073', N'FINA 420');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'592073', N'FINA 422');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'592073', N'FINA 412');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'397480', N'ECON 101');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'397480', N'ECON 152');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'397480', N'ECON 200');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'397480', N'ECON 201');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'397480', N'ECON 211');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'397480', N'ECON 212');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'397480', N'ECON 260');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 300');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 301');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 312');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 313');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 314');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 315');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 321');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 322');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'860384', N'ECON 330');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'203080', N'ECON 400');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'203080', N'ECON 402');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'203080', N'ECON 412');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'203080', N'ECON 413');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'203080', N'ECON 414');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'203080', N'ECON 421');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'203080', N'ECON 422');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'203080', N'ECON 444');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'520203', N'MATH 009');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'928007', N'MATH 012');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'800704', N'MATH 102');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'520203', N'MATH 103');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'520203', N'MATH 115');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'520203', N'MATH 130');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'640840', N'MATH 140');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'640840', N'MATH 141');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'640840', N'MATH 212');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'640840', N'MATH 213');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'800704', N'MATH 214');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'640840', N'MATH 220');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'800704', N'MATH 241');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'800704', N'MATH 246');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 101');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 103');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 104');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 220');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 101');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 102');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 140');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 220');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 330');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'927144', N'CMSC 206');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'927144', N'CMSC 236');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'797229', N'CMSC 322');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'797229', N'CMSC 140');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'516624', N'CMSC 332');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'516624', N'CMSC 320');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'516624', N'CMSC 236');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'927144', N'CMSC 334');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'797229', N'CMSC 360');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'160205', N'CMSC 206');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'516624', N'CMSC 400');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'927144', N'CMSC 420');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'516624', N'CMSC 440');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'797229', N'CMSC 422');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'229374', N'HIST 302');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'229374', N'HIST 326');
GO
INSERT INTO UndergraduateCoursesTaught(TeacherNumber, CourseCode) VALUES(N'229374', N'GVPT 442');
GO

INSERT INTO UndergraduateStudents VALUES(N'88130480', N'Marie', N'Annette', N'Robinson', 1003, 1003, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'24795711', N'Roger', N'Dermot', N'Baker', 1005, 1002, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'18073572', N'Patrick', NULL, 'Wisne', 1001, 1010, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'97394285', N'Jessica', N'Danielle', N'Shepard', 1007, 1001, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'94708257', N'Christopher', N'Sheldon', N'Jones', 1002, 1005, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'48009520', N'Diane', NULL, 'Rossi', 1006, 1009, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'29480759', N'Maxwell', N'Peter', N'Carlson', 1007, 1007, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'72938479', N'Marc', N'Kenny', N'Dickson', 1009, 1005, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'61824668', N'Stephen', N'David', N'Kramer', 1006, 1002, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'27582647', N'Kimberly', N'Julie', N'Wise', 1008, 1013, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'92847957', N'Emmanuel', NULL, 'Orenstein', 1007, 1001, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'24928472', N'Albert', N'Kevin', N'Thorne', 1002, 1006, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'27114857', N'Michael', N'Alexander', N'Horns', 1001, 1005, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'71513159', N'Berthe', N'Henriette', N'Essimbi', 1003, 1001, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'28374957', N'Billie', N'Judith', N'Cannon', 1006, 1008, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'82580947', N'Steve', N'Bruce', N'Maxwell', 1002, 1004, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'20409220', N'Jasmine', NULL, 'Campino', 1010, 1005, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'92584668', N'Jeoseph', N'David', N'Callahan', 1007, 1009, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'79272413', N'Steve', N'Alan', N'Philbrick', 1011, 1015, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'20488400', N'Joseph', NULL, 'Beal', 1004, 1006, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'20204862', N'James', NULL, 'Kennan', 1006, 1006, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'93749524', N'Helene', NULL, 'Lansing', 1008, 1016, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'50247294', N'Joy', NULL, 'Donovan', 1012, 1007, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'25850859', N'Santiana', NULL, 'Berger', 1009, 1020, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'28435984', N'Robyne', NULL, 'Reeds', 1004, 1017, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'29337594', N'Khalla', NULL, 'Sinyi', 1001, 1018, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'38500685', N'Jeremy', NULL, 'Dolan', 1006, 1010, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'53397060', N'Felicia', NULL, 'Worries', 1011, 1001, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'38050586', N'Amanda', NULL, 'Campbell', 1003, 1001, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'40680688', N'Erik', NULL, 'Carr', 1002, 1017, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'42085008', N'Horace', NULL, 'Rayne', 1005, 1011, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'20940058', N'Colleen', NULL, 'Taylor', 1002, 1015, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'80692826', N'Joanne', NULL, 'Mott', 1002, 1013, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'80608060', N'Annette', NULL, 'Roberts', 1007, 1002, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'80759711', N'Evelyne', NULL, 'Keeling', 1005, 1019, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'75806977', N'Hector', NULL, 'Chiarelli', 1009, 1002, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'81518608', N'Marc', NULL, 'Contreras', 1010, 1001, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'70860811', N'Martin', NULL, 'Gilbreath', 1013, 1009, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'24757420', N'Douglas', NULL, 'Krasnopolky', 1012, 1004, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'35869500', N'David', NULL, 'Kearney', 1016, 1001, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'29408600', N'Emmanuel', NULL, 'Graney', 1010, 1002, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'49575137', N'Keith', NULL, 'Boxley', 1014, 1007, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'80848600', N'Luis', NULL, 'Velker', 1016, 1004, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'92741355', N'Heather', NULL, 'Cullen', 1020, 1011, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'27495006', N'Marcus', NULL, 'Emery', 1016, 1005, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'17724035', N'Lucas', NULL, 'Frieddle', 1006, 1014, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'17749608', N'Nicholas', NULL, 'Hartley,', 1011, 1005, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'50183209', N'Rose', NULL, 'Welborne', 1003, 1018, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'22499506', N'Lucie', NULL, 'Kearns', 1012, 1002, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'40255048', N'Kathleen', NULL, 'Chin', 1015, 1006, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'35850845', N'Wanda', NULL, 'Dundon', 1017, 1008, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'50284085', N'Richard', NULL, 'Domenici', 1015, 1002, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'40380046', N'Simon', NULL, 'Micheals', 1017, 1005, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'40406858', N'Dorrin', NULL, 'Vive', 1018, 1003,  NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'70850607', N'Scott', NULL, 'Krantz', 1007, 1005, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'60284035', N'Mark', NULL, 'Eliasson', 1005, 1015, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'37973594', N'Ezechiel', NULL, 'Gentries', 1019, 1013, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'82855824', N'Katherine', NULL, 'Ward', 1017, 1006, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'49794883', N'Kenneth', NULL, 'Chaney', 1013, 1006, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'20840586', N'Peter', NULL, 'Walden', 1004, 1017, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'92747957', N'David', NULL, 'Cost', 1020, 1009, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'20804685', N'Edward', NULL, 'Pomerantz', 1001, 1013, NULL);
GO
INSERT INTO UndergraduateStudents VALUES(N'22285225', N'Marc', NULL, 'Hawksworth', 1009, 1004, NULL);  
GO

INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 160205, 'CMSC 101', N'F', N'SEAMT', N'402');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'M-W', 160205, 'CMSC 104', N'F', N'SEAMT', N'402');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 160205, 'CMSC 101', N'F', N'SEAMT', N'402');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'11:10', N'M-W', 229374, 283029, 'HIST 101', N'F', N'HMNSS', N'105');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 229374, 283029, 'HIST 101', N'F', N'HMNSS', N'105');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 229374, 283029, 'HIST 101', N'F', N'HMNSS', N'105');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'M-W', 229374, 283029, 'GEOG 120', N'F', N'HMNSS', N'103');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'T-H', 293294, 280385, 'HIST 204', N'F', N'HMNSS', N'103');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'T-H', 229374, 283029, 'HIST 204', N'F', N'HMNSS', N'103');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'T-H', 229374, 283029, 'GVPT 106', N'F', N'HMNSS', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 249382, 'GVPT 100', N'F', N'HMNSS', N'106');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 249382, 'GVPT 100', N'F', N'HMNSS', N'106');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-W', 249382, 'GVPT 202', N'F', N'HMNSS', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'T-H', 249382, 'GVPT 202', N'F', N'HMNSS', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'M-W', 283029, 'GEOG 112', N'F', N'HMNSS', N'217');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-W', 283029, 'GEOG 102', N'F', N'HMNSS', N'217');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'09:15', N'11:10', N'M-W', 283048, 'CMIS 101', N'F', N'SEAMT', N'204');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'11:15', N'12:10', N'T-H', 283048, 'CMIS 101', N'F', N'SEAMT', N'202');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-W', 283048, 'CMIS 131', N'F', N'SEAMT', N'204');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 293294, 'GEOG 244', N'F', N'HMNSS', N'203');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 293294, 'GEOG 244', N'F', N'HMNSS', N'203');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'10:10', N'M-W', 293294, 'GEOG 254', N'F', N'HMNSS', N'203');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'10:10', N'T-H', 293294, 'GEOG 254', N'F', N'HMNSS', N'203');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 293800, 820384, 'CMIS 122', N'F', N'SEAMT', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 293800, 820384, 'CMIS 122', N'F', N'SEAMT', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 293804, NULL, 'ENGL 101', N'F', N'LATAC', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'M-W', 293804, NULL, 'WRTG 102', N'F', N'LATAC', N'204');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 296305, NULL, 'IFSM 311', N'F', N'LATAC', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'T-H', 296305, NULL, 'IFSM 411', N'F', N'LATAC', N'202');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'09:15', N'11:10', N'T-H', 297004, NULL, 'IFSM 200', N'F', N'LATAC', N'201');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-W', 297004, NULL, 'IFSM 321', N'F', N'LATAC', N'203');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 297004, NULL, 'IFSM 201', N'F', N'SEAMT', N'103');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'09:15', N'11:10', N'M-W', 297035, 'ACCT 220', N'F', N'NAASB', N'105');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'09:15', N'11:10', N'T-H', 297035, 'ACCT 221', N'F', N'NAASB', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 820384, 'FINA 101', N'F', N'HMNSS', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'09:10', N'T-H', 820384, 'FINA 104', N'F', N'HMNSS', N'107');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-W', 820384, 'FINA 102', N'F', N'HMNSS', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'T-H', 820384, 'ECON 101', N'F', N'HMNSS', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'09:10', N'T-H', 297940, N'MATH 212', N'F', N'NAASB', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'T-H', 297940, N'MATH 214', N'F', N'NAASB', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'09:10', N'M-T-W-H-F', 339429, 'ECON 312', N'F', N'HMNSS', N'201');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'09:15', N'10:10', N'M-T-W-H-F', 339429, 'ECON 312', N'F', N'HMNSS', N'207');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'14:10', N'M-T-W-H-F', 339429, 'ECON 314', N'F', N'HMNSS', N'201');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 397480, N'ECON 101', N'F', N'HMNSS', N'301');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 397480, N'ECON 152', N'F', N'HMNSS', N'303');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'M-W', 397480, N'BMGT 110', N'F', N'HMNSS', N'301');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'09:10', N'M-T-W-H-F', 409286, 'GVPT 341', N'F', N'HMNSS', N'302');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'09:15', N'10:10', N'M-T-W-H-F', 409286, 'GVPT 402', N'F', N'HMNSS', N'304');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 428395, 'ENGL 155', N'F', N'LATAC', N'201');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-W', 428395, 'WRTG 288', N'F', N'LATAC', N'103');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'09:10', N'M-T-W-H-F', 461739, 'FINA 211', N'F', N'LATAC', N'105');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'M-T-W-H-F', 461739, 'FINA 304', N'F', N'LATAC', N'202');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'09:10', N'M-T-W-H-F', 482685, 'PSYC 300', N'F', N'LATAC', N'107');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'09:15', N'10:10', N'M-T-W-H-F', 482685, 'SOCY 424', N'F', N'LATAC', N'107');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'11:15', N'12:10', N'M-T-W-H-F', 482685, 'PSYC 300', N'F', N'LATAC', N'305');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'11:15', N'12:10', N'M-T-W-H-F', 482685, 'SOCY 424', N'F', N'LATAC', N'303');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/14/2012', N'02/04/2012', N'08:30', N'17:30', N'S', 516624, 'CMSC 101', N'F', N'SPASC', N'110');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-T-W-H-F', 494020, N'MATH 140', N'F', N'NAASB', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'11:15', N'13:10', N'M-T-W-H-F', 494020, N'MATH 141', N'F', N'NAASB', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-T-W-H-F', 494020, N'MATH 241', N'F', N'NAASB', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 520203, N'MATH 213', N'F', N'NAASB', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'15:25', N'17:20', N'T-H', 520203, N'MATH 220', N'F', N'NAASB', N'105');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'1:10', N'M-T-W-H-F', 520203, N'MATH 246', N'F', N'NAASB', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/14/2012', N'02/04/2012', N'08:30', N'17:30', N'S', 520830, N'CMIS 110', N'F', N'SPASC', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'11:30', N'F', 572753, N'HRMN 300', N'F', N'HMNSS', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'17:30', N'F', 572753, N'HRMN 360', N'F', N'HMNSS', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'11:30', N'F', 588030, N'ENGL 302', N'F', N'LATAC', N'305');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'16:30', N'F', 588030, N'ENGL 352', N'F', N'LATAC', N'303');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:30', N'F', 592073, N'FINA 200', N'F', N'LATAC', N'208');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'11:30', N'F', 592073, N'ECON 321', N'F', N'LATAC', N'206');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-T-W-H-F', 620390, N'HRMN 366', N'F', N'HMNSS', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'M-T-W-H-F', 620390, N'HRMN 393', N'F', N'HMNSS', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-T-W-H-F', 620390, N'SPCH 122', N'F', N'LATAC', N'206');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'12:15', N'15:30', N'F', 620966, 'CMSC 102', N'F', N'SPASC', N'110');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'11:30', N'F', 620966, 'CMSC 103', N'F', N'SPASC', N'110');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/14/2012', N'02/04/2012', N'08:30', N'17:30', N'S', 629537, N'CMIS 121', N'F', N'SPASC', N'120');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'M-W', 397480, N'ECON 101', N'F', N'HMNSS', N'301');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'F', 640840, N'MATH 009', N'F', N'LATAC', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'F', 640840, N'MATH 012', N'F', N'LATAC', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'F', 640840, N'MATH 102', N'F', N'LATAC', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/14/2012', N'02/04/2012', N'08:30', N'17:30', N'S', 692247, N'CMIS 121', N'F', N'SPASC', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 697300, N'FINA 201', N'F', N'NAASB', N'107');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 697300, N'FINA 240', N'F', N'HMNSS', N'107');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'T-H', 697300, N'FINA 320', N'F', N'HMNSS', N'107');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 700800, N'MATH 103', N'F', N'LATAC', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 700800, N'MATH 115', N'F', N'LATAC', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'T-H', 700800, N'MATH 103', N'F', N'LATAC', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'M-W', 700800, N'MATH 102', N'F', N'LATAC', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-T-W-H-F', 729380, N'ECON 260', N'F', N'LATAC', N'109');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'M-T-W-H-F', 729380, N'ECON 260', N'F', N'LATAC', N'109');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 796137, N'ENGL 240', N'F', N'SMALC', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 796137, N'ENGL 240', N'F', N'SMALC', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'F', 796137, N'ENGL 404', N'F', N'SMALC', N'305');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'F', 796137, N'ENGL 404', N'F', N'SMALC', N'305');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 797229, 'CMSC 334', N'F', N'SPASC', N'106');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'T-H', 797229, 'CMSC 140', N'F', N'SPASC', N'106');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 800704, 'MATH 130', N'F', N'NAASB', N'106');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'T-H', 800704, 'STAT 101', N'F', N'NAASB', N'106');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-T-W-H-F', 802604, 'HIST 102', N'F', N'SMALC', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'M-T-W-H-F', 802604, 'GVPT 101', N'F', N'SMALC', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'13:25', N'15:20', N'M-T-W-H-F', 802604, 'GEOG 101', N'F', N'SMALC', N'203');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'15:25', N'17:20', N'M-T-W-H-F', 802604, 'GVPT 201', N'F', N'SMALC', N'203');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'T-H', 839228, 'SOCY 100', N'F', N'HMNSS', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'14:25', N'16:20', N'M-W', 839228, 'PSYC 100', N'F', N'HMNSS', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'F', 839228, 'GERO 100', N'F', N'HMNSS', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'02/04/2012', N'08:15', N'10:10', N'T-H', 293804, 'ENGL 101', N'F', N'LATAC', N'102');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 297200, N'FINA 102', N'F', N'HMNSS', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 297200, N'FINA 102', N'F', N'HMNSS', N'101');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'M-W', 297200, N'FINA 104', N'F', N'SMALC', N'404');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'T-H', 297200, N'FINA 104', N'F', N'SMALC', N'404');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'M-W', 847025, 'FINA 300', N'F', N'HMNSS', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'08:15', N'10:10', N'T-H', 847025, 'FINA 300', N'F', N'HMNSS', N'104');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'M-W', 847025, 'FINA 320', N'F', N'SMALC', N'221');
GO
INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, CourseCode, CourseDeliveryTypeCode, LocationCode, 

RoomNumber)
VALUES(101, N'01/09/2012', N'03/18/2012', N'10:15', N'12:10', N'T-H', 847025, 'FINA 320', N'F', N'SMALC', N'221');
GO

--INSERT INTO UndergraduateSchedules(SemesterID, StartDate, EndDate, StartTime, EndTime, Weekdays, TeacherNumber, TANumber, CourseCode, CourseDeliveryTypeCode, 

LocationCode, RoomNumber)
--VALUES(101, N'01/09/2012', N'03/18/2012', N'08:30', N'17:30', N'S', , NULL, , 'F', N'', N'');

INSERT INTO PassesFailsStatus VALUES(N'Passed', N'The student successfully passed the course.');
GO
INSERT INTO PassesFailsStatus VALUES(N'Failed', N'The student did not satisfy the final requirements of the course.');
GO
    
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-12', 24757420, 10062); -- S     08:30 - 17:30
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-16', 17724035, 10075); -- F     10:15 - 12:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-16', 17724035, 10010); -- T-H   10:15 - 12:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-20', 20204862, 10041); -- M-W-F 11:15 - 13:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-20', 20204862, 10017); -- M-W   09:15 - 11:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-20', 24757420, 10102); -- F     08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-20', 24757420, 10103); -- T-H   08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-22', 20840586, 10095); -- T-H   10:15 - 12:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-22', 20840586, 10055); -- S     08:30 - 17:30
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-22', 20940058, 10023); -- M-W-F 08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-24', 20840586, 10042); -- M-W-F 08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-26', 20804685, 10023); -- M-W-F 08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-26', 20804685, 10004); -- M-W   10:15 - 11:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-26', 20804685, 10024); -- M-W-F 13:25 - 15:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-26', 20804685, 10008); -- T-H   08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-27', 20204862, 10048); -- T-H   08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-10-27', 20204862, 10062); -- S     08:30 - 17:30
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-01', 18073572, 10023); -- M-W-F 08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-01', 18073572, 10004); -- M-W   10:15 - 11:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-02', 17724035, 10035); -- T-H   13:25 - 15:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-02', 17724035, 10023); -- M-W-F  8:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-22', 22285225, 10023); -- M-W-F 08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-22', 22285225, 10024); -- M-W-F 13:25 - 15:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-02', 18073572, 10034); -- M-W   14:15 - 16:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-22', 20840586, 10024); -- M-W-F 13:25 - 15:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-22', 20940058, 10100); -- T-H   14:15 - 16:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-11-22', 20940058, 10075); -- F     10:15 - 12:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-02', 20409220, 10035); -- T-H   13:25 - 15:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-04', 20409220, 10100); -- T-H   14:15 - 16:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-12', 20488400, 10095); -- T-H   10:15 - 12:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-12', 20488400, 10062); -- S     08:30 - 17:30
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-12', 20488400, 10023); -- M-W-F  8:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-12', 22285225, 10062); -- S     08:30 - 17:30
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-12', 22499506, 10062); -- S     08:30 - 17:30
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-20', 20940058, 10024); -- M-W-F 13:25 - 15:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-20', 22499506, 10023); -- M-W-F 08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-22', 24795711, 10032); -- M-W   08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2011-12-23', 24795711, 10035); -- T-H   13:25 - 15:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2012-01-02', 17749608, 10101); -- M-W   14:15 - 16:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2012-01-02', 17749608, 10010); -- T-H   10:15 - 12:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2012-01-02', 20488400, 10098); -- M-T-W-H-F 13:25 - 15:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2012-01-04', 17749608, 10005); -- M-W   08:15 - 10:10
GO
INSERT INTO UndergraduateRegistrations(RegistrationDate, StudentNumber, UndergraduateScheduleID) VALUES(N'2012-01-04', 17749608, 10100); -- T-H   14:15 - 16:10
GO