DML SQL Script.sql

Use UniversityModel
Go
/*Inserting Data into University Campus*/

INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('North East Campus','Boston');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('West Campus','Gainsville');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('North Campus','Chicago');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('South Campus','Long Beach');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('Main Campus','Raleigh');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('East West Campus','Buffalo');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('South East Campus','Rochester');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('North West Campus','New York City');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('Sister Campus','Madison');
INSERT INTO UniversityCampus(CampusName,CampusLocation) VALUES('Research Center','Seattle');

/*Inserting Data into Course Offering*/

INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Web Design','Introduction to basics of HTML,CSS and JavaScript',4,'InPerson');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Web Tools and Methods','Introductory course diving into REST API and Java',4,'InPerson');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('UX Design and Testing','Deals with wireframing and testing softwares',4,'Online');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Database Management and Design','Deals with designing databases and running complex queries',4,'Online');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Design Patterns','Introducses to the best practices used by experienced object-oriented software developers',4,'Online');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Datawarehousing and Business Intelligence','Examines the technical and management aspects of building a data warehouse',4,'InPerson');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Data Science Methods and Tools','Introduces the fundamental techniques for machine learning and data science engineering',4,'InPerson');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Application Engineering Development',' Employs the object-oriented paradigm, visual user experience, and system design principles to put together complicated, powerful, real-world applications',4,'Online');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Network Structures and Cloud Computing','focuses on the fundamentals of cloud computing, the principal areas of cloud architectures, cloud security, cloud governance, cloud storage, cloud virtualization and cloud capacity',4,'Online');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Big Data Systems','Offers students an opportunity to learn a hands-on approach to understanding how large-scale data sets are processed and how data science algorithms are adopted in the industry through case studies and labs',4,'InPerson');
INSERT INTO CourseOffering(CourseName,CourseDescription,Credits,CourseType) VALUES('Program Structures and Algorithms','Presents data structures and related algorithms, beginning with a brief review of dynamic memory allocation',4,'InPerson');

/*Inserting data into CourseCatalog*/
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6000,200,'12-12-2020','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6001,201,'12-12-2020','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6002,202,'12-12-2020','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6003,203,'12-12-2020','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6004,204,'12-12-2020','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6005,205,'12-12-2020','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6006,206,'12-12-2020','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6007,207,'11-15-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6008,208,'11-15-2021','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6009,203,'11-15-2021','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6010,204,'11-15-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6002,205,'11-15-2021','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6003,207,'11-15-2021','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6004,208,'11-15-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6005,204,'11-15-2021','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6006,205,'11-15-2021','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6007,206,'11-15-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6008,207,'11-16-2021','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6009,208,'11-17-2021','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6010,208,'11-18-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6010,206,'11-15-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6002,201,'11-15-2021','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6003,202,'11-16-2021','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6004,203,'11-17-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6008,209,'11-18-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6009,200,'11-15-2021','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6010,209,'11-15-2021','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6004,207,'11-16-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6009,209,'11-17-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6010,200,'11-18-2021','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6008,201,'11-15-2021','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6009,202,'11-15-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6010,201,'11-16-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6004,202,'11-17-2021','Summer');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6005,209,'11-18-2021','Fall');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6006,200,'11-15-2021','Spring');
INSERT INTO CourseCatalog(CourseID,CampusID,RevisionDate,AcademicTerm) VALUES(6007,201,'11-15-2021','Spring');


/*DBCC CHECKIDENT ('CourseOffering', RESEED, 6000)*/

/*Inserting data into Section Table*/

INSERT INTO Section([Location]) VALUES('Ell Hall');
INSERT INTO Section([Location]) VALUES('Hayden Hall');
INSERT INTO Section([Location]) VALUES('West Village');
INSERT INTO Section([Location]) VALUES('East Village');
INSERT INTO Section([Location]) VALUES('Dodge Hall');
INSERT INTO Section([Location]) VALUES('Richards Hall');
INSERT INTO Section([Location]) VALUES('Dodge Hall');
INSERT INTO Section([Location]) VALUES('Robinson Hall');
INSERT INTO Section([Location]) VALUES('Churchill Hall');
INSERT INTO Section([Location]) VALUES('Dodge Hall');
INSERT INTO Section([Location]) VALUES('The Fenway');
INSERT INTO Section([Location]) VALUES('Alumni Center');
INSERT INTO Section([Location]) VALUES('Lake Hall');
INSERT INTO Section([Location]) VALUES('Hurtig Hall');
INSERT INTO Section([Location]) VALUES('Holmes Hall');
INSERT INTO Section([Location]) VALUES('Hastings Hall');
INSERT INTO Section([Location]) VALUES('Meserve Hall');
INSERT INTO Section([Location]) VALUES('Shillman Hall');
INSERT INTO Section([Location]) VALUES('Snell Library');
INSERT INTO Section([Location]) VALUES('Forsyth Building');

/*inserting data into Department table*/

INSERT INTO Department(DepartmentName) VALUES('Information Systems');
INSERT INTO Department(DepartmentName) VALUES('Data Analytics Engineering');
INSERT INTO Department(DepartmentName) VALUES('Industrial Engineering');
INSERT INTO Department(DepartmentName) VALUES('Computer Science');
INSERT INTO Department(DepartmentName) VALUES('Software Engineering');
INSERT INTO Department(DepartmentName) VALUES('Law');
INSERT INTO Department(DepartmentName) VALUES('Data Science');
INSERT INTO Department(DepartmentName) VALUES('Information Science');
INSERT INTO Department(DepartmentName) VALUES('Health Informatics');
INSERT INTO Department(DepartmentName) VALUES('Regulatory Laws');
INSERT INTO Department(DepartmentName) VALUES('Bioinformatics');

/*Inserting data into Advisor table*/

INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1000, 'Giovanni Alford');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1000, 'Milana Hagan');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1005, 'Fletcher Barrett');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1005, 'Fariha Redfern');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1006, 'Rahim Contreras');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1007, 'Khalil Hilton');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1007, 'Dione Jefferson');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1006, 'Calum Ellwood');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1008, 'Sinead Coleman');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1009, 'Riaz Baldwin');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1010, 'Laura Richards');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1006, 'Henry Lord');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1008, 'Harry Wes');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1000, 'King Loius');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1005, 'Raymond Nash');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1007, 'John Abraham');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1006, 'Deppak Krishna');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1008, 'Chethan Kumar');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1009, 'Elizabeth Kingston');
INSERT INTO Advisor(DepartmentID, AdvisorName) VALUES(1010, 'Aarti Mehta');


/*Inserting data into Student Table*/
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 118, 'Yui Bi', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 112, 'Yucong Liu', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 105, 'Raj Mehta', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 117, 'Tushar Pagdala', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 104, 'Rucha Chauthani', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 101, 'Rohan Nayak', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 104, 'Kal Mathews', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 120, 'Steph Curry', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 110, 'Derry Kirk', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 116, 'Keon Busby', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 101, 'Manal Allen', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 118, 'Kareem Travers', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 118, 'Olli Mosley', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 101, 'Zoha Ramsey', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 116, 'Rae Partridge', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 107, 'Alexia Beech', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 118, 'Sharon Robbins', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 119, 'Theodore Lovell', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 108, 'Harry Potter', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 105, 'Dom Toretto', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 105, 'James Bond', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 111, 'aadam gilchrist', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 118, 'aadan abati', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 106, 'aadarsh abatiell', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 110, 'aadaya abato', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 116, 'aaden abatti', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 119, 'aadesh abaunza', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 106, 'aadham abaya', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 107, 'aadhan abaza', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 116, 'aadhav abbadessa', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 116, 'aadhavan abbamonte', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 109, 'aadhi abbas', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 114, 'aadhira abbasi', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 101, 'aadhiran abbassi', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 119, 'aadhish abbate', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 104, 'latrica abbatiello', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 116, 'latrice abbay', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 105, 'latricha abbe', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 102, 'latricia abbed', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 113, 'latriece abbenante', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 106, 'latrika abberger', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 112, 'latrina abbey', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 101, 'latrinda abbinanti', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 116, 'latrinia abbington', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 106, 'latrinity abbiss', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 108, 'latris abbitt', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 111, 'latrisa abbot', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 110, 'latrise abbott', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 115, 'latrish abboud', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 119, 'latrisha abbruzzese', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 101, 'latrishia abbs', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 103, 'latrissa abby', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 118, 'latrista abdal', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 115, 'latrivia abdalla', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 107, 'latron abdallah', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 106, 'latronda abdel', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 101, 'latrone abdelal', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 116, 'latronya abdelaziz', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 119, 'latroy abdeldayen', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 114, 'latroya abdelhamid', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 109, 'latroyia abdella', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 120, 'latryce abdelmuti', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 101, 'latsha abdelrahman', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 116, 'latshia abdelwahed', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 118, 'latson abdi', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 112, 'latt abdin', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 104, 'latta abdo', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 103, 'lattarulo abdon', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 120, 'latterll abdool', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 118, 'lattie abdou', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 114, 'lattimer abdul', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 111, 'lattimore abdul-haqq', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 102, 'latton abdul-jabbar', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 115, 'lattonia abdul-khaliq', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 102, 'latty abdul-raqib', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 115, 'latu abdula', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 114, 'latulip abdulaziz', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 105, 'latundra abdulkarim', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 110, 'latunia abdulla', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 103, 'latunja abdullah', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 113, 'latunya abdullai', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 106, 'latusha candela', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 120, 'latvieu candelaria', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 113, 'latvina candelario', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 114, 'latwan candell', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 119, 'latwana candella', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 107, 'latwanda canders', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 101, 'latwanna candia', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 118, 'latwon candido', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 107, 'latya candill', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 120, 'latyia candis', 1);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 113, 'latyna candito', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 113, 'latyra candland', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 119, 'latysha candler', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 106, 'latza candlish', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 109, 'lau candon', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 105, 'lauana candozo', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 117, 'lauar cane', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 119, 'laubacker canedo', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 105, 'lauber canedy', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 106, 'laubert caneer', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 110, 'laubestein canel', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 119, 'laubin canela', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 114, 'lauby caneles', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 101, 'lauchlan canella', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 114, 'lauchlann canellas', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 108, 'lauchlen canelo', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 103, 'lauchlin canepa', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 112, 'lauchlyn canerday', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 107, 'lauchlyn-lee canes', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 109, 'lauchner canestraro', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 116, 'laud canestrini', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 111, 'lauda canestro', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 104, 'laudan canete', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 109, 'lauden jimerson', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 111, 'laudenslager jimeson', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 108, 'lauder jiminez', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 108, 'laudermilk jiminian', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 104, 'laudi jimison', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 119, 'laudie jimmenez', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 109, 'laudine jimmerson', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 101, 'laudny jimmi', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 112, 'lauer jimmison', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 101, 'laufer jin', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 113, 'laufey jina', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 111, 'laughlan jinat', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 113, 'laughlin jindra', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 102, 'laughlin-jay jinenez', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 109, 'laughlyn jines', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 116, 'laughry jing', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 106, 'laughter jingst', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 108, 'laughton jinkens', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 115, 'lauha jinkerson', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 109, 'lauire jinkins', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 116, 'lauklyn jinks', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 119, 'lauma jinnerson', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 117, 'launa jinright', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 119, 'launce jinwright', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 118, 'launcelot jipp', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 101, 'launda jipson', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 114, 'laundes jira', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 110, 'laundyn jirak', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 109, 'launi jiran', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 115, 'launia jirasek', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 120, 'launie jirau', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 119, 'launius jirik', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 117, 'laur jirjis', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 107, 'laura jiro', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 112, 'laura- jiron', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 103, 'laura-ann jirsa', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 111, 'laura-anne jisaan', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 105, 'monali jisan', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 114, 'monalisa jishan', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 113, 'monarrez jishant', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 110, 'monarski jisu', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 109, 'monasha jitander', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 119, 'monasia jitchaku', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 108, 'monast jite', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 102, 'monastersky jitender', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 120, 'monay jitendr', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 118, 'monaya jitendra', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 101, 'monaye jitesh', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 115, 'monbarren jittender', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 110, 'moncada jitu', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 115, 'moncalieri renosky', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 120, 'monce renouf', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 111, 'moncear renova', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 119, 'moncef rens', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 120, 'moncerat rensberger', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 115, 'moncerath rensch', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 103, 'moncerrad renschler', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 107, 'moncerrat rensen', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 116, 'moncerrath renshaw', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 114, 'monchel rensing', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 119, 'monchell renta', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 108, 'monchelle renta-vives', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 119, 'monchello rentar', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 109, 'moncher rentas', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 111, 'moncheri rentas-paniagua', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 115, 'moncia rentas-rivera', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 107, 'moncrief renter', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(3, 110, 'moncrieffe renteria', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 118, 'moncriffe rentfro', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 111, 'moncur rentfrow', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 113, 'moncus rentie', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 118, 'mond renton', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 102, 'monda rentoulis', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 109, 'mondale rentschler', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 120, 'mondarius rentz', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 111, 'mondeja renu', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 108, 'mondel renuart', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 101, 'mondell renuka', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 116, 'mondesir renwick', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 116, 'mondo reny', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 107, 'mondra renye', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 106, 'mondragon renyer', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 113, 'mondre renz', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 105, 'mondrell renze', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 109, 'monds renzelman', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 113, 'mondy renzi', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 111, 'mone renzo', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 113, 'monea renzoni', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 106, 'moneak renzulli', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 112, 'moneca renzullo', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 108, 'monecia reola', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 115, 'monee reome', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 103, 'moneeb reon', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 119, 'moneeba reontae', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 114, 'moneek reopell', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 114, 'moneeka reos', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 106, 'moneer repaci', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 107, 'moneik repasky', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 109, 'raeniyah repass', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 114, 'raenna repenning', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 116, 'raeola reper', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 115, 'raeona repetowski', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 104, 'raeonna reph', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 114, 'raeph repine', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 103, 'raequan repinski', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 115, 'raequawn repka', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 101, 'raequel repke', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 120, 'raequon repko', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 120, 'raeqwan replenski', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 112, 'raeqwon replin', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 116, 'raesean replogle', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 120, 'raesha repoff', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 118, 'raeshaun reposa', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 103, 'raeshawn rigterink', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 101, 'raeshell rigueiro', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 116, 'raeshelle riha', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 109, 'raeshon rihaan', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 117, 'raethaniel rihan', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 107, 'raeto rihana', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 106, 'raetta rihanek', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 114, 'raevan riherd', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 119, 'raeven rihn', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 112, 'raevin rihner', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 110, 'raevon riihimaki', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 111, 'raevyn riina', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 120, 'raevynn riippi', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(6, 120, 'raewyn riis', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 114, 'raey riise', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 108, 'raeya rijakpal', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 103, 'raeyah rijo', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 110, 'sup rijos', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 104, 'suparna riju', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 119, 'supat rijvan', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 105, 'supen rijwan', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 115, 'suphi rijwana', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 111, 'suphiye rikard', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 119, 'suppiah sweety', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 103, 'supple sweezer', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 115, 'supraja sweezey', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 109, 'supreet sweezy', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(14, 119, 'suprena swefford', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 118, 'suprenia sweger', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 119, 'suprina swehla', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 105, 'suprit sweigard', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 109, 'suprith sweigart', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 108, 'supriya sweigert', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 116, 'sura sweis', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 118, 'surabhi sweitzer', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(19, 120, 'surafel sweley', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 105, 'surah swelgart', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 118, 'surai swell', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 109, 'suraiya swelt', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 111, 'suraiyah swem', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 115, 'suraj swenceski', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 101, 'surajbhan tokley', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 118, 'surajmal tokunaga', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 119, 'surajpal tokuoka', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 102, 'suranjan tola', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(9, 104, 'suranne tolan', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 106, 'surat toland', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 117, 'suraya tolar', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(2, 111, 'surayah tolayo', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 105, 'surayya tolbent', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 107, 'surayyah tolbert', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 114, 'surbeck tolchin', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 105, 'surber tolden', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(11, 115, 'surbhi toldness', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(10, 110, 'suree tole', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(18, 103, 'sureena toledano', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 102, 'surekha toledo', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 107, 'suren tolefree', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 111, 'surena tolen', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 114, 'surendar tolentino', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(7, 106, 'surender toler', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(5, 107, 'surendr toles', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(15, 117, 'surendra toleston', 4);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(8, 107, 'surenity tolfree', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 103, 'surens tolhurst', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(12, 119, 'suresh tolin', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 110, 'sureshkumar toline', 2);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(1, 108, 'sureskumar toliongco', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(4, 106, 'sureya toliver', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 116, 'sureyya tolle', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(20, 118, 'surgayani tollefsen', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(13, 102, 'surguine tollefson', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(17, 119, 'surgyan tollefsrud', 3);
INSERT INTO Student(SectionID, AdvisorID, StudentName, Semester) VALUES(16, 119, 'suri toller', 3);


/* Inserting data into Course Registration table*/

INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7407,'Waitlisted', '04-11-2021', 6002, 280);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7963,'Web Registered', '05-05-2021', 6009, 305);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3763,'Web Registered', '04-21-2021', 6009, 306);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1656,'Web Registered', '06-08-2021', 6005, 307);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4181,'Waitlisted', '05-05-2023', 6000, 306);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2837,'Web Registered', '06-06-2021', 6008, 305);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1758,'Web Registered', '06-08-2021', 6008, 307);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3843,'Web Registered', '04-11-2021', 6008, 274);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6409,'Waitlisted', '06-25-2021', 6000, 290);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4524,'Web Registered', '06-11-2021', 6007, 280);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4561,'Dropped', '04-11-2021', 6004, 290);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5112,'Waitlisted', '05-05-2023', 6004, 274);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4555,'Web Registered', '05-05-2021', 6004, 305);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3748,'Web Registered', '06-06-2021', 6009, 274);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4710,'Web Registered', '04-21-2021', 6004, 275);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5160,'Web Registered', '06-06-2021', 6003, 276);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1526,'Waitlisted', '05-05-2021', 6002, 279);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2774,'Web Registered', '06-06-2021', 6009, 290);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5373,'Web Registered', '06-08-2021', 6004, 300);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6224,'Web Registered', '05-05-2021', 6002, 304);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6956,'Waitlisted', '04-11-2021', 6000, 300);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6699,'Waitlisted', '05-16-2021', 6008, 279);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8335,'Waitlisted', '05-05-2023', 6008, 304);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4827,'Web Registered', '06-06-2021', 6003, 275);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4958,'Web Registered', '05-05-2021', 6002, 276);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4247,'Web Registered', '04-21-2021', 6005, 277);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4340,'Dropped', '04-21-2021', 6009, 284);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7789,'Dropped', '04-21-2021', 6004, 285);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4875,'Dropped', '04-21-2021', 6003, 286);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1811,'Dropped', '06-06-2021', 6002, 287);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6870,'Dropped', '05-05-2023', 6007, 294);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2262,'Dropped', '05-05-2021', 6009, 295);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1562,'Dropped', '05-05-2023', 6004, 296);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5425,'Dropped', '06-08-2021', 6002, 297);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1308,'Dropped', '04-11-2021', 6000, 280);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4689,'Web Registered', '05-05-2021', 6000, 275);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2148,'Waitlisted', '05-05-2023', 6000, 276);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1615,'Web Registered', '05-05-2021', 6000, 285);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7921,'Waitlisted', '05-05-2023', 6000, 286);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2149,'Web Registered', '05-05-2021', 6001, 295);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7038,'Waitlisted', '05-05-2023', 6000, 296);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5039,'Web Registered', '06-08-2021', 6000, 277);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5781,'Waitlisted', '05-05-2023', 6000, 284);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5037,'Web Registered', '06-08-2021', 6000, 287);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2820,'Waitlisted', '05-05-2023', 6000, 294);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6297,'Web Registered', '06-08-2021', 6000, 297);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7193,'Waitlisted', '04-11-2021', 6000, 272);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2830,'Waitlisted', '04-11-2021', 6000, 278);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3804,'Web Registered', '06-06-2021', 6000, 281);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7886,'Web Registered', '04-21-2021', 6001, 282);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6170,'Web Registered', '06-06-2021', 6001, 288);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4882,'Web Registered', '04-21-2021', 6001, 289);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5638,'Web Registered', '06-06-2021', 6001, 291);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7954,'Web Registered', '05-05-2021', 6001, 292);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8883,'Web Registered', '06-08-2021', 6000, 298);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3436,'Web Registered', '06-08-2021', 6000, 301);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5198,'Web Registered', '06-08-2021', 6000, 302);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4503,'Waitlisted', '05-05-2021', 6005, 159);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3954,'Waitlisted', '04-11-2021', 6000, 150);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1865,'Web Registered', '06-06-2021', 6000, 153);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2873,'Waitlisted', '04-11-2021', 6000, 160);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7017,'Web Registered', '06-06-2021', 6000, 163);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1086,'Web Registered', '04-21-2021', 6000, 169);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5089,'Waitlisted', '04-11-2021', 6000, 170);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4792,'Web Registered', '06-06-2021', 6000, 173);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2122,'Web Registered', '05-05-2021', 6003, 181);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7213,'Web Registered', '06-06-2021', 6000, 183);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7871,'Waitlisted', '05-05-2023', 6000, 130);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8153,'Web Registered', '06-08-2021', 6000, 133);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7179,'Web Registered', '06-08-2021', 6000, 131);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6942,'Web Registered', '05-05-2021', 6008, 147);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2653,'Waitlisted', '05-05-2023', 6008, 148);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1156,'Web Registered', '06-08-2021', 6008, 151);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2668,'Web Registered', '05-05-2021', 6008, 157);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5501,'Waitlisted', '05-05-2023', 6008, 158);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5741,'Web Registered', '06-08-2021', 6000, 161);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8838,'Web Registered', '05-05-2021', 6000, 167);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5292,'Waitlisted', '05-05-2023', 6000, 168);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1326,'Web Registered', '05-05-2021', 6000, 155);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3871,'Waitlisted', '05-05-2023', 6000, 156);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7448,'Web Registered', '05-05-2021', 6000, 165);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4454,'Waitlisted', '05-05-2023', 6000, 166);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5204,'Web Registered', '04-21-2021', 6000, 259);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1213,'Waitlisted', '04-11-2021', 6000, 132);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4048,'Web Registered', '06-06-2021', 6000, 303);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3810,'Web Registered', '04-21-2021', 6000, 239);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1858,'Web Registered', '05-05-2023', 6002, 259);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2810,'Waitlisted', '05-05-2021', 6005, 283);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8575,'Waitlisted', '06-08-2021', 6005, 383);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8525,'Web Registered', '06-25-2021', 6007, 393);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2147,'Web Registered', '06-06-2021', 6000, 152);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5697,'Web Registered', '04-21-2021', 6000, 154);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3666,'Web Registered', '06-08-2021', 6000, 162);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3542,'Dropped', '05-05-2023', 6000, 164);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8433,'Web Registered', '06-08-2021', 6000, 171);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8070,'Web Registered', '06-08-2021', 6000, 172);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2520,'Web Registered', '05-05-2021', 6000, 174);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1230,'Web Registered', '05-05-2021', 6000, 175);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1533,'Waitlisted', '05-16-2021', 6005, 176);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6454,'Web Registered', '05-05-2021', 6000, 177);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7185,'Web Registered', '05-05-2023', 6002, 178);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2624,'Waitlisted', '06-08-2021', 6005, 179);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2722,'Web Registered', '06-25-2021', 6007, 180);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6014,'Web Registered', '04-21-2021', 6000, 182);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2404,'Web Registered', '04-21-2021', 6000, 184);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6623,'Web Registered', '06-06-2021', 6000, 185);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1791,'Web Registered', '04-21-2021', 6000, 186);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3392,'Web Registered', '06-06-2021', 6003, 187);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2112,'Web Registered', '05-05-2021', 6002, 188);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5546,'Waitlisted', '06-25-2021', 6005, 114);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3189,'Waitlisted', '05-16-2021', 6005, 115);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5104,'Web Registered', '06-11-2021', 6007, 116);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5225,'Web Registered', '06-08-2021', 6000, 299);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8862,'Web Registered', '06-08-2021', 6000, 159);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3699,'Web Registered', '04-21-2021', 6000, 100);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4399,'Waitlisted', '04-11-2021', 6001, 101);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1925,'Web Registered', '05-05-2021', 6003, 100);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1793,'Web Registered', '05-05-2023', 6002, 101);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6834,'Web Registered', '06-06-2021', 6001, 102);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3172,'Waitlisted', '05-05-2021', 6005, 102);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1077,'Waitlisted', '06-08-2021', 6005, 105);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1660,'Web Registered', '06-25-2021', 6007, 106);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1332,'Web Registered', '05-16-2021', 6009, 107);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1693,'Dropped', '06-11-2021', 6004, 108);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4719,'Dropped', '05-05-2021', 6003, 259);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1770,'Dropped', '05-05-2023', 6002, 269);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8151,'Dropped', '05-05-2021', 6005, 130);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1626,'Dropped', '06-08-2021', 6010, 131);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1797,'Dropped', '06-25-2021', 6010, 132);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6194,'Web Registered', '05-16-2021', 6010, 133);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2008,'Web Registered', '06-11-2021', 6010, 149);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8411,'Web Registered', '05-05-2021', 6002, 249);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4536,'Web Registered', '05-05-2023', 6010, 303);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7919,'Waitlisted', '06-08-2021', 6010, 239);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7995,'Web Registered', '06-25-2021', 6010, 249);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4946,'Web Registered', '05-16-2021', 6010, 259);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7876,'Web Registered', '06-11-2021', 6010, 269);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6193,'Web Registered', '05-05-2021', 6010, 283);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8100,'Web Registered', '05-16-2021', 6010, 383);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2822,'Web Registered', '06-11-2021', 6010, 393);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8541,'Web Registered', '05-16-2021', 6010, 147);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6975,'Web Registered', '06-11-2021', 6004, 148);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7915,'Web Registered', '05-05-2021', 6003, 151);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7329,'Web Registered', '05-05-2023', 6002, 152);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5712,'Waitlisted', '05-05-2021', 6005, 154);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8931,'Waitlisted', '06-08-2021', 6005, 155);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1419,'Web Registered', '06-25-2021', 6007, 156);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1582,'Web Registered', '05-16-2021', 6009, 157);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6443,'Web Registered', '06-11-2021', 6004, 158);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4041,'Web Registered', '05-05-2021', 6003, 161);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2613,'Web Registered', '05-05-2023', 6002, 162);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7497,'Waitlisted', '05-05-2021', 6005, 164);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1721,'Waitlisted', '06-08-2021', 6005, 165);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1445,'Web Registered', '06-25-2021', 6007, 166);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3870,'Web Registered', '05-16-2021', 6009, 167);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2211,'Web Registered', '06-11-2021', 6004, 168);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5684,'Web Registered', '05-05-2021', 6003, 171);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1413,'Web Registered', '05-05-2023', 6002, 172);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6966,'Waitlisted', '05-05-2021', 6005, 174);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2486,'Waitlisted', '06-08-2021', 6005, 175);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5974,'Web Registered', '06-25-2021', 6007, 176);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1751,'Web Registered', '05-16-2021', 6009, 177);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2044,'Web Registered', '06-11-2021', 6004, 178);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1834,'Web Registered', '04-21-2021', 6001, 179);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8659,'Waitlisted', '04-11-2021', 6001, 180);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5294,'Web Registered', '05-05-2023', 6002, 182);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1214,'Waitlisted', '05-05-2021', 6005, 184);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3633,'Waitlisted', '06-08-2021', 6005, 185);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8499,'Web Registered', '06-25-2021', 6007, 186);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7562,'Web Registered', '05-16-2021', 6009, 187);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2742,'Web Registered', '06-11-2021', 6004, 188);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5051,'Web Registered', '04-21-2021', 6001, 189);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1232,'Waitlisted', '04-11-2021', 6000, 190);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4864,'Web Registered', '05-05-2021', 6003, 191);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2087,'Web Registered', '05-05-2023', 6002, 192);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5366,'Dropped', '06-06-2021', 6000, 193);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7156,'Dropped', '05-05-2021', 6005, 194);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7380,'Waitlisted', '06-08-2021', 6005, 195);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1280,'Web Registered', '06-25-2021', 6007, 196);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3060,'Web Registered', '05-16-2021', 6009, 197);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6517,'Web Registered', '06-11-2021', 6004, 198);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3121,'Web Registered', '04-21-2021', 6000, 199);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7009,'Waitlisted', '04-11-2021', 6000, 200);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5349,'Web Registered', '05-05-2021', 6003, 201);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2038,'Web Registered', '05-05-2023', 6002, 202);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2428,'Web Registered', '06-06-2021', 6000, 203);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8018,'Waitlisted', '05-05-2021', 6005, 204);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8262,'Waitlisted', '06-08-2021', 6005, 205);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1335,'Web Registered', '06-25-2021', 6007, 206);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4568,'Web Registered', '05-16-2021', 6009, 207);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4897,'Web Registered', '06-11-2021', 6004, 208);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3930,'Web Registered', '04-21-2021', 6000, 209);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7481,'Waitlisted', '04-11-2021', 6000, 210);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3884,'Web Registered', '05-05-2021', 6003, 211);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6786,'Web Registered', '05-05-2023', 6002, 212);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6082,'Web Registered', '06-06-2021', 6000, 213);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6143,'Waitlisted', '05-05-2021', 6005, 214);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3344,'Waitlisted', '06-08-2021', 6005, 215);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3947,'Web Registered', '06-25-2021', 6007, 216);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2391,'Web Registered', '05-16-2021', 6009, 217);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4436,'Web Registered', '06-11-2021', 6004, 218);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4976,'Web Registered', '04-21-2021', 6000, 219);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7829,'Waitlisted', '04-11-2021', 6000, 220);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8267,'Web Registered', '05-05-2021', 6003, 221);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4367,'Web Registered', '05-05-2023', 6002, 222);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4715,'Web Registered', '06-06-2021', 6000, 223);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5232,'Waitlisted', '05-05-2021', 6005, 224);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7286,'Waitlisted', '06-08-2021', 6005, 225);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5630,'Web Registered', '06-25-2021', 6007, 226);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1977,'Web Registered', '05-16-2021', 6009, 227);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3186,'Web Registered', '06-11-2021', 6004, 228);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2792,'Web Registered', '04-21-2021', 6000, 229);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8942,'Waitlisted', '04-11-2021', 6000, 230);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8719,'Web Registered', '05-05-2021', 6003, 231);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5613,'Web Registered', '05-05-2023', 6002, 232);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8523,'Web Registered', '06-06-2021', 6000, 233);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7705,'Waitlisted', '05-05-2021', 6005, 234);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6615,'Waitlisted', '06-08-2021', 6005, 235);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1498,'Web Registered', '06-25-2021', 6007, 236);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1420,'Web Registered', '05-16-2021', 6009, 237);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6522,'Web Registered', '06-11-2021', 6004, 238);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8693,'Waitlisted', '04-11-2021', 6000, 240);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6595,'Web Registered', '05-05-2021', 6003, 241);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4821,'Web Registered', '05-05-2023', 6002, 242);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2293,'Web Registered', '06-06-2021', 6000, 243);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7930,'Waitlisted', '05-05-2021', 6005, 244);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2640,'Waitlisted', '06-08-2021', 6005, 245);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3617,'Web Registered', '06-25-2021', 6007, 246);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4512,'Web Registered', '05-16-2021', 6009, 247);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3233,'Web Registered', '06-11-2021', 6004, 248);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4678,'Waitlisted', '04-11-2021', 6000, 250);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7890,'Web Registered', '05-05-2021', 6003, 251);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8979,'Web Registered', '05-05-2023', 6002, 252);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8264,'Web Registered', '06-06-2021', 6000, 253);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4095,'Waitlisted', '05-05-2021', 6005, 254);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4196,'Waitlisted', '06-08-2021', 6005, 255);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2322,'Web Registered', '06-25-2021', 6007, 256);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8058,'Web Registered', '05-16-2021', 6009, 257);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2881,'Web Registered', '06-11-2021', 6004, 258);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6733,'Waitlisted', '04-11-2021', 6000, 260);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5685,'Web Registered', '05-05-2021', 6003, 261);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2938,'Web Registered', '05-05-2023', 6002, 262);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4543,'Web Registered', '06-06-2021', 6001, 263);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1583,'Waitlisted', '05-05-2021', 6005, 264);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2708,'Waitlisted', '06-08-2021', 6005, 265);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7877,'Web Registered', '06-25-2021', 6007, 266);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5018,'Web Registered', '05-16-2021', 6009, 267);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4338,'Web Registered', '06-11-2021', 6004, 268);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8819,'Waitlisted', '04-11-2021', 6001, 270);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5103,'Web Registered', '05-05-2021', 6003, 271);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3952,'Web Registered', '05-05-2023', 6002, 272);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7492,'Waitlisted', '05-05-2021', 6005, 274);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5002,'Waitlisted', '06-08-2021', 6005, 275);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1234,'Web Registered', '06-25-2021', 6007, 276);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5809,'Web Registered', '05-16-2021', 6009, 277);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1004,'Web Registered', '06-11-2021', 6004, 278);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7261,'Web Registered', '05-05-2021', 6003, 281);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8144,'Web Registered', '05-05-2023', 6002, 282);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1677,'Waitlisted', '05-05-2021', 6005, 284);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1189,'Waitlisted', '06-08-2021', 6005, 285);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6775,'Web Registered', '06-25-2021', 6007, 286);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2091,'Web Registered', '05-16-2021', 6009, 287);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3552,'Web Registered', '06-11-2021', 6004, 288);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1302,'Web Registered', '05-05-2021', 6003, 291);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4750,'Web Registered', '05-05-2023', 6002, 292);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5217,'Waitlisted', '05-05-2021', 6005, 294);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4808,'Waitlisted', '06-08-2021', 6005, 295);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5939,'Web Registered', '06-25-2021', 6007, 296);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3868,'Web Registered', '05-16-2021', 6009, 297);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7739,'Web Registered', '06-11-2021', 6004, 298);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4090,'Web Registered', '05-05-2021', 6003, 301);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2665,'Web Registered', '05-05-2023', 6002, 302);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7172,'Waitlisted', '05-05-2021', 6005, 304);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5870,'Waitlisted', '06-08-2021', 6005, 305);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2539,'Web Registered', '06-25-2021', 6007, 306);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6825,'Web Registered', '05-16-2021', 6009, 307);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3366,'Web Registered', '06-11-2021', 6004, 308);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8989,'Waitlisted', '04-11-2021', 6001, 310);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1939,'Web Registered', '05-05-2021', 6003, 311);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1418,'Web Registered', '05-05-2023', 6002, 312);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7194,'Web Registered', '06-06-2021', 6001, 313);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2634,'Waitlisted', '05-05-2021', 6005, 314);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2829,'Waitlisted', '06-08-2021', 6005, 315);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8497,'Web Registered', '06-25-2021', 6007, 316);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3770,'Web Registered', '05-16-2021', 6009, 317);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5328,'Web Registered', '06-11-2021', 6004, 318);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6558,'Web Registered', '04-21-2021', 6001, 319);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6940,'Waitlisted', '04-11-2021', 6001, 320);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1681,'Web Registered', '05-05-2021', 6003, 321);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2530,'Web Registered', '05-05-2023', 6002, 322);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5119,'Web Registered', '06-06-2021', 6000, 323);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8434,'Waitlisted', '05-05-2021', 6005, 324);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1103,'Waitlisted', '06-08-2021', 6005, 325);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3638,'Web Registered', '06-25-2021', 6007, 326);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7096,'Web Registered', '05-16-2021', 6009, 327);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1538,'Web Registered', '06-11-2021', 6004, 328);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7686,'Web Registered', '04-21-2021', 6000, 329);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2178,'Waitlisted', '04-11-2021', 6000, 330);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1965,'Web Registered', '05-05-2021', 6003, 331);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1407,'Web Registered', '05-05-2023', 6002, 332);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8582,'Web Registered', '06-06-2021', 6000, 333);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8861,'Waitlisted', '05-05-2021', 6005, 334);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4825,'Waitlisted', '06-08-2021', 6005, 335);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8638,'Web Registered', '06-25-2021', 6007, 336);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3158,'Web Registered', '05-16-2021', 6009, 337);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4831,'Web Registered', '06-11-2021', 6004, 338);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5614,'Web Registered', '04-21-2021', 6000, 339);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4563,'Waitlisted', '04-11-2021', 6000, 340);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5619,'Web Registered', '05-05-2021', 6003, 341);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1414,'Web Registered', '05-05-2023', 6002, 342);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1281,'Web Registered', '06-06-2021', 6000, 343);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8049,'Waitlisted', '05-05-2021', 6005, 344);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5947,'Waitlisted', '06-08-2021', 6005, 345);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7381,'Web Registered', '06-25-2021', 6007, 346);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4652,'Web Registered', '05-16-2021', 6009, 347);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2832,'Web Registered', '06-11-2021', 6004, 348);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1026,'Web Registered', '04-21-2021', 6000, 349);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2814,'Waitlisted', '04-11-2021', 6000, 350);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8132,'Web Registered', '05-05-2021', 6003, 351);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5718,'Web Registered', '05-05-2023', 6002, 352);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4076,'Web Registered', '06-06-2021', 6000, 353);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7386,'Waitlisted', '05-05-2021', 6005, 354);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5230,'Waitlisted', '06-08-2021', 6005, 355);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7280,'Web Registered', '06-25-2021', 6007, 356);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1350,'Web Registered', '05-16-2021', 6009, 357);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5430,'Web Registered', '06-11-2021', 6004, 358);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4455,'Web Registered', '04-21-2021', 6000, 359);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1169,'Waitlisted', '04-11-2021', 6000, 360);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3259,'Web Registered', '05-05-2021', 6003, 361);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8549,'Web Registered', '05-05-2023', 6002, 362);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1529,'Web Registered', '06-06-2021', 6000, 363);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8379,'Waitlisted', '05-05-2021', 6005, 364);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4364,'Waitlisted', '06-08-2021', 6005, 365);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1329,'Web Registered', '06-25-2021', 6007, 366);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1739,'Web Registered', '05-16-2021', 6009, 367);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5000,'Web Registered', '06-11-2021', 6004, 368);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1144,'Web Registered', '04-21-2021', 6000, 369);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8343,'Waitlisted', '04-11-2021', 6000, 370);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5474,'Web Registered', '05-05-2021', 6003, 371);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6928,'Web Registered', '05-05-2023', 6002, 372);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1630,'Web Registered', '06-06-2021', 6000, 373);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3755,'Waitlisted', '05-05-2021', 6005, 374);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6057,'Waitlisted', '06-08-2021', 6005, 375);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3495,'Web Registered', '06-25-2021', 6007, 376);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4082,'Web Registered', '05-16-2021', 6009, 377);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3911,'Web Registered', '06-11-2021', 6004, 378);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3112,'Web Registered', '04-21-2021', 6000, 379);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1822,'Waitlisted', '04-11-2021', 6000, 380);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8941,'Web Registered', '05-05-2021', 6003, 381);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8910,'Web Registered', '05-05-2023', 6002, 382);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4975,'Waitlisted', '05-05-2021', 6005, 384);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8067,'Waitlisted', '06-08-2021', 6005, 385);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3918,'Web Registered', '06-25-2021', 6007, 386);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4945,'Web Registered', '05-16-2021', 6009, 387);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8418,'Web Registered', '06-11-2021', 6004, 388);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5824,'Web Registered', '04-21-2021', 6000, 389);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2430,'Waitlisted', '04-11-2021', 6000, 390);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2572,'Web Registered', '05-05-2021', 6003, 391);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2180,'Web Registered', '05-05-2023', 6002, 392);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2210,'Waitlisted', '05-05-2021', 6005, 394);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6830,'Waitlisted', '06-08-2021', 6005, 395);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8759,'Web Registered', '06-25-2021', 6007, 396);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5016,'Web Registered', '05-16-2021', 6009, 397);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4390,'Web Registered', '06-11-2021', 6004, 398);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1262,'Web Registered', '04-21-2021', 6005, 399);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1685,'Waitlisted', '04-11-2021', 6007, 400);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7841,'Web Registered', '04-21-2021', 6009, 117);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6801,'Web Registered', '04-11-2021', 6004, 118);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1820,'Web Registered', '05-05-2021', 6000, 119);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7588,'Waitlisted', '05-05-2023', 6000, 120);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4870,'Web Registered', '06-06-2021', 6003, 121);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6432,'Web Registered', '05-05-2021', 6002, 122);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3598,'Web Registered', '06-08-2021', 6000, 123);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2349,'Waitlisted', '06-25-2021', 6005, 124);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1953,'Waitlisted', '05-16-2021', 6005, 125);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3932,'Web Registered', '06-11-2021', 6007, 126);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4310,'Web Registered', '04-21-2021', 6009, 127);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7278,'Web Registered', '04-11-2021', 6004, 128);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8370,'Web Registered', '06-06-2021', 6003, 131);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4227,'Web Registered', '05-05-2021', 6002, 132);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5436,'Waitlisted', '06-25-2021', 6005, 377);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2643,'Waitlisted', '05-16-2021', 6005, 378);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6072,'Web Registered', '06-11-2021', 6007, 379);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5938,'Web Registered', '04-21-2021', 6009, 380);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7327,'Web Registered', '04-11-2021', 6004, 381);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8367,'Web Registered', '05-05-2021', 6000, 382);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6377,'Web Registered', '06-06-2021', 6003, 384);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6948,'Web Registered', '05-05-2021', 6002, 385);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6282,'Web Registered', '06-08-2021', 6000, 386);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1022,'Waitlisted', '06-25-2021', 6005, 387);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2395,'Waitlisted', '05-16-2021', 6005, 388);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8939,'Web Registered', '06-11-2021', 6007, 389);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1914,'Web Registered', '04-21-2021', 6009, 390);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2805,'Web Registered', '04-11-2021', 6004, 391);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1346,'Web Registered', '05-05-2021', 6000, 392);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2721,'Web Registered', '06-06-2021', 6003, 394);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4307,'Web Registered', '05-05-2021', 6002, 395);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7527,'Web Registered', '06-08-2021', 6000, 396);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2205,'Waitlisted', '06-25-2021', 6005, 397);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2571,'Waitlisted', '05-16-2021', 6005, 398);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2594,'Web Registered', '06-11-2021', 6007, 399);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7427,'Web Registered', '04-21-2021', 6009, 400);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2144,'Web Registered', '04-11-2021', 6004, 234);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8569,'Web Registered', '05-05-2021', 6000, 235);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2145,'Waitlisted', '05-05-2023', 6000, 236);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5401,'Web Registered', '06-06-2021', 6003, 237);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4655,'Web Registered', '05-05-2021', 6002, 238);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3109,'Waitlisted', '06-25-2021', 6005, 240);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6889,'Waitlisted', '05-16-2021', 6005, 241);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1453,'Web Registered', '06-11-2021', 6007, 242);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6085,'Web Registered', '04-21-2021', 6009, 243);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4277,'Web Registered', '04-11-2021', 6004, 244);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5266,'Web Registered', '05-05-2021', 6000, 245);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4927,'Waitlisted', '05-05-2023', 6000, 246);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7848,'Web Registered', '06-06-2021', 6003, 247);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2944,'Web Registered', '05-05-2021', 6002, 248);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2912,'Waitlisted', '06-25-2021', 6005, 250);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2160,'Waitlisted', '05-16-2021', 6005, 251);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3155,'Web Registered', '06-11-2021', 6007, 252);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1999,'Web Registered', '04-21-2021', 6009, 253);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2442,'Web Registered', '04-11-2021', 6004, 254);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3818,'Web Registered', '05-05-2021', 6000, 255);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7204,'Waitlisted', '05-05-2023', 6000, 256);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4427,'Web Registered', '06-06-2021', 6003, 257);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6112,'Web Registered', '05-05-2021', 6002, 258);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4614,'Waitlisted', '06-25-2021', 6005, 260);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8291,'Waitlisted', '05-16-2021', 6005, 261);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6641,'Web Registered', '06-11-2021', 6007, 262);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4684,'Web Registered', '04-21-2021', 6009, 263);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4749,'Web Registered', '04-11-2021', 6004, 264);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3080,'Web Registered', '05-05-2021', 6000, 265);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3955,'Waitlisted', '05-05-2023', 6000, 266);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4373,'Web Registered', '06-06-2021', 6003, 267);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4051,'Web Registered', '05-05-2021', 6002, 268);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7639,'Waitlisted', '06-25-2021', 6005, 270);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6452,'Waitlisted', '05-16-2021', 6005, 271);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1251,'Web Registered', '06-11-2021', 6007, 272);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2976,'Web Registered', '04-21-2021', 6009, 273);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4660,'Web Registered', '06-06-2021', 6003, 277);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3391,'Web Registered', '05-05-2021', 6002, 278);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6149,'Waitlisted', '06-25-2021', 6005, 280);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2554,'Waitlisted', '05-16-2021', 6005, 281);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8194,'Web Registered', '06-11-2021', 6007, 282);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6887,'Web Registered', '04-21-2021', 6009, 283);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5771,'Web Registered', '04-11-2021', 6004, 284);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4866,'Web Registered', '06-06-2021', 6003, 287);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4916,'Web Registered', '05-05-2021', 6002, 288);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8998,'Waitlisted', '05-16-2021', 6005, 291);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4192,'Web Registered', '06-11-2021', 6007, 292);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4978,'Web Registered', '04-21-2021', 6009, 293);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4380,'Web Registered', '04-11-2021', 6004, 294);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4817,'Web Registered', '06-06-2021', 6003, 297);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4406,'Web Registered', '05-05-2021', 6002, 298);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4266,'Waitlisted', '06-25-2021', 6005, 300);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1702,'Waitlisted', '05-16-2021', 6005, 301);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2085,'Web Registered', '06-11-2021', 6007, 302);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7616,'Web Registered', '04-21-2021', 6009, 303);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8948,'Web Registered', '04-11-2021', 6004, 304);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1243,'Web Registered', '06-06-2021', 6003, 307);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6247,'Web Registered', '05-05-2021', 6002, 308);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7024,'Waitlisted', '06-25-2021', 6005, 310);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7700,'Waitlisted', '05-16-2021', 6005, 311);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1451,'Web Registered', '06-11-2021', 6007, 312);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2184,'Web Registered', '04-21-2021', 6009, 313);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6249,'Web Registered', '04-11-2021', 6004, 314);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5360,'Web Registered', '05-05-2021', 6000, 315);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1111,'Waitlisted', '05-05-2023', 6000, 316);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5792,'Web Registered', '06-06-2021', 6003, 317);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4070,'Web Registered', '05-05-2021', 6002, 318);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1198,'Web Registered', '06-08-2021', 6000, 121);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5698,'Waitlisted', '06-25-2021', 6005, 122);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4016,'Waitlisted', '05-16-2021', 6005, 123);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5596,'Web Registered', '06-11-2021', 6007, 124);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1401,'Web Registered', '04-21-2021', 6009, 125);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3984,'Web Registered', '04-11-2021', 6004, 126);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6034,'Web Registered', '05-05-2021', 6000, 127);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5940,'Waitlisted', '05-05-2023', 6000, 128);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3826,'Web Registered', '06-06-2021', 6003, 129);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7066,'Web Registered', '05-05-2021', 6002, 130);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7860,'Waitlisted', '06-25-2021', 6005, 132);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6204,'Waitlisted', '05-16-2021', 6005, 133);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7184,'Web Registered', '06-11-2021', 6007, 134);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2003,'Web Registered', '04-21-2021', 6009, 135);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7731,'Web Registered', '04-11-2021', 6004, 136);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4035,'Web Registered', '05-05-2021', 6000, 137);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1484,'Waitlisted', '05-05-2023', 6000, 138);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5806,'Web Registered', '06-06-2021', 6003, 139);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6116,'Web Registered', '05-05-2021', 6002, 140);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3471,'Web Registered', '06-08-2021', 6000, 141);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5601,'Waitlisted', '06-25-2021', 6005, 142);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4327,'Waitlisted', '05-16-2021', 6005, 143);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8629,'Web Registered', '06-11-2021', 6007, 144);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7012,'Web Registered', '04-21-2021', 6009, 145);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2803,'Web Registered', '04-11-2021', 6004, 146);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2687,'Web Registered', '06-06-2021', 6003, 149);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1657,'Web Registered', '05-05-2021', 6002, 150);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3535,'Waitlisted', '06-25-2021', 6005, 152);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5571,'Waitlisted', '05-16-2021', 6005, 153);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2055,'Web Registered', '06-11-2021', 6007, 154);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7576,'Web Registered', '04-21-2021', 6009, 155);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5499,'Web Registered', '04-11-2021', 6004, 156);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6896,'Web Registered', '06-06-2021', 6003, 159);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1665,'Web Registered', '05-05-2021', 6002, 160);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3450,'Waitlisted', '06-25-2021', 6005, 162);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6848,'Waitlisted', '05-16-2021', 6005, 163);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4449,'Web Registered', '06-11-2021', 6007, 164);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6734,'Web Registered', '04-21-2021', 6009, 165);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4582,'Web Registered', '04-11-2021', 6004, 166);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2445,'Web Registered', '06-06-2021', 6003, 147);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8791,'Web Registered', '05-05-2021', 6002, 148);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2292,'Waitlisted', '06-25-2021', 6005, 150);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6583,'Waitlisted', '05-16-2021', 6005, 151);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7614,'Web Registered', '06-11-2021', 6007, 152);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8632,'Web Registered', '04-21-2021', 6009, 153);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4597,'Web Registered', '04-11-2021', 6004, 154);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3229,'Web Registered', '06-06-2021', 6003, 157);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1013,'Web Registered', '05-05-2021', 6002, 158);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7290,'Waitlisted', '06-25-2021', 6005, 160);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5125,'Waitlisted', '05-16-2021', 6005, 161);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(2618,'Web Registered', '06-11-2021', 6007, 162);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5644,'Web Registered', '04-21-2021', 6009, 163);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4489,'Web Registered', '04-11-2021', 6004, 164);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1970,'Web Registered', '06-06-2021', 6003, 167);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6922,'Web Registered', '05-05-2021', 6002, 168);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5463,'Web Registered', '06-08-2021', 6000, 267);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3195,'Waitlisted', '06-25-2021', 6005, 268);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3176,'Waitlisted', '05-16-2021', 6005, 269);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4774,'Web Registered', '06-11-2021', 6007, 270);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3096,'Web Registered', '04-21-2021', 6009, 271);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5944,'Web Registered', '04-11-2021', 6004, 272);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4748,'Waitlisted', '06-25-2021', 6005, 278);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7682,'Web Registered', '04-21-2021', 6009, 281);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3130,'Web Registered', '04-11-2021', 6004, 282);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7006,'Web Registered', '06-06-2021', 6003, 285);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5608,'Web Registered', '05-05-2021', 6002, 286);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(6060,'Waitlisted', '06-25-2021', 6005, 288);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3494,'Waitlisted', '05-16-2021', 6005, 289);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3264,'Web Registered', '06-11-2021', 6007, 290);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4836,'Web Registered', '04-21-2021', 6009, 291);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7707,'Web Registered', '04-11-2021', 6004, 292);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(1836,'Web Registered', '06-06-2021', 6003, 295);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(3800,'Web Registered', '05-05-2021', 6002, 296);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(5735,'Waitlisted', '06-25-2021', 6005, 298);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(4776,'Web Registered', '06-11-2021', 6007, 300);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8142,'Web Registered', '04-21-2021', 6009, 301);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(8777,'Web Registered', '04-11-2021', 6004, 302);
INSERT INTO CourseRegistration(RegID, RegStatus, RegDate, CourseID, StudentID) VALUES(7651,'Web Registered', '05-05-2021', 6002, 306);

/*Inserting data into Staff*/

INSERT INTO Staff(StaffName, StaffType) VALUES('Arla Traynor', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Niyah Solomon', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Blythe Holt', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Sherri Roman', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Eren Cullen', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Salim Patrick', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Kaycee Duncan', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Teresa Buckley', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Leanna Byrne', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Kai Sharpe', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Aasiyah Noble', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Aqib Ferrell', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Taslima Walmsley', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Tommy-Lee Curry', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Makenzie Ware', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Bradlee Evans', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Fatima Sutton', 'P');
INSERT INTO Staff(StaffName, StaffType) VALUES('Eilish Cochran', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Riley-James Huerta', 'C');
INSERT INTO Staff(StaffName, StaffType) VALUES('Ishika Archer', 'C');


/*Inserting data into StaffPermanent*/

INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (300, 30000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (301, 40000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (302, 45000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (303, 50000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (304, 35000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (305, 15000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (306, 25000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (313, 35000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (315, 50000);
INSERT INTO StaffPermanent(PStaffID, Salary) VALUES (316, 47000);

/*Inserting data into StaffContract table*/

INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (307, 35.2);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (308, 40.2);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (309, 45.2);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (310, 45);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (311, 38);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (312, 35);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (314, 42);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (317, 41);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (318, 33);
INSERT INTO StaffContract(CStaffID, HourlyRate) VALUES (319, 26);

/*Inserting into data into Professor*/

INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1000, 'Jadon Ponce', 'Robinson 411', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1000, 'Tess Steadman', 'ISEC 321', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1002, 'Jaydan Travis', 'Richards 175', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1001, 'Jacob Porter', 'Richards 345', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1003, 'Barry Duran', 'Ell 250', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1003, 'Haidar Jacobs', 'Snell 001', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1004, 'Shakir Goulding', 'Snell 004', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1006, 'Gillian Hoffman', 'Churchill 345', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1008, 'Ranveer Stamp', 'Churchill 175', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1009, 'Sumaiyah Herman', 'Richards 411', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1002, 'Chelsie Colley', 'Dodge 444', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1002, 'Vinny Norton', 'Dodge 375', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1003, 'Reef Huber', 'ISEC 250', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1003, 'Montague Stafford', 'ISEC 111', 'P');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1004, 'Ann Storey', 'Robinson 112', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1006, 'Coral Quinn', 'Robinson 113', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1008, 'Kadie Correa', 'Robinson 450', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1010, 'Alara Rivera', 'Snell 320', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1008, 'Angela Weston', 'Snell 400', 'C');
INSERT INTO Professor(DepartmentID, ProfessorName, [Location], ProfessorType) VALUES(1010, 'Dafydd Whitworth', 'Snell 485', 'C');

/*Inserting data into ProfPermanent*/

INSERT INTO ProfPermanent(PProfID, Salary) VALUES (500, 50000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (501, 75000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (502, 80000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (505, 60000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (506, 70000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (509, 70000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (510, 50000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (511, 35000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (512, 40000);
INSERT INTO ProfPermanent(PProfID, Salary) VALUES (513, 40000);

/*Inserting data into ProfContract*/

INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (503, 60);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (504, 55.5);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (507, 65);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (508, 70);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (514, 66);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (515, 67);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (516, 62);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (517, 68);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (518, 72);
INSERT INTO ProfContract(CProfID, HourlyRate) VALUES (519, 77);


/*Inserting data into Teaches*/

INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6000, 500, 1, 'Fall');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6001, 517, 2, 'Spring');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6002, 500, 3, 'Summer');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6003, 503, 4, 'Fall');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6004, 518, 1, 'Spring');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6005, 505, 2, 'Summer');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6006, 506, 3, 'Fall');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6007, 503, 4, 'Spring');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6010, 508, 1, 'Summer');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6009, 509, 2, 'Fall');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6010, 514, 3, 'Spring');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6000, 511, 4, 'Summer');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6001, 509, 1, 'Fall');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6002, 506, 2, 'Spring');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6003, 514, 3, 'Summer');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6004, 511, 4, 'Fall');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6005, 511, 1, 'Spring');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6006, 517, 2, 'Summer');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6007, 518, 3, 'Fall');
INSERT INTO Teaches(CourseID, ProfessorID, Semester, Term) VALUES(6008, 508, 4, 'Spring');

/*Inserting data into Building*/

INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Smiths ', 'Westside', 200, 1000);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Shilman ', 'Forsynth Avenue', 201, 1001);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Robert Science Center', 'Brookline', 202, 1002);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Margaret', 'Backbay', 203, 1003);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Sundew', 'Milk Street', 204, 1004);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Lavender', 'Park Street', 205, 1010);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Bedford', 'Beacon Street', 206, 1010);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Elliot', 'Mathews Street', 207, 1007);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Spearow', 'Symphony Street', 208, 1008);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Eagle', 'Eastside', 209, 1009);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Marge', 'Heath Street', 200, 1000);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Lincoln', 'Tremont Street', 200, 1000);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Washington', 'Mission Main', 201, 1001);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Berkshire', 'Sunset Boulevard', 205, 1002);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Cassandra', 'Commonwealth Ave', 205, 1003);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Fiona', 'Lexington Street', 204, 1003);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Rivena', 'Causeway Ave', 203, 1004);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Fiorano', 'Hemenway', 203, 1007);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Florence', 'Boylston Street', 208, 1008);
INSERT INTO Building(BuildingName, BuildingLocation, CampusID, DepartmentID) VALUES('Curry', 'Riverway', 207, 1009);

/*Inserting data into Grades*/


INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 100, 3.45, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 101, 3.54, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 102, 2.65, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 103, 3.12, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 104, 3.19, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 105, 3.57, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 106, 3.46, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 107, 1.29, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 108, 3.27, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 109, 3.25, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 110, 3.71, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 111, 1.96, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 112, 1.55, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 113, 3.2, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 114, 3.82, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 115, 2.91, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 116, 3.89, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 117, 2.12, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 118, 3.59, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 119, 3.2, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 120, 1.62, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 121, 3.58, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 122, 3.6, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 123, 1.5, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 124, 2.64, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 125, 3.78, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 126, 3.9, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 127, 3.86, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 128, 1.91, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 129, 1.22, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 130, 3.24, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 131, 2.28, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 132, 3.4, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 133, 3.39, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 134, 2.13, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 135, 3.73, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 136, 2.59, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 137, 3.16, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 138, 3.75, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 139, 1.67, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 140, 2.67, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 141, 3.3, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 142, 2.69, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 143, 3.57, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 144, 1.22, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 145, 3.32, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 146, 1.46, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 147, 1.23, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 148, 1.13, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 149, 3.91, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 150, 3.17, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 151, 2.48, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 152, 2.22, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 153, 3.2, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 154, 2.31, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 155, 2.18, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 156, 3.78, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 157, 2.53, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 158, 1.91, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 159, 1.88, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 160, 1.95, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 161, 3.45, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 162, 2.89, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 163, 2.48, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 164, 1.27, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 165, 1.94, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 166, 3.61, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 167, 3.27, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 168, 3.16, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 169, 1.7, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 170, 3.63, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 171, 2.37, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 172, 3.18, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 173, 3.17, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 174, 3.55, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 175, 3.2, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 176, 2.36, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 177, 3.9, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 178, 3.46, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 179, 3.98, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 180, 3.38, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 181, 2.71, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 182, 1.13, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 183, 3.33, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 184, 3.19, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 185, 1.59, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 186, 3.36, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 187, 1.86, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 188, 3.97, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 189, 2.92, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 190, 3.23, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 191, 3.47, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 192, 3.44, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 193, 3.56, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 194, 3.2, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 195, 1.14, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 196, 1.23, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 197, 3.59, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 198, 3.64, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 199, 3.62, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 200, 3.77, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 201, 1.5, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 202, 3.94, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 203, 2.59, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 204, 1.5, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 205, 2.47, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 206, 3.98, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 207, 2.49, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 208, 2.36, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 209, 1.41, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 210, 1.71, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 211, 3.49, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 212, 1.77, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 213, 1.54, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 214, 3.66, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 215, 3.63, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 216, 1.49, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 217, 1.74, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 218, 3.35, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 219, 1.71, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 220, 2.43, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 221, 3.51, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 222, 1.27, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 223, 3.77, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 224, 1.52, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 225, 3.39, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 226, 1.18, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 227, 3.73, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 228, 1.52, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 229, 3.8, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 230, 1.81, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 231, 3.72, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 232, 3.21, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 233, 3.66, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 234, 1.12, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 235, 1.6, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 236, 2.29, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 237, 1.4, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 238, 2.2, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 239, 2.53, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 240, 3.58, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 241, 1.41, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 242, 2.44, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 243, 2.59, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 244, 3.28, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 245, 2.62, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 246, 3.13, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 247, 3.78, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 248, 3.46, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 249, 2.72, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 250, 2.86, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 251, 2.72, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 252, 3.1, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 253, 3.96, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 254, 2.36, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 255, 3.88, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 256, 1.96, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 257, 3.57, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 258, 1.6, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 259, 3.89, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 260, 3.69, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 261, 2.88, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 262, 1.31, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 263, 3.6, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 264, 3.89, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 265, 1.62, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 266, 1.27, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 267, 3.93, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 268, 1.78, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 269, 1.73, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 270, 3.71, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 271, 2.42, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 272, 3.53, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 273, 3.95, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 274, 1.14, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 275, 1.27, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 276, 1.11, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 277, 3.47, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 278, 2.22, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 279, 3.25, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 280, 1.93, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 281, 3.55, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 282, 3.57, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 283, 1.34, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 284, 2.1, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 285, 3.55, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 286, 2.56, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 287, 2.26, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 288, 2.74, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 289, 3.4, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 290, 1.59, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 291, 3.63, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 292, 3.35, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 293, 3.66, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 294, 3.2, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 295, 3.71, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 296, 3.49, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 297, 3.78, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 298, 1.81, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 299, 1.92, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 300, 3.57, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 301, 2.88, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 302, 3.52, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 303, 1.53, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 304, 3.65, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 305, 1.41, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 306, 3.77, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 307, 1.15, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 308, 3.68, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 309, 2.89, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 310, 3.96, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 311, 1.86, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 312, 3.74, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 313, 3.7, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 314, 3.77, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 315, 3.18, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 316, 2.54, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 317, 3.89, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 318, 3.65, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 319, 3.96, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 320, 2.91, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 321, 3.55, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 322, 3.75, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 323, 3.12, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 324, 1.23, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 325, 3.57, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 326, 3.12, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 327, 2.1, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 328, 3.66, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 329, 2.35, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 330, 3.72, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 331, 3.89, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 332, 2.22, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 333, 1.15, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 334, 3.29, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 335, 1.67, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 336, 3.91, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 337, 1.38, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 338, 3.29, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 339, 2.66, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 340, 3.48, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 341, 3.82, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 342, 3.37, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 343, 3.48, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 344, 3.43, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 345, 3.68, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 346, 1.9, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 347, 3.71, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 348, 2.82, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 349, 3.54, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 350, 3.74, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 351, 3.34, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 352, 3.77, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 353, 2.95, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 354, 2.79, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 355, 3.81, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 356, 3.13, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 357, 2.16, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 358, 1.84, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 359, 3.22, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 360, 3.43, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 361, 1.94, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 362, 3.35, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 363, 2.99, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 364, 3.32, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 365, 3.97, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 366, 3.81, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 367, 1.6, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 368, 2.17, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 369, 3.74, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 370, 1.7, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 371, 3.46, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 372, 1.34, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 373, 3.21, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 374, 2.12, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 375, 1.19, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 376, 2.3, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 377, 3.6, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 378, 2.62, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 379, 3.86, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 380, 3.29, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 381, 1.69, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 382, 3.65, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 383, 1.51, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6001, 384, 1.53, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 385, 2.84, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6003, 386, 1.51, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6004, 387, 2.24, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6005, 388, 1.69, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 389, 3.91, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6002, 390, 3.42, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6006, 391, 1.42, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 392, 1.83, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 393, 1.68, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 394, 1.51, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 395, 1.71, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6007, 396, 2.76, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6008, 397, 3.43, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6000, 398, 3.56, 'Pass');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6009, 399, 1.68, 'Fail');
INSERT  INTO Grades(CourseID, StudentID, CGPA, Result) VALUES(6010, 400, 3.97, 'Pass');


--Checking the output
--Select * from Student

--Execution of Stored Procedure 1: 
Go
DECLARE @count INT; 
EXEC getAllProfDataByDept @department_name = 'Information Systems', @profCount = @count OUTPUT; 
SELECT @count AS 'Number of professors worked in a department'

Go
--Execution of Stored Procedure 2:
DECLARE @CoursesDropped INT
EXEC updateCourseRegStatus @StudentID = 280, @CourseID=6002, @NoofDroppedCoursesByStudent = @CoursesDropped OUTPUT
select @CoursesDropped as 'No. of Courses Dropped By this Student'
Go
--Execution of Stored Procedure 3:
DECLARE @CountGrade INT
EXEC getStudentsByGrade @Grade='A', @countOfStudentsWithThisGrade = @CountGrade OUTPUT
SELECT @CountGrade as 'Count of Students with this Grade'

--Execution of Stored Procedure 4:
Go
DECLARE @getCourseCount int
EXEC getAllCourseDetailsByCampusName @CampusName = 'North East Campus', @academic_term='Fall', @courseCount= @getCourseCount Output
select @getCourseCount as 'No. of Courses'

Go

--Execution of Stored Procedure 5:

DECLARE @count INT; 
EXEC getAllStudentDataAssgToAdvisor 

    @advisor_name = 'Harry Wes', 

    @stuCount = @count OUTPUT; 

  SELECT @count AS 'Number of Students assigned to this Advisor:';

--COLUMN DATA ENCRYTION

--Opening the symmetric key to encrypt the data
OPEN SYMMETRIC KEY StudentPass_SM
DECRYPTION BY CERTIFICATE StudentPass
Go

--Encrypting the value in column Password with Symmetric Key.
UPDATE Student
SET Username = StudentName,
[Password] = EncryptByKey(KEY_GUID('StudentPass_SM'),convert(varbinary,'Pass123'))