insert.sql

-- Teacher --

insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (1, 'dbranwhite0', 'dbranwhite0@columbia.edu', 'PN8CDsWq', 'Dennis Branwhite', '2006-09-13', '1964-09-26', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (2, 'aonowlan1', 'aonowlan1@wsj.com', 'idPVZ1aSsz6', 'Adan O''Nowlan', '2007-11-15', '1977-09-25', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (3, 'igabbott2', 'igabbott2@wordpress.org', 'PPRrUiW4p5', 'Ingaborg Gabbott', '1983-06-28', '1983-03-29', 'BT', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (4, 'bgumm3', 'bgumm3@guardian.co.uk', 'H1ebxNN0wrGy', 'Bambie Gumm', '1996-02-29', '1968-07-04', 'EEE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (5, 'chennington4', 'chennington4@feedburner.com', 'oUVbpO', 'Carlo Hennington', '2013-05-10', '1981-06-09', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (6, 'telletson5', 'telletson5@livejournal.com', '15NyADxz', 'Tierney Elletson', '2017-07-20', '1983-09-02', 'CSE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (7, 'ghearty6', 'ghearty6@redcross.org', 'N7jZ7GyXIlkI', 'Ginny Hearty', '2014-08-09', '1977-01-11', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (8, 'tcarlyon7', 'tcarlyon7@ycombinator.com', 'ZA99SeVWN', 'Theodosia Carlyon', '1980-01-14', '1963-10-02', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (9, 'vbuckles8', 'vbuckles8@economist.com', 'pfHjzBX', 'Vikky Buckles', '2011-07-16', '1961-03-02', 'BT', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (10, 'iriggeard9', 'iriggeard9@simplemachines.org', 'GpOlCxc8', 'Ilka Riggeard', '1996-02-06', '1962-10-27', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (11, 'cdykesa', 'cdykesa@netlog.com', '57spmQ56c', 'Calypso Dykes', '1995-09-12', '1983-03-26', 'ECE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (12, 'daylingb', 'daylingb@telegraph.co.uk', 'rSNaJTsg3J', 'Dexter Ayling', '1993-03-09', '1972-02-04', 'EEE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (13, 'pbradderc', 'pbradderc@forbes.com', 'BWQMPEMvwFkW', 'Priscilla Bradder', '2016-01-23', '1961-12-17', 'EEE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (14, 'eduinbletond', 'eduinbletond@usnews.com', 'v4T4poFbQBlB', 'Elton Duinbleton', '2009-03-31', '1964-03-05', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (15, 'cwaude', 'cwaude@accuweather.com', 'tXtEtZrMC', 'Carny Waud', '2013-04-04', '1983-11-12', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (16, 'acharlef', 'acharlef@cdbaby.com', 'VDM4fzyrk', 'Agneta Charle', '2001-10-24', '1974-07-14', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (17, 'hglovesg', 'hglovesg@lycos.com', 'hmDvfbjg', 'Huey Gloves', '1983-08-19', '1985-08-07', 'CSE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (18, 'kculpinh', 'kculpinh@cafepress.com', 'tdM2qst', 'Karole Culpin', '1994-03-31', '1963-10-26', 'ECE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (19, 'zalleryi', 'zalleryi@jigsy.com', 'vmyTKGUL', 'Zachariah Allery', '1992-09-15', '1982-07-11', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (20, 'zslydej', 'zslydej@vistaprint.com', 'GSqBAk4m3f', 'Zackariah Slyde', '1993-03-17', '1963-11-24', 'EEE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (21, 'egordgek', 'egordgek@yellowbook.com', '2C7nM3exhPH8', 'Elmo Gordge', '2007-10-04', '1976-12-14', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (22, 'snewcomel', 'snewcomel@trellian.com', 'NCw24zI', 'Shir Newcome', '1981-11-10', '1977-10-20', 'ECE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (23, 'theminsleym', 'theminsleym@noaa.gov', 'YHLGY9qZOva', 'Tilda Heminsley', '1998-06-04', '1975-04-10', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (24, 'spetkovicn', 'spetkovicn@howstuffworks.com', 'TmKWuCyK', 'Silvester Petkovic', '2003-10-28', '1978-08-14', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (25, 'rforstallo', 'rforstallo@disqus.com', 'VIipUdiOUB', 'Rita Forstall', '1989-09-11', '1964-04-13', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (26, 'ocainp', 'ocainp@cisco.com', 'L6QSLjiaSGK', 'Odele Cain', '1990-11-01', '1978-08-28', 'MECH', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (27, 'dtinemanq', 'dtinemanq@cbsnews.com', 'MwrEuQ8', 'Danny Tineman', '2006-12-25', '1982-07-30', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (28, 'kpolakr', 'kpolakr@ning.com', 'Zfi35npjEo6', 'Kincaid Polak', '1988-10-24', '1978-07-04', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (29, 'lvickarmans', 'lvickarmans@reference.com', 'XzmJfrLO99BH', 'Layne Vickarman', '1984-03-27', '1973-08-29', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (30, 'csigfridt', 'csigfridt@scribd.com', 'rFObCq5', 'Charil Sigfrid', '2013-03-01', '1974-01-20', 'BT', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (31, 'hjumontu', 'hjumontu@wufoo.com', 'b0iiYqwNw1SV', 'Helenka Jumont', '2010-04-20', '1964-05-21', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (32, 'acutbushv', 'acutbushv@ucoz.ru', 'njmeb31H5zY', 'Astrid Cutbush', '2011-11-18', '1964-11-15', 'CSE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (33, 'aaultonw', 'aaultonw@myspace.com', 'ooVILjAdzdNd', 'Ada Aulton', '1984-03-06', '1984-06-03', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (34, 'nlathayex', 'nlathayex@about.me', 'x2k9r0AYBjiZ', 'Nico Lathaye', '1980-12-07', '1973-06-08', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (35, 'goolahany', 'goolahany@digg.com', 'NwphugA1dldi', 'Gena Oolahan', '1997-08-20', '1967-11-20', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (36, 'ldunningz', 'ldunningz@nsw.gov.au', '15ZZo72fYW', 'Lynne Dunning', '1994-01-05', '1969-12-26', 'CSE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (37, 'hkinghorne10', 'hkinghorne10@dailymail.co.uk', 'fvCTb0', 'Haleigh Kinghorne', '1992-06-05', '1965-10-16', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (38, 'scrosetto11', 'scrosetto11@npr.org', 'NHlNY3UHX', 'Saloma Crosetto', '2008-01-30', '1971-07-07', 'EEE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (39, 'glambeth12', 'glambeth12@elegantthemes.com', 'gHq70109', 'Gipsy Lambeth', '1988-02-25', '1978-10-02', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (40, 'lastlet13', 'lastlet13@youtube.com', 'ZjnZ6JqqA', 'Lacie Astlet', '2016-11-23', '1960-09-30', 'CSE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (41, 'sjacomb14', 'sjacomb14@discuz.net', 'jLQCnGyG', 'Spike Jacomb', '2004-05-26', '1980-10-22', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (42, 'kiwanczyk15', 'kiwanczyk15@yellowpages.com', 'QZjtn0w9wp', 'Kessia Iwanczyk', '1990-05-20', '1967-10-18', 'CSE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (43, 'winger16', 'winger16@wikipedia.org', 'RZ68nxYcgys', 'Winonah Inger', '1982-11-08', '1977-12-12', 'MECH', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (44, 'cboddy17', 'cboddy17@apache.org', 'cb0fLjK', 'Correy Boddy', '2004-04-11', '1972-04-24', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (45, 'afranseco18', 'afranseco18@paypal.com', 'NLJY8dX', 'Antoinette Franseco', '2000-10-12', '1968-06-06', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (46, 'brounsefell19', 'brounsefell19@google.pl', 'NPVxMtH', 'Bale Rounsefell', '1985-05-29', '1977-09-19', 'BT', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (47, 'gcatterick1a', 'gcatterick1a@illinois.edu', 'WWsOSypF', 'Giffer Catterick', '2000-10-30', '1970-06-16', 'BT', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (48, 'egladyer1b', 'egladyer1b@state.tx.us', 'TZVnImvrPCgV', 'Eliza Gladyer', '2016-10-10', '1971-06-15', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (49, 'mtaylorson1c', 'mtaylorson1c@vinaora.com', 'QzqqRMfZxs', 'Marilee Taylorson', '1983-01-31', '1961-03-16', 'EEE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (50, 'gciccarello1d', 'gciccarello1d@ovh.net', '8vtI5hBmAvOS', 'Galvan Ciccarello', '2011-03-22', '1973-04-05', 'EEE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (51, 'jbriamo1e', 'jbriamo1e@yandex.ru', 'RtxWLMpth7Y', 'Joby Briamo', '1985-01-20', '1961-03-24', 'CSE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (52, 'fbellenger1f', 'fbellenger1f@51.la', 'sW8MgCdf', 'Felice Bellenger', '1998-03-31', '1974-11-08', 'CSE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (53, 'oburtwistle1g', 'oburtwistle1g@istockphoto.com', 'jOywE7n', 'Ole Burtwistle', '2010-01-12', '1977-11-17', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (54, 'adorant1h', 'adorant1h@hexun.com', 'j3f60MUBFyr', 'Athene Dorant', '1981-09-26', '1960-07-09', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (55, 'mstichel1i', 'mstichel1i@ovh.net', 'nPsc12fURW6c', 'Mathe Stichel', '2017-02-14', '1960-05-10', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (56, 'cflorio1j', 'cflorio1j@multiply.com', '7IgqaBBJqQ', 'Clayson Florio', '2014-11-14', '1978-12-06', 'ECE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (57, 'gshepley1k', 'gshepley1k@parallels.com', 'KjVisaQje', 'Guilbert Shepley', '2013-11-02', '1980-07-18', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (58, 'oschoular1l', 'oschoular1l@dyndns.org', 'zIPiLYtBAxAw', 'Olympie Schoular', '2017-09-22', '1960-12-11', 'BT', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (59, 'jhumphries1m', 'jhumphries1m@mapy.cz', 'PT3mLbj3dyjX', 'Jake Humphries', '1982-03-28', '1981-06-26', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (60, 'jnairy1n', 'jnairy1n@army.mil', '6gTKUaqTPHb', 'Jandy Nairy', '2009-11-04', '1982-05-09', 'BT', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (61, 'maldhouse1o', 'maldhouse1o@gizmodo.com', 'vf4JZj9', 'Marquita Aldhouse', '1989-05-02', '1966-02-10', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (62, 'bdodding1p', 'bdodding1p@youtu.be', '7yzOFBfG', 'Barty Dodding', '2016-02-24', '1979-10-17', 'BT', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (63, 'alapslie1q', 'alapslie1q@xing.com', '0e1cufNx', 'Arda Lapslie', '2004-07-30', '1980-04-03', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (64, 'jundrill1r', 'jundrill1r@timesonline.co.uk', 'xR94I1zSAwP', 'Jarid Undrill', '1986-06-25', '1973-09-04', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (65, 'ecavalier1s', 'ecavalier1s@who.int', '9ji6lJ', 'Emelina Cavalier', '2001-07-20', '1975-12-08', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (66, 'drozea1t', 'drozea1t@samsung.com', 'rUvX4rib', 'Dorella Rozea', '1983-05-25', '1985-10-29', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (67, 'ssaxon1u', 'ssaxon1u@pagesperso-orange.fr', 'nxqoXe', 'Sharron Saxon', '1987-01-19', '1961-08-05', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (68, 'fgleadle1v', 'fgleadle1v@virginia.edu', '0VJN2J', 'Far Gleadle', '2014-09-15', '1977-04-02', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (69, 'lartingstall1w', 'lartingstall1w@state.tx.us', '2Po3uaFNa4', 'Lenard Artingstall', '1990-01-25', '1960-05-19', 'CSE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (70, 'cwitty1x', 'cwitty1x@nba.com', 'qtpjkZvNOz', 'Cordy Witty', '1990-10-30', '1968-08-31', 'EEE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (71, 'gegentan1y', 'gegentan1y@theatlantic.com', 'Gnn9CP9F265', 'Gussi Egentan', '2014-03-24', '1968-01-12', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (72, 'blugsdin1z', 'blugsdin1z@wordpress.com', 'ZNSGx4', 'Buiron Lugsdin', '1991-04-27', '1966-03-03', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (73, 'jgoldthorp20', 'jgoldthorp20@woothemes.com', 'QPpRC0TBpj', 'Jourdan Goldthorp', '1985-09-26', '1982-02-16', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (74, 'abenardet21', 'abenardet21@last.fm', 'SDc3oSve', 'Arlyne Benardet', '1996-09-20', '1978-02-15', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (75, 'amcarthur22', 'amcarthur22@amazon.co.jp', 'fOOThUT2', 'Arlene McArthur', '2011-06-25', '1970-06-11', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (76, 'npulfer23', 'npulfer23@tripod.com', 'Un72Jul', 'Niki Pulfer', '2012-04-09', '1969-07-04', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (77, 'cfeckey24', 'cfeckey24@nsw.gov.au', 'omjQN6OIL', 'Chelsea Feckey', '1994-10-02', '1979-05-19', 'EEE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (78, 'cwoolforde25', 'cwoolforde25@github.io', 'MnjOAINz', 'Cecilius Woolforde', '1985-05-08', '1979-10-19', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (79, 'llantry26', 'llantry26@unc.edu', '400elQ49SbaD', 'Lavena Lantry', '1987-08-18', '1966-09-06', 'EEE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (80, 'abruinemann27', 'abruinemann27@e-recht24.de', 'NuYHWQCGIv', 'Allyce Bruinemann', '1987-04-10', '1979-03-07', 'EEE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (81, 'gchiverton28', 'gchiverton28@youtube.com', 'tkXpoE6XH', 'Gwendolin Chiverton', '2000-05-19', '1969-05-25', 'CSE', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (82, 'nhamblett29', 'nhamblett29@baidu.com', 'VjCXX2', 'Nealon Hamblett', '1982-05-07', '1964-10-01', 'EEE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (83, 'cgilbard2a', 'cgilbard2a@imageshack.us', 'zlprlAvzREx', 'Caitrin Gilbard', '2010-11-10', '1967-06-15', 'BT', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (84, 'skarlqvist2b', 'skarlqvist2b@tmall.com', 'EMfBmQlSfRIi', 'Shara Karlqvist', '1988-08-24', '1961-03-27', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (85, 'mowlner2c', 'mowlner2c@home.pl', 'TpiIFFiu', 'Maris Owlner', '2012-08-19', '1976-02-14', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (86, 'lherreran2d', 'lherreran2d@yellowpages.com', 'avUi4C', 'Loella Herreran', '1984-11-01', '1977-03-03', 'CSE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (87, 'cpennick2e', 'cpennick2e@amazon.com', 'qP2SzOSf45W2', 'Conant Pennick', '2001-09-18', '1985-04-02', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (88, 'klorraine2f', 'klorraine2f@apache.org', 'ueo1npC6Y', 'Katey Lorraine', '2014-01-28', '1961-09-18', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (89, 'gschmuhl2g', 'gschmuhl2g@tinyurl.com', 'fQoTjD8n', 'Griff Schmuhl', '1981-07-05', '1967-03-18', 'EEE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (90, 'cilyuchyov2h', 'cilyuchyov2h@ustream.tv', 'FmLzpII', 'Clyde Ilyuchyov', '1991-04-13', '1970-10-07', 'CSE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (91, 'epaddle2i', 'epaddle2i@cpanel.net', 'RYZ6NGDHlT', 'Ellette Paddle', '2000-12-29', '1971-04-04', 'BT', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (92, 'vstanier2j', 'vstanier2j@ucoz.com', 'AOSFfu4e', 'Vilhelmina Stanier', '1993-06-07', '1981-01-01', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (93, 'schippendale2k', 'schippendale2k@google.com', 'n2PdtOMHQ', 'Steffane Chippendale', '2011-11-22', '1961-03-08', 'MECH', 'Assistant Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (94, 'bbeevens2l', 'bbeevens2l@oaic.gov.au', 'nVhesCM', 'Byron Beevens', '1989-06-11', '1976-07-15', 'ECE', 'HOD');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (95, 'amerioth2m', 'amerioth2m@stumbleupon.com', 'xg1rWZXsNt', 'Alfie Merioth', '1997-02-09', '1964-06-28', 'MECH', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (96, 'sburkill2n', 'sburkill2n@studiopress.com', 'jnBqZ0b7dGuB', 'Savina Burkill', '1987-04-24', '1984-03-04', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (97, 'alindenfeld2o', 'alindenfeld2o@nationalgeographic.com', 'HYnBjSY9I', 'Andrey Lindenfeld', '1997-07-25', '1984-05-02', 'CSE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (98, 'eraybould2p', 'eraybould2p@weather.com', 'mkHCycqnnPsR', 'Erena Raybould', '1982-01-04', '1978-12-11', 'ECE', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (99, 'ctoft2q', 'ctoft2q@techcrunch.com', 'k9PUOwc', 'Camilla Toft', '1983-06-22', '1963-07-23', 'BT', 'Professor');
insert into teacher (teacherID, username, email, password, teacherName, startDate, birthDate, department, designation) values (100, 'eguerrin2r', 'eguerrin2r@jalbum.net', 'BxekloAHU', 'Ester Guerrin', '2016-06-02', '1978-05-08', 'CSE', 'Assistant Professor');






-- Course --







insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (1, 'LGD', 'NLHC304', 'H', 3, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (2, 'Financial Audits', 'NLHC304', 'G', 31, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (3, 'OEM Management', 'ELHC401', 'H', 33, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (4, 'UV coating', 'NLHC203', 'H', 18, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (5, 'Access', 'ELHC203', 'H', 84, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (6, 'Zinc', 'ELHC304', 'G', 1, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (7, 'Data Modeling', 'ELHC401', 'G', 27, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (8, 'QPST', 'ELHC401', 'E', 90, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (9, 'Spring Framework', 'ELHC401', 'H', 58, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (10, 'Epistemology', 'ELHC401', 'H', 67, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (11, 'ETABS', 'NLHC203', 'H', 56, 1, 15, 3, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (12, 'UIKit', 'ELHC401', 'G', 5, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (13, 'Operations Management', 'ELHC304', 'F', 19, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (14, 'Creative Strategy', 'NLHC304', 'G', 72, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (15, 'Editorial Illustrations', 'ELHC401', 'F', 85, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (16, 'Comic Book Illustration', 'NLHC401', 'H', 80, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (17, 'Interior Design', 'NLHC401', 'G', 96, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (18, 'Non-compete Agreements', 'ELHC102', 'H', 40, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (19, 'Online Gaming', 'NLHC304', 'G', 42, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (20, 'Test Planning', 'ELHC203', 'H', 99, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (21, 'Flight Planning', 'ELHC304', 'E', 97, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (22, 'NT 4.0', 'ELHC401', 'H', 90, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (23, 'MW', 'NLHC401', 'H', 63, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (24, 'TCD', 'NLHC203', 'H', 2, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (25, 'OO Software Development', 'NLHC401', 'H', 57, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (26, 'GMPLS', 'NLHC401', 'G', 2, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (27, 'Rig', 'NLHC401', 'A', 29, 4, 60, 12, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (28, 'Workers Compensation', 'ELHC401', 'H', 41, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (29, 'OSHA', 'NLHC203', 'H', 87, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (30, 'Nikon DSLR', 'ELHC401', 'H', 50, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (31, 'Sales Operations', 'NLHC401', 'H', 43, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (32, 'XATA', 'NLHC304', 'E', 47, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (33, 'R&TTE', 'NLHC401', 'G', 28, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (34, 'Static Timing Analysis', 'NLHC401', 'C', 56, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (35, 'Data Center', 'NLHC203', 'G', 33, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (36, 'Mobile Technology', 'ELHC304', 'G', 47, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (37, 'McAfee Antivirus', 'NLHC304', 'H', 94, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (38, 'Sage ERP X3', 'NLHC102', 'H', 69, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (39, 'Waterfall', 'NLHC304', 'H', 78, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (40, 'Ultrasonic Welding', 'NLHC401', 'D', 92, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (41, 'SOA BPEL', 'ELHC401', 'H', 20, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (42, 'Hypertension', 'NLHC401', 'G', 3, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (43, 'HTTPS', 'ELHC304', 'H', 29, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (44, 'HR Transformation', 'NLHC401', 'G', 28, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (45, 'KCS', 'ELHC102', 'F', 24, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (46, 'Ignatian Spirituality', 'ELHC401', 'E', 43, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (47, 'Ocular Disease', 'ELHC401', 'G', 59, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (48, 'Jewish Studies', 'NLHC401', 'H', 94, 1, 15, 3, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (49, 'Zabbix', 'NLHC102', 'E', 11, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (50, 'UEFI', 'NLHC203', 'F', 64, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (51, 'First Time Home Buyers', 'NLHC304', 'H', 37, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (52, 'SFP', 'ELHC401', 'H', 65, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (53, 'Utility Locating', 'NLHC401', 'F', 56, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (54, 'Hospitality', 'NLHC203', 'F', 32, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (55, 'Family Therapy', 'ELHC401', 'E', 42, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (56, 'Titration', 'ELHC304', 'H', 34, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (57, 'WGA', 'ELHC401', 'E', 24, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (58, 'Sleep Medicine', 'NLHC304', 'H', 93, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (59, 'IEEE', 'ELHC401', 'H', 64, 1, 15, 3, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (60, 'Uniform Combined State Law', 'ELHC401', 'H', 63, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (61, 'OKI', 'ELHC102', 'F', 64, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (62, 'Floor Plans', 'ELHC304', 'D', 9, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (63, 'MBTI', 'ELHC401', 'H', 24, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (64, 'HSSE', 'NLHC401', 'F', 71, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (65, 'PPAP', 'ELHC401', 'H', 66, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (66, 'EELS', 'ELHC304', 'H', 29, 1, 15, 3, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (67, 'NAS', 'NLHC203', 'G', 68, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (68, 'HP Blade', 'ELHC401', 'F', 45, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (69, 'VPLS', 'ELHC401', 'H', 17, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (70, 'ESRI', 'NLHC401', 'F', 42, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (71, 'Failure Analysis', 'ELHC203', 'F', 31, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (72, 'IFE', 'ELHC401', 'H', 72, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (73, 'QS1', 'ELHC102', 'G', 52, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (74, 'Behavioral Health', 'NLHC401', 'H', 43, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (75, 'Interviewing Skills', 'NLHC401', 'H', 58, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (76, 'CSRs', 'NLHC401', 'H', 14, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (77, 'GFAAS', 'ELHC203', 'H', 51, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (78, 'Young People', 'NLHC401', 'H', 81, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (79, 'Beauty Industry', 'ELHC304', 'G', 91, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (80, 'Elementary Education', 'ELHC401', 'H', 8, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (81, 'PDM', 'ELHC401', 'G', 81, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (82, 'MLD', 'ELHC203', 'G', 7, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (83, 'Talent Booking', 'ELHC401', 'H', 37, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (84, 'RIP', 'ELHC203', 'G', 23, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (85, 'University Teaching', 'ELHC203', 'H', 3, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (86, 'Dual Diagnosis', 'ELHC401', 'H', 77, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (87, 'Store Management', 'NLHC401', 'D', 89, 1, 15, 3, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (88, 'MDRs', 'ELHC304', 'F', 21, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (89, 'Sony HDV', 'NLHC401', 'H', 7, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (90, 'AKTA', 'ELHC304', 'H', 96, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (91, 'TMJ Treatment', 'NLHC401', 'G', 18, 1, 15, 3, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (92, 'Software Implementation', 'NLHC304', 'H', 74, 3, 45, 9, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (93, 'TV Distribution', 'NLHC401', 'G', 18, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (94, 'Web TV', 'ELHC304', 'G', 69, 1, 15, 3, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (95, 'Gymnastics', 'ELHC304', 'F', 5, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (96, 'Foreign Affairs', 'NLHC401', 'G', 69, 3, 45, 9, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (97, 'DFX', 'NLHC102', 'E', 21, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (98, 'NCAA Compliance', 'NLHC401', 'H', 7, 2, 30, 6, 'N');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (99, 'Carrier Ethernet', 'NLHC401', 'H', 40, 2, 30, 6, 'Y');
insert into course (courseID, courseName, classroom, slot, teacherID, credits, totalClasses, possibleLeaves, considerInCGPA) values (100, 'Escrow', 'NLHC304', 'F', 40, 3, 45, 9, 'Y');






-- student --






insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (1, 'Lisbeth Geany', 'lgeany0@multiply.com', 'CIVIL', '7/12/2017', 'E', 'E', 6.38);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (2, 'Aundrea Barkess', 'abarkess1@disqus.com', 'MECH', '5/28/2017', 'H', 'E', 4.64);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (3, 'Taite Terzi', 'tterzi2@tamu.edu', 'MECH', '4/25/2017', 'F', 'C', 7.87);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (4, 'Halley O'' Markey', 'ho3@clickbank.net', 'EEE', '2/27/2017', 'F', 'C', 6.82);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (5, 'Christoffer Manning', 'cmanning4@cbsnews.com', 'CIVIL', '9/3/2017', 'E', 'C', 5.54);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (6, 'Marco Edwicker', 'medwicker5@dot.gov', 'ECE', '1/30/2017', 'H', 'C', 7.37);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (7, 'Olimpia McNirlan', 'omcnirlan6@arstechnica.com', 'CSE', '5/15/2017', 'E', 'F', 8.88);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (8, 'Lorinda Nuttey', 'lnuttey7@nature.com', 'CSE', '12/28/2016', 'D', 'A', 4.97);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (9, 'Tony Eilert', 'teilert8@acquirethisname.com', 'MECH', '11/29/2016', 'D', 'B', 4.24);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (10, 'Budd Featherstonhaugh', 'bfeatherstonhaugh9@oakley.com', 'CSE', '1/10/2017', 'B', 'F', 6.23);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (11, 'Pacorro Pagen', 'ppagena@facebook.com', 'MECH', '5/27/2017', 'A', 'F', 4.41);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (12, 'Lalo Cradey', 'lcradeyb@marketwatch.com', 'CSE', '1/30/2017', 'A', 'F', 7.29);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (13, 'Maurise Whacket', 'mwhacketc@amazon.com', 'ECE', '12/28/2016', 'F', 'D', 9.65);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (14, 'Tally Mytton', 'tmyttond@ucla.edu', 'EEE', '3/18/2017', 'E', 'C', 4.47);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (15, 'Pierrette Coping', 'pcopinge@patch.com', 'CSE', '5/15/2017', 'E', 'D', 4.24);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (16, 'Regine Bidder', 'rbidderf@netscape.com', 'MECH', '2/19/2017', 'G', 'D', 4.61);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (17, 'Thorndike Lealle', 'tlealleg@nydailynews.com', 'CIVIL', '1/1/2017', 'B', 'B', 5.72);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (18, 'Gisella Tutchener', 'gtutchenerh@networkadvertising.org', 'CIVIL', '2/27/2017', 'D', 'B', 9.67);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (19, 'Deanna Lyles', 'dlylesi@printfriendly.com', 'EEE', '9/14/2017', 'G', 'B', 7.65);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (20, 'Niel Crathern', 'ncrathernj@naver.com', 'MECH', '9/21/2017', 'B', 'E', 8.2);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (21, 'Desmund Maybery', 'dmayberyk@abc.net.au', 'MECH', '8/20/2017', 'H', 'F', 7.33);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (22, 'Torey Tixall', 'ttixalll@bigcartel.com', 'ECE', '9/18/2017', 'C', 'B', 5.93);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (23, 'Adler Uff', 'auffm@sitemeter.com', 'MECH', '6/17/2017', 'B', 'C', 7.37);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (24, 'Jehu Barber', 'jbarbern@tripod.com', 'MECH', '12/11/2016', 'B', 'E', 5.02);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (25, 'Donnie Ebbers', 'debberso@sun.com', 'EEE', '6/14/2017', 'G', 'B', 5.55);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (26, 'Brianna Vannacci', 'bvannaccip@addthis.com', 'CIVIL', '6/1/2017', 'D', 'E', 6.69);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (27, 'De Glaum', 'dglaumq@kickstarter.com', 'ECE', '6/15/2017', 'F', 'E', 7.23);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (28, 'Davy Philott', 'dphilottr@acquirethisname.com', 'MECH', '8/15/2017', 'H', 'B', 8.2);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (29, 'Jilli Battelle', 'jbattelles@bigcartel.com', 'MECH', '9/6/2017', 'C', 'C', 8.69);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (30, 'Kaye Stroban', 'kstrobant@w3.org', 'ECE', '3/19/2017', 'C', 'B', 8.11);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (31, 'Sunny Ilden', 'sildenu@rakuten.co.jp', 'ECE', '7/15/2017', 'E', 'A', 6.77);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (32, 'Beitris Andover', 'bandoverv@msu.edu', 'EEE', '2/15/2017', 'D', 'E', 9.15);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (33, 'Lira Hulett', 'lhulettw@ustream.tv', 'MECH', '4/14/2017', 'B', 'C', 5.7);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (34, 'Tedd Sanbrooke', 'tsanbrookex@tmall.com', 'EEE', '11/23/2016', 'H', 'A', 9.48);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (35, 'Karilynn Jesty', 'kjestyy@indiegogo.com', 'CIVIL', '8/6/2017', 'F', 'F', 8.08);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (36, 'Samuele Burgoyne', 'sburgoynez@canalblog.com', 'CSE', '4/14/2017', 'H', 'B', 6.66);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (37, 'Cosmo Money', 'cmoney10@columbia.edu', 'CSE', '11/19/2016', 'G', 'D', 4.87);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (38, 'Ninette Akid', 'nakid11@csmonitor.com', 'MECH', '8/5/2017', 'F', 'F', 7.0);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (39, 'Barty Gatenby', 'bgatenby12@state.gov', 'MECH', '7/11/2017', 'D', 'C', 5.62);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (40, 'Wylma Von Oertzen', 'wvon13@hud.gov', 'CSE', '9/22/2017', 'A', 'E', 4.25);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (41, 'Nicolette Osichev', 'nosichev14@wunderground.com', 'MECH', '8/5/2017', 'F', 'F', 6.61);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (42, 'Grier Bartkiewicz', 'gbartkiewicz15@narod.ru', 'ECE', '9/14/2017', 'C', 'F', 4.46);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (43, 'Jerry Coplestone', 'jcoplestone16@wordpress.com', 'MECH', '7/20/2017', 'C', 'F', 6.14);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (44, 'Padgett Poultney', 'ppoultney17@census.gov', 'CSE', '2/23/2017', 'H', 'D', 4.38);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (45, 'Odette Coutts', 'ocoutts18@omniture.com', 'EEE', '10/20/2017', 'A', 'F', 6.64);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (46, 'Cleon Guidoni', 'cguidoni19@constantcontact.com', 'CSE', '12/20/2016', 'D', 'D', 5.21);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (47, 'Cameron Leyfield', 'cleyfield1a@rediff.com', 'CIVIL', '7/4/2017', 'C', 'F', 6.68);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (48, 'Guilbert Bucher', 'gbucher1b@cnbc.com', 'EEE', '10/2/2017', 'B', 'D', 8.19);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (49, 'Tomaso Wilson', 'twilson1c@last.fm', 'MECH', '3/31/2017', 'F', 'D', 6.71);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (50, 'Carlota MacAlroy', 'cmacalroy1d@arstechnica.com', 'MECH', '12/2/2016', 'B', 'C', 4.99);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (51, 'Zarah Serridge', 'zserridge1e@amazonaws.com', 'MECH', '9/5/2017', 'B', 'F', 5.67);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (52, 'Beaufort Davidove', 'bdavidove1f@t-online.de', 'CIVIL', '1/7/2017', 'H', 'D', 8.32);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (53, 'Milzie Dubbin', 'mdubbin1g@ihg.com', 'ECE', '12/16/2016', 'F', 'E', 6.03);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (54, 'Boris Sarge', 'bsarge1h@com.com', 'ECE', '5/11/2017', 'C', 'D', 4.59);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (55, 'Sherman Whipple', 'swhipple1i@amazon.co.jp', 'MECH', '2/4/2017', 'G', 'D', 9.01);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (56, 'Fabien Masterson', 'fmasterson1j@ovh.net', 'ECE', '7/20/2017', 'D', 'E', 8.94);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (57, 'Charles Chestle', 'cchestle1k@1und1.de', 'EEE', '5/4/2017', 'H', 'E', 7.66);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (58, 'Eugenius Roden', 'eroden1l@shop-pro.jp', 'MECH', '11/25/2016', 'D', 'A', 5.17);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (59, 'Ugo Blackstock', 'ublackstock1m@jalbum.net', 'MECH', '9/5/2017', 'D', 'D', 4.83);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (60, 'Davie Bertwistle', 'dbertwistle1n@reference.com', 'MECH', '3/16/2017', 'E', 'F', 4.1);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (61, 'Gabi Kilvington', 'gkilvington1o@reuters.com', 'MECH', '9/12/2017', 'A', 'B', 4.96);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (62, 'Caspar Mustarde', 'cmustarde1p@cnn.com', 'CSE', '1/23/2017', 'H', 'E', 6.42);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (63, 'Arlan Spire', 'aspire1q@omniture.com', 'CIVIL', '12/18/2016', 'D', 'C', 6.94);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (64, 'Berta Elstob', 'belstob1r@chron.com', 'CIVIL', '9/12/2017', 'C', 'F', 4.75);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (65, 'Cathrine Ortelt', 'cortelt1s@walmart.com', 'CSE', '1/4/2017', 'B', 'D', 9.14);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (66, 'Gabbi Carabet', 'gcarabet1t@1688.com', 'CSE', '6/9/2017', 'F', 'A', 5.25);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (67, 'Karee Cooksey', 'kcooksey1u@woothemes.com', 'MECH', '8/30/2017', 'C', 'C', 9.2);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (68, 'Glenda Busk', 'gbusk1v@bloglines.com', 'EEE', '3/6/2017', 'G', 'C', 5.11);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (69, 'Annalise Nowakowski', 'anowakowski1w@hatena.ne.jp', 'EEE', '7/12/2017', 'B', 'C', 7.89);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (70, 'Alfie Clatworthy', 'aclatworthy1x@sphinn.com', 'EEE', '4/12/2017', 'D', 'D', 6.1);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (71, 'Ettie Stithe', 'estithe1y@sciencedaily.com', 'MECH', '5/5/2017', 'D', 'F', 7.67);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (72, 'Krishnah Fruchter', 'kfruchter1z@nbcnews.com', 'CSE', '3/12/2017', 'E', 'B', 5.52);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (73, 'Ashlee Brauninger', 'abrauninger20@shop-pro.jp', 'EEE', '10/7/2017', 'G', 'E', 6.61);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (74, 'Rebbecca Powton', 'rpowton21@mapquest.com', 'CSE', '3/15/2017', 'B', 'A', 6.36);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (75, 'Tobey Bony', 'tbony22@google.fr', 'CSE', '4/2/2017', 'B', 'A', 9.16);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (76, 'Elianora Sharper', 'esharper23@tuttocitta.it', 'CIVIL', '9/12/2017', 'A', 'B', 6.87);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (77, 'Delora Jewis', 'djewis24@google.com.au', 'EEE', '10/7/2017', 'B', 'A', 9.03);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (78, 'Alejandrina Meltetal', 'ameltetal25@github.com', 'CSE', '12/2/2016', 'A', 'A', 7.85);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (79, 'Sherrie Brill', 'sbrill26@google.com.br', 'MECH', '11/7/2016', 'D', 'C', 8.35);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (80, 'Rosaline Gasparro', 'rgasparro27@toplist.cz', 'CIVIL', '5/29/2017', 'G', 'C', 7.02);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (81, 'Gray Hiers', 'ghiers28@chron.com', 'CSE', '5/27/2017', 'B', 'D', 9.06);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (82, 'Bertrando Matignon', 'bmatignon29@businessweek.com', 'ECE', '3/10/2017', 'G', 'D', 5.41);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (83, 'Bartholomeus Piniur', 'bpiniur2a@gravatar.com', 'MECH', '9/21/2017', 'H', 'B', 6.37);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (84, 'Sibley Keenlayside', 'skeenlayside2b@prlog.org', 'MECH', '12/11/2016', 'F', 'D', 8.87);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (85, 'Zulema Netting', 'znetting2c@odnoklassniki.ru', 'ECE', '3/5/2017', 'H', 'C', 8.24);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (86, 'Shandra Jonathon', 'sjonathon2d@cbc.ca', 'CSE', '9/18/2017', 'B', 'A', 5.47);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (87, 'Sigismundo Amphlett', 'samphlett2e@blogspot.com', 'ECE', '4/3/2017', 'G', 'C', 4.97);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (88, 'Rafaela Kirwan', 'rkirwan2f@hc360.com', 'MECH', '11/15/2016', 'A', 'D', 6.66);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (89, 'Enriqueta Bedenham', 'ebedenham2g@skyrock.com', 'CIVIL', '12/25/2016', 'B', 'F', 7.76);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (90, 'Carney Richardot', 'crichardot2h@who.int', 'CSE', '9/11/2017', 'H', 'D', 5.97);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (91, 'Fanchon Cleal', 'fcleal2i@google.co.jp', 'CIVIL', '12/10/2016', 'E', 'E', 4.78);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (92, 'Mead Marzello', 'mmarzello2j@digg.com', 'EEE', '1/16/2017', 'E', 'F', 5.02);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (93, 'Keith Wasbey', 'kwasbey2k@home.pl', 'MECH', '2/28/2017', 'D', 'A', 6.78);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (94, 'Mattias Jansson', 'mjansson2l@craigslist.org', 'MECH', '3/28/2017', 'A', 'E', 5.14);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (95, 'Klarika Bone', 'kbone2m@paginegialle.it', 'CSE', '9/26/2017', 'D', 'F', 9.38);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (96, 'Jarred Wait', 'jwait2n@utexas.edu', 'CIVIL', '5/10/2017', 'A', 'F', 9.38);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (97, 'Lilah Keilloh', 'lkeilloh2o@a8.net', 'CIVIL', '8/21/2017', 'D', 'F', 7.92);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (98, 'Trudy Maker', 'tmaker2p@mashable.com', 'CSE', '5/1/2017', 'G', 'F', 5.21);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (99, 'Joanie Piscot', 'jpiscot2q@vinaora.com', 'CSE', '11/8/2016', 'D', 'C', 4.88);
insert into student (studentID, studentName, email, department, birthDate, batch, registeredMess, CGPA) values (100, 'Faulkner Doeg', 'fdoeg2r@wunderground.com', 'CSE', '3/3/2017', 'G', 'F', 9.91);






-- student-has-course --





insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (9, 88, 51, 13, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (20, 58, 57, 2, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (95, 98, 93, 10, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (12, 12, 15, 15, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (44, 66, 76, 14, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (93, 94, 1, 0, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (58, 72, 30, 2, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (94, 54, 82, 15, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (67, 16, 64, 7, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (98, 14, 34, 1, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (55, 1, 67, 7, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (25, 42, 86, 20, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (61, 91, 58, 10, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (27, 25, 21, 19, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (21, 64, 98, 18, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (24, 20, 81, 10, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (73, 60, 55, 9, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (25, 2, 84, 1, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (89, 90, 49, 14, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (85, 4, 53, 16, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (56, 11, 24, 20, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (3, 5, 99, 16, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (60, 100, 3, 17, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (52, 17, 48, 10, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (36, 66, 43, 11, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (17, 25, 15, 14, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (82, 98, 20, 0, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (49, 92, 42, 0, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (42, 23, 79, 10, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (67, 86, 100, 16, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (67, 52, 84, 3, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (23, 52, 48, 4, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (14, 44, 40, 11, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (38, 46, 96, 11, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (75, 88, 67, 18, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (5, 12, 27, 10, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (87, 94, 4, 17, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (58, 25, 33, 20, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (87, 90, 29, 13, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (98, 49, 35, 17, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (64, 86, 14, 19, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (55, 42, 43, 15, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (57, 66, 68, 0, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (81, 77, 94, 10, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (38, 11, 69, 16, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (50, 16, 26, 14, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (26, 56, 78, 0, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (33, 13, 100, 10, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (76, 52, 43, 6, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (94, 63, 6, 13, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (27, 3, 42, 11, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (50, 68, 61, 6, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (46, 91, 86, 4, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (73, 94, 44, 11, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (96, 89, 72, 9, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (90, 28, 64, 2, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (46, 79, 19, 16, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (64, 51, 73, 8, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (66, 34, 23, 20, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (45, 76, 77, 11, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (89, 63, 18, 11, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (48, 93, 30, 3, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (91, 23, 51, 9, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (80, 89, 15, 18, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (17, 91, 46, 7, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (13, 22, 72, 18, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (82, 62, 36, 12, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (50, 40, 28, 8, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (7, 14, 29, 8, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (34, 66, 51, 19, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (14, 28, 67, 1, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (89, 38, 20, 2, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (23, 66, 76, 10, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (22, 1, 96, 15, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (12, 76, 26, 10, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (42, 26, 29, 16, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (63, 93, 38, 3, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (16, 56, 32, 10, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (6, 87, 83, 1, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (62, 37, 94, 11, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (37, 42, 75, 14, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (20, 60, 41, 2, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (18, 16, 79, 8, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (34, 25, 94, 0, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (41, 77, 11, 9, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (96, 33, 58, 10, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (35, 8, 26, 18, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (15, 85, 96, 14, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (68, 52, 72, 6, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (66, 32, 49, 2, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (99, 38, 19, 17, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (20, 15, 45, 1, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (95, 6, 78, 1, 'C');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (80, 60, 76, 9, 'E');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (59, 68, 64, 11, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (89, 75, 7, 2, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (97, 78, 80, 18, 'B');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (66, 67, 84, 2, 'D');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (7, 92, 17, 9, 'A');
insert into student_has_course (studentID, teacherID, courseID, leavesTaken, grade) values (47, 81, 43, 18, 'A');





--