DDL

CREATE DATABASE springboardopt;

USE springboardopt;

-- Student Registration database schema
-- -------------------------------------
CREATE TABLE Student (
	id INT,
	name VARCHAR(255),
	address VARCHAR(255),
	status VARCHAR(255)
);

CREATE TABLE Professor (
	id INT,
	name VARCHAR(255),
	deptId VARCHAR(255)
);

CREATE TABLE Course (
	crsCode VARCHAR(255),
	deptId VARCHAR(255),
	crsName VARCHAR(255)
);

CREATE TABLE Teaching (
	crsCode VARCHAR(255),
	semester VARCHAR(255),
	profId INT
);

CREATE TABLE Transcript (
	studId INT,
	crsCode VARCHAR(255),
	semester VARCHAR(255),
	grade VARCHAR(255)
);


-- Data Population
-- -------------------------------------
INSERT INTO Student (id, name, address, status)
	VALUES (1760637, 'Dominik Bailey', '1497 Domi Ave., PA 451188', 'Junior'),
			(1046898, 'Sienna Foster', '1233 Sien Dr., VA 583009', 'Junior'),
			(1573987, 'Dominik Morris', '1593 Domi St., WA 531918', 'Junior'),
			(1880873, 'Robert Warren', '1531 Robe Dr., TX 520938', 'Senior'),
			(1352778, 'Maddie Craig', '1745 Madd Dr., IA 551170', 'Sophmore'),
			(1571569, 'Charlie Alexander', '970 Char St., MI 579384', 'Sophmore'),
			(1661978, 'Lucas Tucker', '1169 Luca Cir., MN 712264', 'Sophmore'),
			(1430350, 'Albert Richardson', '1544 Albe St., OR 826310', 'Sophmore'),
			(1047037, 'Marcus Williams', '1105 Marc Dr., NY 104533', 'Junior'),
			(1368678, 'Harold Brown', '796 Haro Ave., IL 932424', 'Senior'),
			(1313014, 'Elian Martin', '1444 Elia Dr., ME 649106', 'Freshman'),
			(1617433, 'Kirsten Anderson', '646 Kirs Dr., WV 788752', 'Junior'),
			(1778033, 'Haris Perkins', '153 Hari Dr., MN 716369', 'Sophmore'),
			(1476153, 'Julia Campbell', '629 Juli St., MN 943718', 'Sophmore'),
			(1436960, 'Paige Riley', '1163 Paig Dr., IA 832644', 'Junior'),
			(1726202, 'Abraham Mitchell', '1957 Abra Ave., NJ 868287', 'Senior'),
			(1725794, 'Jordan Phillips', '209 Jord Ave., RI 904197', 'Senior'),
			(1059879, 'Brianna Armstrong', '483 Bria St., OH 214707', 'Freshman'),
			(1076785, 'Arnold Bailey', '1788 Arno Dr., IA 957487', 'Junior'),
			(1634044, 'Aiden Nelson', '1501 Aide Dr., SD 93441', 'Senior'),
			(1296642, 'Melissa Brooks', '241 Meli Cir., AL 268290', 'Junior'),
			(1852678, 'Tara Harrison', '1745 Tara Ave., NM 723412', 'Junior'),
			(1235479, 'Tess Roberts', '1674 Tess St., MO 706096', 'Junior'),
			(1688059, 'Alexia Rogers', '1742 Alex Ave., NC 166670', 'Freshman'),
			(1199918, 'Jack Jones', '886 Jack Cir., WA 205818', 'Senior'),
			(1416804, 'Amber Hill', '1885 Ambe St., TN 234013', 'Junior'),
			(1341653, 'Emily Barrett', '306 Emil Dr., TN 361897', 'Senior'),
			(1458842, 'Samantha Evans', '1438 Sama Ave., PA 161101', 'Senior'),
			(1699121, 'Paige Clark', '1053 Paig Cir., ND 675633', 'Freshman'),
			(1323368, 'Jared Kelley', '1802 Jare Cir., MT 618402', 'Senior'),
			(1849994, 'Ryan Jones', '1328 Ryan Dr., MD 748534', 'Freshman'),
			(1151712, 'Brooke Thompson', '1738 Broo St., WA 506732', 'Sophmore'),
			(1081033, 'Ryan Douglas', '1177 Ryan Ave., FL 205344', 'Junior'),
			(1861651, 'Deanna Holmes', '1325 Dean Ave., VT 106396', 'Sophmore'),
			(1234100, 'Madaline Davis', '1972 Mada Dr., ND 778722', 'Junior'),
			(1631747, 'Luke Elliott', '1218 Luke Ave., ME 522129', 'Freshman'),
			(1425119, 'Heather Crawford', '1656 Heat Cir., UT 808875', 'Freshman'),
			(1647861, 'Maria Howard', '818 Mari Dr., CA 34940', 'Junior'),
			(1473468, 'Miller Craig', '1374 Mill Ave., MI 226438', 'Freshman'),
			(1216047, 'Sienna Mitchell', '1155 Sien St., ME 17649', 'Sophmore'),
			(1613619, 'Amanda Davis', '666 Aman Dr., LA 463113', 'Junior'),
			(1190482, 'Ada Ross', '113 Ada  St., AZ 510576', 'Freshman'),
			(1944146, 'Briony Carter', '1053 Brio Dr., WI 606933', 'Senior'),
			(1802322, 'Jack Miller', '901 Jack Cir., NE 977606', 'Junior'),
			(1324784, 'Rafael Barnes', '391 Rafa Cir., HI 454065', 'Sophmore'),
			(1528730, 'John Farrell', '1418 John St., WI 439898', 'Freshman'),
			(1641132, 'Cherry Elliott', '1406 Cher Dr., MO 243883', 'Junior'),
			(1063890, 'Samantha Walker', '1049 Sama Cir., NE 407603', 'Junior'),
			(1461531, 'Eddy Murphy', '1448 Eddy St., MS 310726', 'Junior'),
			(1902493, 'Leonardo Hall', '2000 Leon Dr., NV 191476', 'Freshman'),
			(1690567, 'Roland Edwards', '1241 Rola Cir., WA 622021', 'Sophmore'),
			(1704791, 'Lily Ryan', '511 Lily St., OH 876342', 'Sophmore'),
			(1455978, 'Eric Bennett', '1760 Eric Ave., NH 336164', 'Junior'),
			(1721662, 'Kristian Higgins', '640 Kris Dr., IA 919494', 'Sophmore'),
			(1274264, 'Lilianna Brown', '1684 Lili Ave., ID 209782', 'Senior'),
			(1235943, 'Jessica Ryan', '1343 Jess Cir., TX 982978', 'Sophmore'),
			(1258537, 'Max Davis', '864 Max  Dr., CO 852686', 'Freshman'),
			(1266652, 'Edgar Barnes', '253 Edga Ave., KS 708659', 'Sophmore'),
			(1108533, 'Dexter Howard', '605 Dext Dr., AZ 486029', 'Sophmore'),
			(1656765, 'Lydia Holmes', '1985 Lydi St., OK 402495', 'Junior'),
			(1523816, 'Emma Adams', '1117 Emma Ave., WV 610116', 'Freshman'),
			(1331232, 'Dexter Barrett', '1830 Dext Ave., NY 632856', 'Sophmore'),
			(1268689, 'Lucia Warren', '1860 Luci Cir., ID 842281', 'Freshman'),
			(1855954, 'Tess Crawford', '1512 Tess Dr., SD 194541', 'Freshman'),
			(1931856, 'Maddie Brown', '1477 Madd Dr., AR 539692', 'Junior'),
			(1194534, 'Kristian Thompson', '1191 Kris Cir., IA 751400', 'Junior'),
			(1897694, 'Stuart Crawford', '1241 Stua Dr., WI 430698', 'Junior'),
			(1597246, 'Carina Barnes', '961 Cari Dr., NM 89459', 'Junior'),
			(1913032, 'Nicholas Riley', '1064 Nich Ave., OH 239955', 'Sophmore'),
			(1201702, 'Miley Cunningham', '1486 Mile St., OR 990515', 'Sophmore'),
			(1001818, 'Briony Tucker', '1364 Brio Cir., SD 392986', 'Freshman'),
			(1309298, 'Maddie Cooper', '1673 Madd St., NV 56770', 'Senior'),
			(1968909, 'Alford Thompson', '411 Alfo St., NM 276776', 'Freshman'),
			(1324248, 'Adele Morgan', '1195 Adel Dr., WI 127050', 'Junior'),
			(1715811, 'Abigail Farrell', '1887 Abig Dr., HI 979386', 'Senior'),
			(1931305, 'Steven Mitchell', '832 Stev Ave., MA 744068', 'Senior'),
			(1235571, 'Garry Spencer', '1511 Garr St., NV 832383', 'Freshman'),
			(1728644, 'James Mitchell', '106 Jame St., UT 891809', 'Junior'),
			(1850932, 'Victor Dixon', '1575 Vict Dr., AK 951976', 'Sophmore'),
			(1612521, 'Eddy Harrison', '322 Eddy St., AZ 918812', 'Junior'),
			(1029240, 'Nicholas Hawkins', '1471 Nich Cir., ID 317349', 'Junior'),
			(1816679, 'Maya Campbell', '178 Maya Dr., NV 782156', 'Freshman'),
			(1536642, 'Ada Cooper', '1916 Ada  Ave., PA 607719', 'Freshman'),
			(1371268, 'Amber Tucker', '537 Ambe Cir., DE 785609', 'Sophmore'),
			(1868396, 'Abraham Hill', '1145 Abra St., NV 956587', 'Sophmore'),
			(1404490, 'Adelaide Moore', '1139 Adel St., WV 504884', 'Junior'),
			(1516523, 'Victoria Davis', '308 Vict Dr., WI 38559', 'Sophmore'),
			(1790801, 'Ryan Gray', '1669 Ryan Dr., AK 328249', 'Senior'),
			(1766226, 'Eric Morrison', '123 Eric St., CA 47973', 'Freshman'),
			(1055826, 'Alina Brooks', '1737 Alin Dr., CT 969038', 'Senior'),
			(1845496, 'Vivian Bennett', '1109 Vivi Dr., WA 761762', 'Senior'),
			(1199699, 'Evelyn Moore', '530 Evel Dr., CT 486253', 'Senior'),
			(1654029, 'Emily Phillips', '1506 Emil Dr., MO 543389', 'Junior'),
			(1560203, 'Adele Stevens', '102 Adel Cir., FL 955243', 'Sophmore'),
			(1585923, 'Joyce Robinson', '1083 Joyc Dr., SC 937977', 'Senior'),
			(1159230, 'Sabrina Ross', '1464 Sabr Ave., NY 757115', 'Freshman'),
			(1780328, 'James Andrews', '1542 Jame Dr., PA 684856', 'Junior'),
			(1575173, 'Albert Kelly', '843 Albe Cir., AL 631013', 'Junior'),
			(1269340, 'Olivia Craig', '478 Oliv Dr., VT 715012', 'Senior'),
			(1087211, 'Vincent Anderson', '550 Vinc St., VT 249085', 'Sophmore'),
			(1601982, 'Alisa Reed', '288 Alis Cir., DE 475572', 'Senior'),
			(1739811, 'Ned Hawkins', '1624 Ned  St., UT 870664', 'Junior'),
			(1117633, 'Paige Cole', '1442 Paig Cir., LA 824672', 'Freshman'),
			(1186544, 'Camila Spencer', '1581 Cami Ave., IA 945960', 'Junior'),
			(1430495, 'James Kelly', '1941 Jame Dr., SC 952903', 'Freshman'),
			(1395845, 'Amanda Martin', '950 Aman Ave., MN 789163', 'Senior'),
			(1945157, 'Chloe Baker', '1605 Chlo Ave., SD 187630', 'Junior'),
			(1802158, 'Sofia Phillips', '378 Sofi Cir., GA 14177', 'Freshman'),
			(1093690, 'Alen Elliott', '1337 Alen Dr., HI 173288', 'Senior'),
			(1058697, 'Tara Brown', '647 Tara Cir., OK 284060', 'Senior'),
			(1013712, 'Maddie Cole', '1134 Madd Dr., NC 713969', 'Freshman'),
			(1355191, 'Roman Johnson', '312 Roma St., CA 25126', 'Freshman'),
			(1520643, 'Maya Stevens', '615 Maya Cir., NH 754664', 'Sophmore'),
			(1612992, 'Dale Martin', '1426 Dale St., NV 691126', 'Freshman'),
			(1494868, 'Max Baker', '1089 Max  Dr., MN 613974', 'Freshman'),
			(1713180, 'Martin Carroll', '592 Mart Ave., NV 267142', 'Freshman'),
			(1200763, 'Dominik Jones', '206 Domi Cir., NY 144870', 'Senior'),
			(1124956, 'Robert Evans', '678 Robe Cir., WA 679470', 'Freshman'),
			(1492370, 'Aldus Watson', '1636 Aldu Cir., KS 28366', 'Junior'),
			(1874861, 'Camila Crawford', '1400 Cami Cir., SC 318018', 'Senior'),
			(1425316, 'Catherine Howard', '440 Cath Ave., WI 490665', 'Junior'),
			(1870459, 'Elise Taylor', '500 Elis Cir., CT 743397', 'Freshman'),
			(1875045, 'Elian Wright', '299 Elia Dr., MD 474588', 'Senior'),
			(1982505, 'Madaline Morgan', '1811 Mada Cir., AR 914017', 'Sophmore'),
			(1087081, 'Oliver Alexander', '1068 Oliv Cir., KS 261150', 'Junior'),
			(1035280, 'Alberta Dixon', '1498 Albe Cir., MO 568652', 'Junior'),
			(1150282, 'Olivia Phillips', '122 Oliv Dr., CT 505501', 'Sophmore'),
			(1148656, 'Kate Carroll', '247 Kate Dr., GA 111384', 'Freshman'),
			(1927089, 'Dexter Stevens', '1396 Dext Cir., UT 467487', 'Sophmore'),
			(1472367, 'Thomas Andrews', '657 Thom Ave., CT 536936', 'Junior'),
			(1710702, 'Justin Hunt', '1022 Just Cir., WV 230549', 'Senior'),
			(1619647, 'Dainton Moore', '1204 Dain Ave., AR 419463', 'Junior'),
			(1212921, 'Sam Roberts', '944 Sam  Cir., NE 377561', 'Senior'),
			(1967660, 'Grace Brooks', '259 Grac Cir., DE 250337', 'Freshman'),
			(1460496, 'Alford Hall', '1627 Alfo Dr., SD 329762', 'Freshman'),
			(1311488, 'Edgar Morgan', '1786 Edga Dr., OH 339935', 'Junior'),
			(1917864, 'Emma Sullivan', '1560 Emma Ave., OR 842125', 'Sophmore'),
			(1513143, 'Lucas Rogers', '1231 Luca Dr., NE 682151', 'Junior'),
			(1334059, 'Rebecca Owens', '681 Rebe Ave., RI 271666', 'Freshman'),
			(1046515, 'Sienna Chapman', '629 Sien Cir., MT 532488', 'Sophmore'),
			(1276496, 'Lily Kelly', '875 Lily St., TX 412319', 'Junior'),
			(1004289, 'Brooke Morris', '514 Broo Dr., ME 405682', 'Freshman'),
			(1456808, 'Garry Andrews', '919 Garr Cir., TX 430205', 'Senior'),
			(1090885, 'Mike Fowler', '765 Mike St., MN 927348', 'Junior'),
			(1574155, 'Caroline Barnes', '1035 Caro St., OR 42527', 'Junior'),
			(1331037, 'Vanessa Harris', '683 Vane Cir., IA 277623', 'Senior'),
			(1451724, 'Owen Howard', '362 Owen Cir., CO 962048', 'Senior'),
			(1258557, 'Melissa Richards', '1449 Meli Dr., AK 634007', 'Sophmore'),
			(1384106, 'Savana Hunt', '1841 Sava Ave., NJ 474666', 'Junior'),
			(1103959, 'Spike Higgins', '1073 Spik Dr., RI 297481', 'Senior'),
			(1721498, 'Tess Armstrong', '683 Tess Cir., KS 928507', 'Freshman'),
			(1248713, 'Naomi Ellis', '773 Naom Ave., MA 834134', 'Sophmore'),
			(1702025, 'Dainton Phillips', '912 Dain St., VA 146715', 'Senior'),
			(1719162, 'Violet Montgomery', '179 Viol Dr., HI 104788', 'Sophmore'),
			(1728230, 'Adison Carter', '1653 Adis St., AR 418817', 'Freshman'),
			(1927903, 'Clark Wilson', '1295 Clar Dr., RI 803924', 'Freshman'),
			(1679265, 'Valeria Barnes', '1372 Vale St., IN 674948', 'Sophmore'),
			(1739214, 'Myra Miller', '1124 Myra St., HI 593953', 'Freshman'),
			(1314569, 'Garry Hamilton', '1546 Garr Ave., KY 218435', 'Sophmore'),
			(1359717, 'Aston Walker', '1845 Asto Cir., FL 332762', 'Sophmore'),
			(1028675, 'Tiana Owens', '1441 Tian Dr., OK 537234', 'Sophmore'),
			(1336713, 'Tiana Gibson', '1421 Tian Cir., CA 888712', 'Freshman'),
			(1361231, 'Kevin Cooper', '1849 Kevi St., OK 371096', 'Junior'),
			(1489719, 'Leonardo Elliott', '698 Leon St., OH 700631', 'Sophmore'),
			(1818058, 'Isabella Walker', '123 Isab Cir., WA 975209', 'Sophmore'),
			(1730903, 'Edgar Cunningham', '1460 Edga St., NC 509282', 'Sophmore'),
			(1926170, 'Cadie Stevens', '1434 Cadi Cir., GA 779636', 'Junior'),
			(1232967, 'Dale Riley', '1601 Dale Ave., IA 760996', 'Freshman'),
			(1485284, 'Jenna Cole', '1778 Jenn Dr., FL 174343', 'Sophmore'),
			(1121520, 'Amelia Barrett', '1132 Amel Ave., CO 980353', 'Junior'),
			(1394729, 'Rubie Myers', '1440 Rubi Cir., NE 606640', 'Junior'),
			(1065063, 'Amanda Thomas', '1788 Aman Ave., NM 203855', 'Sophmore'),
			(1236202, 'Connie Armstrong', '517 Conn Ave., LA 239751', 'Sophmore'),
			(1101617, 'Haris Harper', '1481 Hari Cir., GA 456452', 'Junior'),
			(1286008, 'Dominik Barnes', '1175 Domi Ave., FL 328200', 'Sophmore'),
			(1221508, 'Sabrina Morrison', '1415 Sabr Ave., ID 551624', 'Sophmore'),
			(1847058, 'Owen Harper', '1991 Owen St., IN 538421', 'Senior'),
			(1325566, 'Paul Rogers', '1216 Paul St., FL 845458', 'Sophmore'),
			(1717465, 'John Morris', '1550 John Ave., NJ 66500', 'Junior'),
			(1789049, 'Lucy Hill', '1983 Lucy St., PA 562370', 'Senior'),
			(1481351, 'Victoria Carroll', '1654 Vict Dr., VT 895548', 'Sophmore'),
			(1078101, 'Chloe Hall', '1433 Chlo Dr., NE 79837', 'Sophmore'),
			(1309368, 'Vincent Henderson', '286 Vinc St., CO 943012', 'Freshman'),
			(1235547, 'Dale Dixon', '1062 Dale Dr., MI 729770', 'Senior'),
			(1521419, 'Walter Barnes', '780 Walt Dr., TX 555229', 'Freshman'),
			(1170338, 'Daniel Foster', '1098 Dani Dr., TN 360403', 'Senior'),
			(1372897, 'Lenny Ross', '125 Lenn Cir., CT 10349', 'Sophmore'),
			(1223553, 'Mike Perkins', '1754 Mike Cir., NE 922009', 'Sophmore'),
			(1109421, 'Maximilian Sullivan', '1155 Maxi Dr., IA 148238', 'Sophmore'),
			(1580853, 'Daniel Owens', '1775 Dani Dr., OK 22454', 'Senior'),
			(1695137, 'Lilianna Mason', '112 Lili Dr., SC 941945', 'Senior'),
			(1422796, 'Abigail Gibson', '771 Abig Ave., HI 537090', 'Junior'),
			(1147579, 'Stuart Farrell', '1240 Stua Dr., OH 95375', 'Freshman'),
			(1627203, 'Dale Campbell', '1632 Dale Ave., ID 814076', 'Freshman'),
			(1932998, 'Victoria Sullivan', '568 Vict Cir., VA 494171', 'Senior'),
			(1786233, 'Jack Wright', '241 Jack Dr., NV 696498', 'Freshman'),
			(1016811, 'Audrey Hawkins', '1206 Audr St., OK 83009', 'Freshman'),
			(1969137, 'Lyndon Evans', '1698 Lynd Dr., MO 528780', 'Sophmore'),
			(1690947, 'Eric Mason', '1588 Eric Ave., MA 838799', 'Junior'),
			(1376959, 'Preston Wright', '1692 Pres Ave., MT 490364', 'Junior'),
			(1546815, 'Lyndon Reed', '1469 Lynd St., AL 562611', 'Freshman'),
			(1736442, 'Alen Perry', '171 Alen Cir., GA 961616', 'Sophmore'),
			(1822187, 'Natalie Cunningham', '100 Nata Ave., MN 68893', 'Senior'),
			(1418607, 'Max Richardson', '1560 Max  Cir., ID 971564', 'Junior'),
			(1724216, 'Melanie Wright', '302 Mela St., FL 78734', 'Senior'),
			(1842985, 'Arnold Anderson', '575 Arno Dr., PA 555447', 'Senior'),
			(1100927, 'Vanessa Richards', '532 Vane Ave., WI 375733', 'Sophmore'),
			(1748309, 'Kelvin Wells', '1585 Kelv Dr., FL 316275', 'Sophmore'),
			(1678359, 'Audrey Ross', '1075 Audr Dr., WV 415397', 'Freshman'),
			(1022665, 'Kellan Barnes', '1987 Kell Ave., NH 237026', 'Senior'),
			(1678412, 'Chelsea Reed', '124 Chel St., AZ 891290', 'Junior'),
			(1457049, 'Kelvin Adams', '1015 Kelv Cir., LA 650482', 'Senior'),
			(1234886, 'Stella Myers', '1384 Stel St., AL 110172', 'Sophmore'),
			(1307536, 'Wilson Myers', '1897 Wils Cir., NE 257871', 'Junior'),
			(1366485, 'Arthur Wright', '1277 Arth Dr., NM 798142', 'Sophmore'),
			(1112946, 'Maximilian Phillips', '1090 Maxi Ave., CO 486171', 'Sophmore'),
			(1122032, 'Ryan Perry', '1304 Ryan Dr., KY 419465', 'Junior'),
			(1831078, 'Camila Carter', '557 Cami Cir., UT 332581', 'Sophmore'),
			(1198161, 'Alford Hall', '199 Alfo Dr., MO 711955', 'Sophmore'),
			(1087885, 'Amanda Anderson', '855 Aman Cir., MS 361420', 'Freshman'),
			(1823973, 'Charlotte Spencer', '1518 Char Dr., UT 32315', 'Sophmore'),
			(1080304, 'Alexia Henderson', '1169 Alex Ave., OK 727682', 'Freshman'),
			(1407674, 'Catherine Wells', '554 Cath Dr., MD 976537', 'Senior'),
			(1623236, 'Vincent Warren', '981 Vinc Cir., MS 189075', 'Senior'),
			(1580067, 'Sam Richards', '1403 Sam  St., FL 165601', 'Sophmore'),
			(1702542, 'Garry Hamilton', '1359 Garr Cir., UT 194031', 'Freshman'),
			(1747958, 'Alina Hall', '570 Alin Ave., PA 535826', 'Senior'),
			(1784218, 'Eddy Rogers', '1414 Eddy Cir., MN 336350', 'Junior'),
			(1595672, 'Cadie Edwards', '324 Cadi St., NC 617465', 'Freshman'),
			(1243016, 'Alisa Williams', '1138 Alis Dr., NV 510039', 'Sophmore'),
			(1578072, 'Myra Wells', '733 Myra Ave., IN 817578', 'Junior'),
			(1198491, 'Lucy Perkins', '1972 Lucy Ave., OK 948763', 'Sophmore'),
			(1986680, 'Amy Rogers', '1545 Amy  Cir., NE 727195', 'Senior'),
			(1203429, 'Hailey Armstrong', '720 Hail Ave., WV 354703', 'Junior'),
			(1099644, 'Naomi Stevens', '1254 Naom Cir., NY 277420', 'Junior'),
			(1052121, 'Stuart Martin', '1714 Stua Cir., KY 616474', 'Senior'),
			(1591193, 'Naomi Alexander', '1130 Naom Cir., AZ 296552', 'Sophmore'),
			(1815571, 'Henry Payne', '420 Henr Ave., ID 329143', 'Freshman'),
			(1988603, 'Valeria Brown', '686 Vale Cir., KS 129241', 'Freshman'),
			(1046363, 'Cadie Stewart', '128 Cadi Ave., WI 392172', 'Freshman'),
			(1753943, 'Alfred Ellis', '481 Alfr St., NY 143374', 'Sophmore'),
			(1100618, 'Ned Johnston', '692 Ned  Ave., ND 958459', 'Junior'),
			(1994431, 'Robert Carroll', '902 Robe Dr., NC 460283', 'Junior'),
			(1172436, 'Brooke Douglas', '750 Broo Dr., WI 550420', 'Freshman'),
			(1504750, 'Rebecca Phillips', '1797 Rebe Ave., MS 516277', 'Junior'),
			(1742779, 'Sydney Craig', '1692 Sydn Dr., VT 154760', 'Senior'),
			(1772292, 'Clark Richardson', '671 Clar Cir., IA 323795', 'Junior'),
			(1670210, 'Patrick Johnson', '1233 Patr Ave., TX 501416', 'Sophmore'),
			(1949625, 'Maria Jones', '516 Mari Ave., MD 29411', 'Junior'),
			(1785388, 'Stuart Kelly', '1465 Stua St., NY 414357', 'Senior'),
			(1607474, 'Melanie Thomas', '1455 Mela Cir., OK 412596', 'Sophmore'),
			(1145072, 'Briony Moore', '1769 Brio Cir., NH 934202', 'Senior'),
			(1885975, 'Amber Casey', '1980 Ambe St., MS 847894', 'Freshman'),
			(1703776, 'Harold Perkins', '844 Haro Ave., TX 605137', 'Junior'),
			(1561263, 'Brad Hamilton', '1394 Brad St., MD 28032', 'Junior'),
			(1427087, 'Alisa Adams', '888 Alis Cir., OH 817199', 'Freshman'),
			(1585668, 'Kristian Davis', '1011 Kris Ave., MO 671244', 'Sophmore'),
			(1845914, 'Bruce Williams', '926 Bruc St., HI 541613', 'Senior'),
			(1633919, 'Wilson Robinson', '1777 Wils Cir., DE 415490', 'Freshman'),
			(1510552, 'Charlie Farrell', '511 Char St., IN 156421', 'Freshman'),
			(1429139, 'Oliver Cole', '1711 Oliv Cir., SD 183075', 'Junior'),
			(1666116, 'Edgar Henderson', '1524 Edga Ave., AR 229016', 'Freshman'),
			(1968843, 'Miley Baker', '1317 Mile St., VT 675795', 'Senior'),
			(1469693, 'Daisy Wright', '1171 Dais Ave., MS 911489', 'Freshman'),
			(1116805, 'Sawyer Wright', '1984 Sawy Ave., AR 368752', 'Senior'),
			(1618766, 'Reid Scott', '1455 Reid Cir., WI 579920', 'Senior'),
			(1686198, 'Mike Gray', '1629 Mike Cir., OH 232017', 'Senior'),
			(1407827, 'William Mason', '1791 Will Dr., IN 36977', 'Sophmore'),
			(1828467, 'Cadie Payne', '598 Cadi Dr., AK 96185', 'Senior'),
			(1949839, 'Stella Howard', '313 Stel Ave., WI 335444', 'Freshman'),
			(1849415, 'Naomi Bailey', '1678 Naom Dr., RI 586752', 'Junior'),
			(1194873, 'Byron Edwards', '1318 Byro Cir., MO 503231', 'Senior'),
			(1790187, 'Vincent Morris', '289 Vinc Dr., CA 481828', 'Freshman'),
			(1036981, 'Tara Watson', '1269 Tara St., NM 616158', 'Freshman'),
			(1756196, 'Leonardo Alexander', '1427 Leon Ave., NH 260316', 'Sophmore'),
			(1584001, 'Agata Carroll', '1837 Agat Ave., DE 778506', 'Senior'),
			(1901668, 'Kelvin Foster', '455 Kelv Dr., DE 804494', 'Freshman'),
			(1684802, 'Luke Mason', '1856 Luke Dr., VA 157910', 'Sophmore'),
			(1003118, 'Alford Bennett', '712 Alfo Dr., IL 95143', 'Freshman'),
			(1150267, 'Bruce Campbell', '764 Bruc Dr., OK 480920', 'Junior'),
			(1602063, 'Oscar Alexander', '362 Osca St., AR 438160', 'Sophmore'),
			(1995622, 'Fenton Nelson', '122 Fent Ave., CO 763761', 'Senior'),
			(1551247, 'Jacob Harrison', '287 Jaco Ave., TX 185352', 'Senior'),
			(1933793, 'Melissa Ferguson', '1662 Meli Dr., NC 676598', 'Junior'),
			(1322173, 'Martin Hamilton', '1724 Mart Cir., ME 712594', 'Sophmore'),
			(1677550, 'David Elliott', '685 Davi Ave., SC 458828', 'Freshman'),
			(1805480, 'Sarah Craig', '1403 Sara Ave., IN 708692', 'Junior'),
			(1767402, 'Charlotte Phillips', '1964 Char Cir., AK 692747', 'Freshman'),
			(1905054, 'Grace Chapman', '1808 Grac Cir., UT 300352', 'Senior'),
			(1072419, 'Lilianna Jones', '1583 Lili Ave., ND 646999', 'Junior'),
			(1311441, 'Patrick Alexander', '285 Patr Dr., DE 148531', 'Senior'),
			(1377647, 'Rosie Craig', '1324 Rosi Ave., NH 355783', 'Senior'),
			(1165736, 'Lucia Higgins', '893 Luci Cir., FL 136893', 'Sophmore'),
			(1635061, 'Ted Martin', '368 Ted  Cir., WV 336422', 'Junior'),
			(1418924, 'Caroline Edwards', '464 Caro Ave., MS 735884', 'Sophmore'),
			(1127877, 'Arthur Russell', '203 Arth Dr., DE 164506', 'Sophmore'),
			(1393518, 'Lenny Myers', '458 Lenn St., OK 131886', 'Senior'),
			(1058047, 'Charlotte Harrison', '955 Char Cir., WV 253577', 'Junior'),
			(1216342, 'Preston Miller', '1598 Pres Cir., IL 850318', 'Junior'),
			(1815967, 'Tyler Ross', '1982 Tyle St., NE 58108', 'Sophmore'),
			(1303782, 'Stuart Williams', '161 Stua St., OK 353081', 'Senior'),
			(1793441, 'Caroline Barnes', '1860 Caro Cir., MS 751185', 'Junior'),
			(1598604, 'Sofia Payne', '1839 Sofi Dr., SD 446947', 'Junior'),
			(1791382, 'Miller Morris', '1663 Mill Dr., WA 770829', 'Junior'),
			(1933818, 'Eleanor Myers', '1011 Elea St., NE 533855', 'Senior'),
			(1666755, 'Dexter Gray', '1219 Dext Dr., CO 280180', 'Junior'),
			(1676500, 'Steven Adams', '200 Stev St., VT 407317', 'Sophmore'),
			(1626486, 'Preston Phillips', '815 Pres St., RI 688163', 'Sophmore'),
			(1357552, 'Melanie Myers', '1054 Mela Cir., HI 842110', 'Senior'),
			(1683991, 'Andrew Roberts', '498 Andr Cir., OK 539712', 'Senior'),
			(1485352, 'Edward Wilson', '898 Edwa Dr., ID 866812', 'Senior'),
			(1866559, 'Miller Grant', '482 Mill Cir., CA 725755', 'Senior'),
			(1589438, 'Victoria Harrison', '645 Vict Dr., ME 712955', 'Freshman'),
			(1516791, 'Albert Myers', '550 Albe St., FL 771169', 'Senior'),
			(1249935, 'Jessica Perry', '1141 Jess Cir., OH 708733', 'Senior'),
			(1235039, 'Arthur Turner', '1609 Arth Dr., VT 240908', 'Sophmore'),
			(1176368, 'Caroline Riley', '715 Caro Cir., ND 724284', 'Sophmore'),
			(1021349, 'Amelia Davis', '1925 Amel St., FL 636417', 'Freshman'),
			(1140756, 'Oscar Wilson', '1164 Osca Cir., IA 928428', 'Freshman'),
			(1803689, 'Michelle Spencer', '1438 Mich Dr., AL 102566', 'Junior'),
			(1369141, 'Nicole Lloyd', '1014 Nico Dr., OR 65402', 'Sophmore'),
			(1686631, 'Joyce Robinson', '1708 Joyc Ave., MI 61762', 'Junior'),
			(1561912, 'Oliver Douglas', '1283 Oliv St., SD 517372', 'Junior'),
			(1958638, 'Chester Carroll', '1316 Ches Dr., SD 285580', 'Freshman'),
			(1211768, 'Clark Hunt', '332 Clar Cir., WA 417752', 'Junior'),
			(1970160, 'Sienna Carter', '1762 Sien Dr., CO 256233', 'Senior'),
			(1138219, 'Jared Howard', '1122 Jare St., ND 300069', 'Senior'),
			(1498874, 'Arnold Kelley', '1364 Arno Ave., FL 539470', 'Junior'),
			(1350347, 'Nicholas Moore', '384 Nich Cir., GA 890258', 'Freshman'),
			(1818334, 'Violet Baker', '385 Viol Dr., ID 103757', 'Junior'),
			(1197138, 'Dale Carroll', '152 Dale Dr., NV 189731', 'Freshman'),
			(1537359, 'Clark Ferguson', '929 Clar St., MS 997249', 'Junior'),
			(1140222, 'Freddie Williams', '915 Fred St., OR 874615', 'Senior'),
			(1468052, 'Roland Riley', '1219 Rola Dr., AL 904195', 'Freshman'),
			(1126206, 'Kristian Hall', '622 Kris Dr., IL 173907', 'Sophmore'),
			(1215368, 'Elise Andrews', '1867 Elis Cir., NM 695552', 'Sophmore'),
			(1085026, 'Cadie Carter', '141 Cadi Ave., NY 994647', 'Sophmore'),
			(1989622, 'Deanna Allen', '1231 Dean Cir., VT 612598', 'Senior'),
			(1380306, 'Kevin Riley', '1075 Kevi Cir., CO 904987', 'Freshman'),
			(1038977, 'Kellan Elliott', '154 Kell Cir., CO 549679', 'Sophmore'),
			(1942635, 'Kimberly Craig', '866 Kimb Dr., DE 646490', 'Freshman'),
			(1601723, 'Chester Hill', '635 Ches Cir., AZ 895585', 'Freshman'),
			(1234056, 'Elise Roberts', '383 Elis Cir., TX 267427', 'Freshman'),
			(1988838, 'Gianna Casey', '1020 Gian St., ND 33533', 'Junior'),
			(1778215, 'Michael Henderson', '838 Mich Dr., TX 530720', 'Sophmore'),
			(1619553, 'Connie Davis', '732 Conn Dr., AK 384631', 'Senior'),
			(1001914, 'Victor Morgan', '1862 Vict Cir., AZ 336366', 'Freshman'),
			(1775553, 'Deanna Baker', '1171 Dean St., TX 914151', 'Freshman'),
			(1385922, 'Preston Smith', '1574 Pres Dr., AZ 240768', 'Sophmore'),
			(1272789, 'Lucia Kelly', '1909 Luci Ave., CA 772909', 'Sophmore'),
			(1302967, 'Roman Hamilton', '1756 Roma Ave., AZ 734186', 'Junior'),
			(1139379, 'Adrianna Grant', '829 Adri Cir., TX 449220', 'Junior'),
			(1071691, 'Eddy Campbell', '1848 Eddy Dr., MS 718035', 'Freshman'),
			(1767047, 'Violet Perkins', '1981 Viol St., CO 262497', 'Freshman'),
			(1974474, 'Mike Parker', '1492 Mike Cir., KY 994805', 'Freshman'),
			(1948731, 'Adrianna Armstrong', '166 Adri Ave., WV 215372', 'Junior'),
			(1672729, 'Eleanor Russell', '583 Elea Dr., NH 845496', 'Junior'),
			(1786912, 'Brad Farrell', '1015 Brad St., VA 93514', 'Junior'),
			(1961949, 'Olivia Martin', '1009 Oliv Ave., MN 741814', 'Junior'),
			(1510352, 'Martin Armstrong', '1552 Mart Ave., HI 90167', 'Junior'),
			(1127112, 'Elise Alexander', '1043 Elis Cir., LA 313287', 'Senior'),
			(1003136, 'Lydia Richards', '1949 Lydi Dr., MO 892182', 'Freshman'),
			(1881611, 'Miley Gray', '1477 Mile St., IL 568738', 'Sophmore'),
			(1381296, 'Anna Ferguson', '1113 Anna Dr., MI 958203', 'Junior'),
			(1975704, 'Arthur Stewart', '1683 Arth Ave., TN 349118', 'Sophmore'),
			(1520539, 'Jasmine Harris', '1421 Jasm Cir., KY 472921', 'Freshman'),
			(1246442, 'Emily Richardson', '827 Emil Cir., NV 81655', 'Sophmore'),
			(1566470, 'Alissa Clark', '983 Alis Ave., DE 128414', 'Junior'),
			(1056303, 'Carina Miller', '945 Cari Cir., NE 336678', 'Sophmore'),
			(1835616, 'Aston Wells', '624 Asto Ave., VT 667151', 'Junior'),
			(1732033, 'Abigail Anderson', '1537 Abig Dr., KS 858756', 'Junior'),
			(1270008, 'Honey Higgins', '1080 Hone Cir., VT 108560', 'Junior'),
			(1885676, 'Alen Johnston', '1656 Alen Ave., OR 721099', 'Senior'),
			(1734687, 'Brooke Nelson', '889 Broo Ave., AR 38648', 'Junior'),
			(1775852, 'Stuart Morris', '316 Stua Cir., TX 498144', 'Freshman'),
			(1769186, 'Aldus Wright', '1716 Aldu Ave., NJ 715604', 'Freshman'),
			(1443582, 'Arianna Ross', '1346 Aria Dr., OK 179166', 'Sophmore'),
			(1409876, 'Camila Edwards', '1449 Cami Ave., WI 963662', 'Sophmore'),
			(1396871, 'Sabrina Armstrong', '1164 Sabr St., MA 417074', 'Junior'),
			(1128298, 'Henry Richards', '1445 Henr Dr., NH 508647', 'Junior'),
			(1732449, 'James Hall', '502 Jame Ave., MD 585400', 'Junior'),
			(1940847, 'Eleanor Carroll', '1485 Elea Dr., AR 133937', 'Sophmore'),
			(1580029, 'Melissa Campbell', '1670 Meli St., MA 586608', 'Freshman'),
			(1500691, 'Gianna Williams', '1430 Gian Dr., SD 652297', 'Junior'),
			(1170065, 'Maya Hall', '999 Maya St., CT 319137', 'Sophmore'),
			(1687764, 'Brooke Dixon', '1757 Broo Dr., RI 485468', 'Senior'),
			(1774383, 'Jacob Allen', '1818 Jaco Ave., AK 733682', 'Junior'),
			(1790831, 'Luke Spencer', '1264 Luke Dr., ND 76649', 'Junior'),
			(1228266, 'Edward Farrell', '1221 Edwa Cir., LA 513819', 'Sophmore'),
			(1101080, 'Haris Miller', '1729 Hari St., AK 591455', 'Junior'),
			(1268798, 'Alan Rogers', '1625 Alan Ave., UT 561486', 'Sophmore'),
			(1741416, 'Sabrina Turner', '1485 Sabr Ave., PA 546070', 'Junior'),
			(1454533, 'Michael Ryan', '1539 Mich Dr., WA 575822', 'Junior'),
			(1779252, 'Adrian Smith', '161 Adri Ave., NJ 328033', 'Junior'),
			(1919431, 'Vincent Andrews', '1502 Vinc Ave., VT 916924', 'Freshman'),
			(1333658, 'Darcy Anderson', '442 Darc Dr., VA 950541', 'Sophmore'),
			(1942539, 'Melanie Edwards', '488 Mela Cir., CA 992044', 'Sophmore'),
			(1954559, 'Isabella Morgan', '412 Isab St., NM 206256', 'Sophmore'),
			(1526289, 'Kelvin Owens', '470 Kelv St., NJ 901455', 'Senior'),
			(1100866, 'Adam Gray', '488 Adam Ave., SD 963234', 'Senior');

INSERT INTO Professor (id, name, deptId)
	VALUES (3343006, 'Dominik Bailey', 'CS'),
			(3522367, 'Sienna Foster', 'CS'),
			(3508306, 'Dominik Morris', 'CS'),
			(3350615, 'Robert Warren', 'CS'),
			(3733638, 'Maddie Craig', 'MGT'),
			(3072313, 'Charlie Alexander', 'MAT'),
			(3459467, 'Lucas Tucker', 'MAT'),
			(3581881, 'Albert Richardson', 'EE'),
			(3278594, 'Marcus Williams', 'CS'),
			(3090279, 'Harold Brown', 'MGT'),
			(3343596, 'Elian Martin', 'MAT'),
			(3074411, 'Kirsten Anderson', 'EE'),
			(3353664, 'Haris Perkins', 'MAT'),
			(3552708, 'Julia Campbell', 'EE'),
			(3267100, 'Paige Riley', 'MAT'),
			(3004114, 'Abraham Mitchell', 'MAT'),
			(3487113, 'Jordan Phillips', 'EE'),
			(3959310, 'Brianna Armstrong', 'CS'),
			(3575724, 'Arnold Bailey', 'MGT'),
			(3758450, 'Aiden Nelson', 'EE'),
			(3848256, 'Melissa Brooks', 'MGT'),
			(3631232, 'Tara Harrison', 'CS'),
			(3108910, 'Tess Roberts', 'CS'),
			(3917696, 'Alexia Rogers', 'CS'),
			(3039547, 'Jack Jones', 'CS'),
			(3148201, 'Amber Hill', 'EE'),
			(3792678, 'Emily Barrett', 'EE'),
			(3869681, 'Samantha Evans', 'MGT'),
			(3804259, 'Paige Clark', 'MAT'),
			(3486515, 'Jared Kelley', 'MGT'),
			(3116164, 'Ryan Jones', 'EE'),
			(3487944, 'Brooke Thompson', 'MAT'),
			(3191714, 'Ryan Douglas', 'CS'),
			(3138027, 'Deanna Holmes', 'MGT'),
			(3331431, 'Madaline Davis', 'MAT'),
			(3627187, 'Luke Elliott', 'MGT'),
			(3806804, 'Heather Crawford', 'CS'),
			(3119907, 'Maria Howard', 'EE'),
			(3264559, 'Miller Craig', 'EE'),
			(3848208, 'Sienna Mitchell', 'MAT'),
			(3459505, 'Amanda Davis', 'MGT'),
			(3083015, 'Ada Ross', 'MGT'),
			(3045476, 'Briony Carter', 'MGT'),
			(3525430, 'Jack Miller', 'CS'),
			(3567134, 'Rafael Barnes', 'CS'),
			(3463155, 'John Farrell', 'EE'),
			(3328793, 'Cherry Elliott', 'MGT'),
			(3689554, 'Samantha Walker', 'CS'),
			(3289997, 'Eddy Murphy', 'MAT'),
			(3321538, 'Leonardo Hall', 'MAT'),
			(3240510, 'Roland Edwards', 'CS'),
			(3401954, 'Lily Ryan', 'EE'),
			(3645747, 'Eric Bennett', 'EE'),
			(3182327, 'Kristian Higgins', 'MAT'),
			(3328252, 'Lilianna Brown', 'MAT'),
			(3233187, 'Jessica Ryan', 'MAT'),
			(3452970, 'Max Davis', 'EE'),
			(3494698, 'Edgar Barnes', 'MAT'),
			(3439700, 'Dexter Howard', 'EE'),
			(3852115, 'Lydia Holmes', 'MGT'),
			(3310552, 'Emma Adams', 'MGT'),
			(3157890, 'Dexter Barrett', 'CS'),
			(3961493, 'Lucia Warren', 'MGT'),
			(3382570, 'Tess Crawford', 'CS'),
			(3621003, 'Maddie Brown', 'CS'),
			(3330268, 'Kristian Thompson', 'EE'),
			(3716573, 'Stuart Crawford', 'EE'),
			(3385334, 'Carina Barnes', 'CS'),
			(3708228, 'Nicholas Riley', 'MGT'),
			(3215619, 'Miley Cunningham', 'MAT'),
			(3032835, 'Briony Tucker', 'EE'),
			(3157163, 'Maddie Cooper', 'MGT'),
			(3148090, 'Alford Thompson', 'MGT'),
			(3939230, 'Adele Morgan', 'EE'),
			(3112090, 'Abigail Farrell', 'MAT'),
			(3690363, 'Steven Mitchell', 'MAT'),
			(3257780, 'Garry Spencer', 'EE'),
			(3367969, 'James Mitchell', 'MGT'),
			(3754852, 'Victor Dixon', 'EE'),
			(3923670, 'Eddy Harrison', 'EE'),
			(3698483, 'Nicholas Hawkins', 'CS'),
			(3303385, 'Maya Campbell', 'CS'),
			(3013363, 'Ada Cooper', 'MAT'),
			(3988973, 'Amber Tucker', 'MAT'),
			(3174303, 'Abraham Hill', 'MGT'),
			(3587170, 'Adelaide Moore', 'CS'),
			(3157185, 'Victoria Davis', 'MGT'),
			(3867789, 'Ryan Gray', 'EE'),
			(3795553, 'Eric Morrison', 'MGT'),
			(3959672, 'Alina Brooks', 'CS'),
			(3461940, 'Vivian Bennett', 'EE'),
			(3934280, 'Evelyn Moore', 'MGT'),
			(3617861, 'Emily Phillips', 'MAT'),
			(3448358, 'Adele Stevens', 'MGT'),
			(3466754, 'Joyce Robinson', 'CS'),
			(3593440, 'Sabrina Ross', 'MGT'),
			(3683825, 'James Andrews', 'EE'),
			(3098367, 'Albert Kelly', 'MAT'),
			(3581141, 'Olivia Craig', 'MAT'),
			(3529782, 'Vincent Anderson', 'MAT'),
			(3887592, 'Alisa Reed', 'CS'),
			(3461130, 'Ned Hawkins', 'MGT'),
			(3400379, 'Paige Cole', 'CS'),
			(3891847, 'Camila Spencer', 'EE'),
			(3146161, 'James Kelly', 'EE'),
			(3379154, 'Amanda Martin', 'MGT'),
			(3351668, 'Chloe Baker', 'EE'),
			(3166987, 'Sofia Phillips', 'EE'),
			(3229045, 'Alen Elliott', 'MGT'),
			(3408958, 'Tara Brown', 'MAT'),
			(3200454, 'Maddie Cole', 'MAT'),
			(3336037, 'Roman Johnson', 'EE'),
			(3715367, 'Maya Stevens', 'EE'),
			(3202042, 'Dale Martin', 'MGT'),
			(3069369, 'Max Baker', 'MGT'),
			(3888411, 'Martin Carroll', 'EE'),
			(3916754, 'Dominik Jones', 'CS'),
			(3943387, 'Robert Evans', 'MAT'),
			(3483491, 'Aldus Watson', 'MAT'),
			(3978528, 'Camila Crawford', 'EE'),
			(3783629, 'Catherine Howard', 'CS'),
			(3367744, 'Elise Taylor', 'EE'),
			(3435210, 'Elian Wright', 'MAT'),
			(3256080, 'Madaline Morgan', 'MAT'),
			(3694257, 'Oliver Alexander', 'CS'),
			(3205933, 'Alberta Dixon', 'CS'),
			(3947863, 'Olivia Phillips', 'MAT'),
			(3268335, 'Kate Carroll', 'MGT'),
			(3389295, 'Dexter Stevens', 'MAT'),
			(3066168, 'Thomas Andrews', 'MGT'),
			(3657643, 'Justin Hunt', 'MAT'),
			(3461365, 'Dainton Moore', 'EE'),
			(3052410, 'Sam Roberts', 'CS'),
			(3940901, 'Grace Brooks', 'EE'),
			(3244495, 'Alford Hall', 'MAT'),
			(3119396, 'Edgar Morgan', 'MAT'),
			(3443096, 'Emma Sullivan', 'MAT'),
			(3236419, 'Lucas Rogers', 'MAT'),
			(3315046, 'Rebecca Owens', 'MGT'),
			(3921079, 'Sienna Chapman', 'MAT'),
			(3853843, 'Lily Kelly', 'MAT'),
			(3139125, 'Brooke Morris', 'EE'),
			(3265791, 'Garry Andrews', 'MGT'),
			(3171833, 'Mike Fowler', 'EE'),
			(3367760, 'Caroline Barnes', 'EE'),
			(3588379, 'Vanessa Harris', 'MAT'),
			(3260237, 'Owen Howard', 'MGT'),
			(3078943, 'Melissa Richards', 'MGT'),
			(3883993, 'Savana Hunt', 'MAT'),
			(3291916, 'Spike Higgins', 'EE'),
			(3085943, 'Tess Armstrong', 'CS'),
			(3157200, 'Naomi Ellis', 'MAT'),
			(3750498, 'Dainton Phillips', 'MGT'),
			(3240681, 'Violet Montgomery', 'MAT'),
			(3411000, 'Adison Carter', 'CS'),
			(3759167, 'Clark Wilson', 'MAT'),
			(3638081, 'Valeria Barnes', 'MGT'),
			(3044291, 'Myra Miller', 'MGT'),
			(3054139, 'Garry Hamilton', 'CS'),
			(3161279, 'Aston Walker', 'CS'),
			(3703444, 'Tiana Owens', 'EE'),
			(3488967, 'Tiana Gibson', 'MGT'),
			(3179128, 'Kevin Cooper', 'MGT'),
			(3215773, 'Leonardo Elliott', 'CS'),
			(3383947, 'Isabella Walker', 'EE'),
			(3529773, 'Edgar Cunningham', 'EE'),
			(3434401, 'Cadie Stevens', 'MGT'),
			(3194221, 'Dale Riley', 'MGT'),
			(3694261, 'Jenna Cole', 'CS'),
			(3255814, 'Amelia Barrett', 'MAT'),
			(3851513, 'Rubie Myers', 'EE'),
			(3727658, 'Amanda Thomas', 'EE'),
			(3688460, 'Connie Armstrong', 'MAT'),
			(3583831, 'Haris Harper', 'CS'),
			(3750739, 'Dominik Barnes', 'MAT'),
			(3870679, 'Sabrina Morrison', 'EE'),
			(3469114, 'Owen Harper', 'MAT'),
			(3460268, 'Paul Rogers', 'MGT'),
			(3390359, 'John Morris', 'CS'),
			(3026836, 'Lucy Hill', 'CS'),
			(3115055, 'Victoria Carroll', 'MGT'),
			(3946730, 'Chloe Hall', 'MGT'),
			(3894871, 'Vincent Henderson', 'MGT'),
			(3007106, 'Dale Dixon', 'EE'),
			(3187938, 'Walter Barnes', 'CS'),
			(3609053, 'Daniel Foster', 'MGT'),
			(3623079, 'Lenny Ross', 'MGT'),
			(3285506, 'Mike Perkins', 'MAT'),
			(3671883, 'Maximilian Sullivan', 'EE'),
			(3739569, 'Daniel Owens', 'MAT'),
			(3138730, 'Lilianna Mason', 'EE'),
			(3608705, 'Abigail Gibson', 'EE'),
			(3290801, 'Stuart Farrell', 'CS'),
			(3237072, 'Dale Campbell', 'MGT'),
			(3150180, 'Victoria Sullivan', 'MGT'),
			(3349212, 'Jack Wright', 'EE'),
			(3881214, 'Audrey Hawkins', 'EE'),
			(3492654, 'Lyndon Evans', 'MAT'),
			(3746747, 'Eric Mason', 'MAT'),
			(3317176, 'Preston Wright', 'EE'),
			(3201899, 'Lyndon Reed', 'CS'),
			(3147286, 'Alen Perry', 'MAT'),
			(3341413, 'Natalie Cunningham', 'EE'),
			(3679177, 'Max Richardson', 'EE'),
			(3558411, 'Melanie Wright', 'MAT'),
			(3326168, 'Arnold Anderson', 'CS'),
			(3094018, 'Vanessa Richards', 'MGT'),
			(3934078, 'Kelvin Wells', 'EE'),
			(3368350, 'Audrey Ross', 'CS'),
			(3326084, 'Kellan Barnes', 'CS'),
			(3059982, 'Chelsea Reed', 'EE'),
			(3122252, 'Kelvin Adams', 'MGT'),
			(3662792, 'Stella Myers', 'CS'),
			(3746012, 'Wilson Myers', 'MGT'),
			(3393850, 'Arthur Wright', 'CS'),
			(3405134, 'Maximilian Phillips', 'EE'),
			(3574732, 'Ryan Perry', 'MGT'),
			(3131671, 'Camila Carter', 'MGT'),
			(3330928, 'Alford Hall', 'EE'),
			(3875816, 'Amanda Anderson', 'EE'),
			(3345818, 'Charlotte Spencer', 'EE'),
			(3260243, 'Alexia Henderson', 'MAT'),
			(3039425, 'Catherine Wells', 'MAT'),
			(3376469, 'Vincent Warren', 'EE'),
			(3088765, 'Sam Richards', 'CS'),
			(3116322, 'Garry Hamilton', 'MAT'),
			(3374631, 'Alina Hall', 'EE'),
			(3039828, 'Eddy Rogers', 'MAT'),
			(3026108, 'Cadie Edwards', 'MGT'),
			(3415486, 'Alisa Williams', 'MAT'),
			(3881016, 'Myra Wells', 'CS'),
			(3103716, 'Lucy Perkins', 'MGT'),
			(3485463, 'Amy Rogers', 'EE'),
			(3178889, 'Hailey Armstrong', 'MGT'),
			(3410946, 'Naomi Stevens', 'MGT'),
			(3543159, 'Stuart Martin', 'MAT'),
			(3261284, 'Naomi Alexander', 'EE'),
			(3971425, 'Henry Payne', 'MGT'),
			(3783682, 'Valeria Brown', 'EE'),
			(3402274, 'Cadie Stewart', 'CS'),
			(3250895, 'Alfred Ellis', 'EE'),
			(3599438, 'Ned Johnston', 'MAT'),
			(3173086, 'Robert Carroll', 'MAT'),
			(3807624, 'Brooke Douglas', 'MGT'),
			(3802058, 'Rebecca Phillips', 'CS'),
			(3151276, 'Sydney Craig', 'MGT'),
			(3951837, 'Clark Richardson', 'EE'),
			(3808649, 'Patrick Johnson', 'CS'),
			(3881555, 'Maria Jones', 'MGT'),
			(3094649, 'Stuart Kelly', 'MGT'),
			(3617621, 'Melanie Thomas', 'CS'),
			(3337118, 'Briony Moore', 'CS'),
			(3466870, 'Amber Casey', 'EE'),
			(3571265, 'Harold Perkins', 'EE'),
			(3795008, 'Brad Hamilton', 'MGT'),
			(3979501, 'Alisa Adams', 'MAT'),
			(3597573, 'Kristian Davis', 'MGT'),
			(3720345, 'Bruce Williams', 'CS'),
			(3305422, 'Wilson Robinson', 'EE'),
			(3505125, 'Charlie Farrell', 'CS'),
			(3978744, 'Oliver Cole', 'MGT'),
			(3402740, 'Edgar Henderson', 'CS'),
			(3667963, 'Miley Baker', 'MAT'),
			(3794827, 'Daisy Wright', 'CS'),
			(3737587, 'Sawyer Wright', 'MAT'),
			(3146272, 'Reid Scott', 'CS'),
			(3799833, 'Mike Gray', 'MAT'),
			(3646747, 'William Mason', 'EE'),
			(3562469, 'Cadie Payne', 'MGT'),
			(3329297, 'Stella Howard', 'MAT'),
			(3356964, 'Naomi Bailey', 'MGT'),
			(3279736, 'Byron Edwards', 'EE'),
			(3233971, 'Vincent Morris', 'EE'),
			(3778196, 'Tara Watson', 'CS'),
			(3222952, 'Leonardo Alexander', 'MAT'),
			(3649533, 'Agata Carroll', 'CS'),
			(3858945, 'Kelvin Foster', 'MAT'),
			(3960916, 'Luke Mason', 'EE'),
			(3337911, 'Alford Bennett', 'MAT'),
			(3116391, 'Bruce Campbell', 'EE'),
			(3253378, 'Oscar Alexander', 'EE'),
			(3548112, 'Fenton Nelson', 'MGT'),
			(3585069, 'Jacob Harrison', 'MAT'),
			(3896772, 'Melissa Ferguson', 'CS'),
			(3978469, 'Martin Hamilton', 'EE'),
			(3666909, 'David Elliott', 'CS'),
			(3230543, 'Sarah Craig', 'MAT'),
			(3629227, 'Charlotte Phillips', 'EE'),
			(3979368, 'Grace Chapman', 'CS'),
			(3178248, 'Lilianna Jones', 'MAT'),
			(3957355, 'Patrick Alexander', 'CS'),
			(3888817, 'Rosie Craig', 'EE'),
			(3405419, 'Lucia Higgins', 'CS'),
			(3478841, 'Ted Martin', 'CS'),
			(3384964, 'Caroline Edwards', 'MAT'),
			(3403429, 'Arthur Russell', 'MAT'),
			(3808268, 'Lenny Myers', 'MAT'),
			(3322349, 'Charlotte Harrison', 'EE'),
			(3426949, 'Preston Miller', 'MGT'),
			(3620453, 'Tyler Ross', 'MAT'),
			(3113032, 'Stuart Williams', 'MAT'),
			(3311461, 'Caroline Barnes', 'MAT'),
			(3807813, 'Sofia Payne', 'MAT'),
			(3597276, 'Miller Morris', 'MGT'),
			(3377591, 'Eleanor Myers', 'EE'),
			(3542859, 'Dexter Gray', 'MAT'),
			(3069662, 'Steven Adams', 'CS'),
			(3510692, 'Preston Phillips', 'MGT'),
			(3155469, 'Melanie Myers', 'MGT'),
			(3978299, 'Andrew Roberts', 'MAT'),
			(3837618, 'Edward Wilson', 'MGT'),
			(3004390, 'Miller Grant', 'MAT'),
			(3507427, 'Victoria Harrison', 'EE'),
			(3332260, 'Albert Myers', 'CS'),
			(3140565, 'Jessica Perry', 'CS'),
			(3676818, 'Arthur Turner', 'MAT'),
			(3093450, 'Caroline Riley', 'MGT'),
			(3021409, 'Amelia Davis', 'MGT'),
			(3652087, 'Oscar Wilson', 'MAT'),
			(3135158, 'Michelle Spencer', 'MAT'),
			(3187196, 'Nicole Lloyd', 'EE'),
			(3757821, 'Joyce Robinson', 'EE'),
			(3414336, 'Oliver Douglas', 'MGT'),
			(3531571, 'Chester Carroll', 'MAT'),
			(3659856, 'Clark Hunt', 'CS'),
			(3414562, 'Sienna Carter', 'CS'),
			(3278539, 'Jared Howard', 'MGT'),
			(3791009, 'Arnold Kelley', 'CS'),
			(3123141, 'Nicholas Moore', 'EE'),
			(3590765, 'Violet Baker', 'MGT'),
			(3251070, 'Dale Carroll', 'EE'),
			(3167525, 'Clark Ferguson', 'MAT'),
			(3920219, 'Freddie Williams', 'MAT'),
			(3800380, 'Roland Riley', 'MGT'),
			(3870599, 'Kristian Hall', 'MGT'),
			(3775487, 'Elise Andrews', 'MAT'),
			(3310078, 'Cadie Carter', 'EE'),
			(3824750, 'Deanna Allen', 'MGT'),
			(3274425, 'Kevin Riley', 'CS'),
			(3137539, 'Kellan Elliott', 'EE'),
			(3958961, 'Kimberly Craig', 'MAT'),
			(3291842, 'Chester Hill', 'MAT'),
			(3036603, 'Elise Roberts', 'EE'),
			(3630920, 'Gianna Casey', 'MGT'),
			(3548418, 'Michael Henderson', 'CS'),
			(3996569, 'Connie Davis', 'MGT'),
			(3294789, 'Victor Morgan', 'MGT'),
			(3134086, 'Deanna Baker', 'CS'),
			(3584988, 'Preston Smith', 'MGT'),
			(3131339, 'Lucia Kelly', 'EE'),
			(3204543, 'Roman Hamilton', 'MGT'),
			(3548415, 'Adrianna Grant', 'MGT'),
			(3840869, 'Eddy Campbell', 'MAT'),
			(3805860, 'Violet Perkins', 'MAT'),
			(3693583, 'Mike Parker', 'CS'),
			(3767437, 'Adrianna Armstrong', 'CS'),
			(3719534, 'Eleanor Russell', 'EE'),
			(3372072, 'Brad Farrell', 'EE'),
			(3456757, 'Olivia Martin', 'CS'),
			(3617754, 'Martin Armstrong', 'MAT'),
			(3797036, 'Elise Alexander', 'EE'),
			(3745220, 'Lydia Richards', 'MGT'),
			(3236586, 'Miley Gray', 'MAT'),
			(3162168, 'Anna Ferguson', 'MAT'),
			(3580468, 'Arthur Stewart', 'MGT'),
			(3231241, 'Jasmine Harris', 'MAT'),
			(3099918, 'Emily Richardson', 'EE'),
			(3702259, 'Alissa Clark', 'MAT'),
			(3865059, 'Carina Miller', 'MAT'),
			(3269218, 'Aston Wells', 'MAT'),
			(3044777, 'Abigail Anderson', 'MAT'),
			(3346814, 'Honey Higgins', 'EE'),
			(3040013, 'Alen Johnston', 'CS'),
			(3615091, 'Brooke Nelson', 'MGT'),
			(3757353, 'Stuart Morris', 'EE'),
			(3708696, 'Aldus Wright', 'MGT'),
			(3808200, 'Arianna Ross', 'MAT'),
			(3209834, 'Camila Edwards', 'MAT'),
			(3549127, 'Sabrina Armstrong', 'EE'),
			(3129366, 'Henry Richards', 'MGT'),
			(3837729, 'James Hall', 'MGT'),
			(3331280, 'Eleanor Carroll', 'CS'),
			(3780096, 'Melissa Campbell', 'MAT'),
			(3981383, 'Gianna Williams', 'CS'),
			(3977194, 'Maya Hall', 'EE'),
			(3743940, 'Brooke Dixon', 'EE'),
			(3374831, 'Jacob Allen', 'EE'),
			(3762912, 'Luke Spencer', 'MGT'),
			(3044207, 'Edward Farrell', 'EE'),
			(3410230, 'Haris Miller', 'EE'),
			(3895575, 'Alan Rogers', 'CS'),
			(3782530, 'Sabrina Turner', 'MAT'),
			(3957721, 'Michael Ryan', 'EE'),
			(3745985, 'Adrian Smith', 'CS'),
			(3587557, 'Vincent Andrews', 'CS'),
			(3641160, 'Darcy Anderson', 'MAT'),
			(3434213, 'Melanie Edwards', 'MGT'),
			(3506118, 'Isabella Morgan', 'MAT'),
			(3716322, 'Kelvin Owens', 'CS'),
			(3893477, 'Adam Gray', 'MGT');

INSERT INTO Course (deptId, crsCode, crsName)
	VALUES ('MGT', 'MGT381', 'Fundamental Programming Concepts Summer 18 (ITH) CR Summer 19 (ITH) CR Summer 20 (ITH) CR'),
			('MAT', 'MAT796', 'Introduction to Computing Using Python Spring 20 (ITH) CR Summer 20 (ITH) CR Fall 20 (ITH) CR'),
			('MAT', 'MAT112', 'Introduction to Computing Using MATLAB Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT523', 'Short Course in MATLAB Spring 19 (ITH) CR Fall 19 (ITH) CR Spring 20 (ITH) CR'),
			('EE', 'EE952', 'Short Course in Python Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS663', 'Introductory Design and Programming for the Web Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT659', 'Choices and Consequences in Computing Not Offered Recently'),
			('EE', 'EE142', 'Data Science for All Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MAT', 'MAT615', 'Computing in the Arts Summer 18 (ITH) CR Summer 19 (ITH) CR Summer 20 (ITH) CR'),
			('MAT', 'MAT459', 'Visual Imaging in the Electronic Age Fall 17 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE249', 'Introduction to Cognitive Science Summer 19 (ITH) CR Spring 20 (ITH) CR Summer 20 (ITH) CR'),
			('EE', 'EE712', 'Freshmen and Nontechnical Team Projects Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE507', 'C++ Programming Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT912', 'UNIX Tools and Scripting Spring 17 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('EE', 'EE820', 'Object-Oriented Programming and Data Structures Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT962', 'Programming Practicum Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE850', 'Object-Oriented Design and Data Structures - Honors Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT650', 'Intermediate Design and Programming for the Web Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS622', 'Urban Analytics Fall 20 (ITH) CR'),
			('MAT', 'MAT203', 'Excursions in Computational Sustainability Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS371', 'Discrete Structures Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT406', 'Discrete Structures - Honors Spring 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE481', 'Networks Fall 17 (ITH) CR Fall 18 (ITH) CR Fall 19 (ITH) CR'),
			('EE', 'EE860', 'Data Structures and Functional Programming Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT674', 'Introduction to Computer Game Architecture Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT382', 'Computational Mathematics for Computer Science Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('MAT', 'MAT649', 'Data-Driven Web Applications Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT158', 'Computer System Organization and Programming Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS612', 'Embedded Systems Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT142', 'Autonomous Mobile Robots Spring 17 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS314', 'Teaching Experience in Computer Science Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE676', 'Programming Languages and Logics Fall 16 (ITH) CR Fall 18 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE308', 'Introduction to Compilers Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT794', 'Practicum in Compilers Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS327', 'Advanced Topics in Computer Game Architecture Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS399', 'Formal Verification Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT884', 'Numerical Analysis and Differential Equations Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT825', 'Numerical Analysis: Linear and Nonlinear Problems Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MAT', 'MAT659', 'Language and Information Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT830', 'Introduction to Database Systems Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT954', 'Practicum in Database Systems Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT597', 'Operating Systems Spring 20 (ITH) CR Summer 20 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT976', 'Practicum in Operating Systems Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('MAT', 'MAT755', 'Systems Programming Fall 20 (ITH) CR'),
			('EE', 'EE155', 'Computer Architecture Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE351', 'Introduction to Computer Networks Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT563', 'Introduction to Computer Graphics Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS982', 'Computer Graphics Practicum Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS684', 'Introduction to Computer Vision Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MAT', 'MAT423', 'Foundations of Artificial Intelligence Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE179', 'Practicum in Artificial Intelligence Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE509', 'Natural Language Processing Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE413', 'Computational Linguistics Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT157', 'Human Robot Interaction - Research and Design Spring 17 (ITH) CR Spring 19 (ITH) CR'),
			('MGT', 'MGT574', 'Computational Genetics and Genomics Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS705', 'Introduction to Machine Learning Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE719', 'Machine Learning for Data Science Fall 17 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS739', 'Principles of Large-Scale Machine Learning Systems Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS581', 'Introduction to Theory of Computing Fall 17 (ITH) CR Fall 18 (ITH) CR Fall 19 (ITH) CR'),
			('MAT', 'MAT807', 'Quantum Information Processing Fall 16 (ITH) CR Fall 18 (ITH) CR Fall 20 (ITH) CR'),
			('MAT', 'MAT409', 'Introduction to Computational Complexity Spring 20 (ITH) CR'),
			('EE', 'EE482', 'Introduction to Analysis of Algorithms Spring 20 (ITH) CR Summer 20 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT382', 'Introduction to Cryptography Spring 17 (ITH) CR'),
			('EE', 'EE228', 'Mathematical Foundations for the Information Age Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('EE', 'EE971', 'Networks II: Market Design Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('EE', 'EE119', 'Applied Logic Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS856', 'International Research Internship Spring 19 (ITH) CR Summer 19 (ITH) CR Spring 20 (ITH) CR'),
			('EE', 'EE282', 'Practical Training in Computer Science Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('MAT', 'MAT225', 'Team Projects Fall 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('MAT', 'MAT619', 'Independent Reading and Research Spring 20 (ITH) CR Summer 20 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS954', 'Introduction to Blockchains, Cryptocurrencies, and Smart Contracts Spring 17 (NYC) CR Spring 18 (NYC) CR'),
			('MAT', 'MAT768', 'Programming Languages and Logics Fall 16 (ITH) CR Fall 18 (ITH) CR Fall 20 (ITH) CR'),
			('MAT', 'MAT365', 'Algorithms and Data Structures for Applications Fall 18 (NYC) CR Fall 19 (NYC) CR Fall 20 (NYC) CR'),
			('MGT', 'MGT157', 'Network Programming Languages Fall 17 (ITH) CR Fall 18 (ITH) CR Fall 19 (ITH) CR'),
			('MAT', 'MAT561', 'Introduction to Compilers Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('MAT', 'MAT793', 'Practicum in Compilers Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS315', 'Software Engineering Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('EE', 'EE177', 'Open-Source Software Engineering Spring 17 (ITH) CR Spring 19 (ITH) CR Fall 19 (ITH) CR'),
			('CS', 'CS762', 'Competition Programming and Problem Solving Seminar Spring 19 (ITH) CR Fall 19 (ITH) CR Spring 20 (ITH) CR'),
			('MGT', 'MGT247', 'Applications of Parallel Computers Fall 17 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE652', 'Data Science in the Wild Spring 19 (NYC) CR Spring 20 (NYC) CR Fall 20 (NYC) CR'),
			('MGT', 'MGT716', 'Crowdsourcing and Human Computation Fall 17 (ITH) CR Fall 18 (ITH) CR Fall 19 (ITH) CR'),
			('CS', 'CS854', 'Introduction to Database Systems Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE239', 'Practicum in Database Systems Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE337', 'Startup Systems Design and Engineering Fall 16 (NYC) CR Fall 17 (NYC) CR'),
			('CS', 'CS807', 'Cloud Computing Spring 18 (ITH) CR Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('CS', 'CS359', 'Distributed Computing Principles Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS665', 'Advanced Computer Architecture Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS923', 'Developing and Designing Interactive Devices Fall 18 (NYC) CR Fall 19 (NYC) CR Fall 20 (NYC) CR'),
			('EE', 'EE820', 'System Security Spring 19 (ITH) CR Spring 20 (ITH) CR Fall 20 (ITH) CR'),
			('CS', 'CS735', 'Practicum in System Security Spring 17 (ITH) CR Spring 18 (ITH) CR Spring 19 (ITH) CR Not Offered Spring 20'),
			('EE', 'EE639', 'Blockchains, Cryptocurrencies, and Smart Contracts Spring 18 (NYC) CR Spring 19 (NYC) CR Spring 20 (NYC) CR'),
			('CS', 'CS262', 'Security and Privacy Concepts in the Wild Fall 18 (NYC) CR Fall 19 (NYC) CR Fall 20 (NYC) CR'),
			('EE', 'EE988', 'Privacy in the Digital Age Spring 17 (NYC) CR Spring 18 (NYC) CR'),
			('MAT', 'MAT141', 'Practicum in Computer Security Fall 18 (NYC) CR'),
			('EE', 'EE287', 'Networked and Distributed Systems Fall 17 (NYC) CR Fall 18 (NYC) CR Spring 20 (NYC) CR'),
			('MAT', 'MAT369', 'Introduction to Computer Graphics Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('EE', 'EE964', 'Computer Graphics Practicum Fall 18 (ITH) CR Fall 19 (ITH) CR Fall 20 (ITH) CR'),
			('MGT', 'MGT989', 'Interactive Computer Graphics Spring 19 (ITH) CR Spring 20 (ITH) CR'),
			('EE', 'EE615', 'Virtual and Augmented Reality Fall 18 (NYC) CR Fall 19 (NYC) CR Fall 20 (NYC) CR');

INSERT INTO Teaching (profId, crsCode, semester)
	VALUES (3343006, 'MGT381', 'W699'),
			(3522367, 'MAT796', 'F504'),
			(3508306, 'MAT112', 'F297'),
			(3350615, 'MGT523', 'S673'),
			(3733638, 'EE952', 'S195'),
			(3072313, 'CS663', 'W339'),
			(3459467, 'MGT659', 'W173'),
			(3581881, 'EE142', 'S201'),
			(3278594, 'MAT615', 'W287'),
			(3090279, 'MAT459', 'F823'),
			(3343596, 'EE249', 'S568'),
			(3074411, 'EE712', 'S739'),
			(3353664, 'EE507', 'F377'),
			(3552708, 'MGT912', 'S377'),
			(3267100, 'EE820', 'W543'),
			(3004114, 'MGT962', 'W396'),
			(3487113, 'EE850', 'W582'),
			(3959310, 'MGT650', 'F547'),
			(3575724, 'CS622', 'W137'),
			(3758450, 'MAT203', 'W174'),
			(3848256, 'CS371', 'S623'),
			(3631232, 'MGT406', 'F381'),
			(3108910, 'EE481', 'F656'),
			(3917696, 'EE860', 'F234'),
			(3039547, 'MGT674', 'S275'),
			(3148201, 'MGT382', 'F350'),
			(3792678, 'MAT649', 'S996'),
			(3869681, 'MGT158', 'W962'),
			(3804259, 'CS612', 'W122'),
			(3486515, 'MGT142', 'S412'),
			(3116164, 'CS314', 'W653'),
			(3487944, 'EE676', 'S798'),
			(3191714, 'EE308', 'S572'),
			(3138027, 'MGT794', 'F610'),
			(3331431, 'CS327', 'W488'),
			(3627187, 'CS399', 'W405'),
			(3806804, 'MGT884', 'W510'),
			(3119907, 'MGT825', 'F783'),
			(3264559, 'MAT659', 'F587'),
			(3848208, 'MGT830', 'F697'),
			(3459505, 'MGT954', 'S672'),
			(3083015, 'MGT597', 'F128'),
			(3045476, 'MGT976', 'W780'),
			(3525430, 'MAT755', 'W287'),
			(3567134, 'EE155', 'W410'),
			(3463155, 'EE351', 'W474'),
			(3328793, 'MGT563', 'S550'),
			(3689554, 'CS982', 'S113'),
			(3289997, 'CS684', 'W415'),
			(3321538, 'MAT423', 'F291'),
			(3240510, 'EE179', 'S347'),
			(3401954, 'EE509', 'S740'),
			(3645747, 'EE413', 'F937'),
			(3182327, 'MGT157', 'S225'),
			(3328252, 'MGT574', 'S352'),
			(3233187, 'CS705', 'W912'),
			(3452970, 'EE719', 'F104'),
			(3494698, 'CS739', 'S711'),
			(3439700, 'CS581', 'S368'),
			(3852115, 'MAT807', 'S316'),
			(3310552, 'MAT409', 'S796'),
			(3157890, 'EE482', 'W799'),
			(3961493, 'MGT382', 'W987'),
			(3382570, 'EE228', 'W887'),
			(3621003, 'EE971', 'S354'),
			(3330268, 'EE119', 'W871'),
			(3716573, 'CS856', 'F340'),
			(3385334, 'EE282', 'F757'),
			(3708228, 'MAT225', 'F400'),
			(3215619, 'MAT619', 'W655'),
			(3032835, 'CS954', 'F948'),
			(3157163, 'MAT768', 'F466'),
			(3148090, 'MAT365', 'F191'),
			(3939230, 'MGT157', 'S625'),
			(3112090, 'MAT561', 'S741'),
			(3690363, 'MAT793', 'F984'),
			(3257780, 'CS315', 'W146'),
			(3367969, 'EE177', 'S817'),
			(3754852, 'CS762', 'F529'),
			(3923670, 'MGT247', 'F605'),
			(3698483, 'EE652', 'F198'),
			(3303385, 'MGT716', 'F331'),
			(3013363, 'CS854', 'F896'),
			(3988973, 'EE239', 'W473'),
			(3174303, 'EE337', 'F186'),
			(3587170, 'CS807', 'W802'),
			(3157185, 'CS359', 'S136'),
			(3867789, 'CS665', 'W259'),
			(3795553, 'CS923', 'S973'),
			(3959672, 'EE820', 'F258'),
			(3461940, 'CS735', 'F662'),
			(3934280, 'EE639', 'F662'),
			(3617861, 'CS262', 'F357'),
			(3448358, 'EE988', 'F623'),
			(3466754, 'MAT141', 'F222'),
			(3593440, 'EE287', 'W131'),
			(3683825, 'MAT369', 'F144'),
			(3098367, 'EE964', 'F192'),
			(3581141, 'MGT989', 'W435'),
			(3529782, 'EE615', 'F694');

INSERT INTO Transcript (studId, crsCode, semester, grade)
	VALUES (1760637, 'MGT381', 'W374', 'F'),
			(1046898, 'MAT796', 'W708', 'B'),
			(1573987, 'MAT112', 'W735', 'D'),
			(1880873, 'MGT523', 'F311', 'A'),
			(1352778, 'EE952', 'W262', 'B'),
			(1571569, 'CS663', 'F268', 'D'),
			(1661978, 'MGT659', 'S893', 'E'),
			(1430350, 'EE142', 'W278', 'B'),
			(1047037, 'MAT615', 'F680', 'D'),
			(1368678, 'MAT459', 'W692', 'E'),
			(1313014, 'EE249', 'F767', 'E'),
			(1617433, 'EE712', 'W468', 'C'),
			(1778033, 'EE507', 'F162', 'E'),
			(1476153, 'MGT912', 'W155', 'F'),
			(1436960, 'EE820', 'W462', 'C'),
			(1726202, 'MGT962', 'W493', 'B'),
			(1725794, 'EE850', 'W332', 'B'),
			(1059879, 'MGT650', 'W401', 'D'),
			(1076785, 'CS622', 'F172', 'D'),
			(1634044, 'MAT203', 'S753', 'A'),
			(1296642, 'CS371', 'W772', 'E'),
			(1852678, 'MGT406', 'S893', 'C'),
			(1235479, 'EE481', 'F988', 'A'),
			(1688059, 'EE860', 'S492', 'F'),
			(1199918, 'MGT674', 'F345', 'C'),
			(1416804, 'MGT382', 'F427', 'D'),
			(1341653, 'MAT649', 'S989', 'F'),
			(1458842, 'MGT158', 'S397', 'C'),
			(1699121, 'CS612', 'F910', 'C'),
			(1323368, 'MGT142', 'S667', 'A'),
			(1849994, 'CS314', 'F928', 'C'),
			(1151712, 'EE676', 'S251', 'E'),
			(1081033, 'EE308', 'F656', 'B'),
			(1861651, 'MGT794', 'F993', 'B'),
			(1234100, 'CS327', 'S286', 'B'),
			(1631747, 'CS399', 'S317', 'F'),
			(1425119, 'MGT884', 'S979', 'A'),
			(1647861, 'MGT825', 'F984', 'D'),
			(1473468, 'MAT659', 'F969', 'D'),
			(1216047, 'MGT830', 'W466', 'C'),
			(1613619, 'MGT954', 'F698', 'B'),
			(1190482, 'MGT597', 'F298', 'F'),
			(1944146, 'MGT976', 'F855', 'A'),
			(1802322, 'MAT755', 'F960', 'C'),
			(1324784, 'EE155', 'S725', 'E'),
			(1528730, 'EE351', 'S799', 'B'),
			(1641132, 'MGT563', 'W215', 'C'),
			(1063890, 'CS982', 'S202', 'C'),
			(1461531, 'CS684', 'F673', 'E'),
			(1902493, 'MAT423', 'W644', 'B'),
			(1690567, 'EE179', 'S456', 'F'),
			(1704791, 'EE509', 'S348', 'A'),
			(1455978, 'EE413', 'F170', 'A'),
			(1721662, 'MGT157', 'F302', 'C'),
			(1274264, 'MGT574', 'W609', 'F'),
			(1235943, 'CS705', 'S738', 'E'),
			(1258537, 'EE719', 'W435', 'F'),
			(1266652, 'CS739', 'W132', 'F'),
			(1108533, 'CS581', 'F434', 'C'),
			(1656765, 'MAT807', 'F408', 'C'),
			(1523816, 'MAT409', 'S313', 'E'),
			(1331232, 'EE482', 'F528', 'C'),
			(1268689, 'MGT382', 'S444', 'B'),
			(1855954, 'EE228', 'W494', 'A'),
			(1931856, 'EE971', 'W959', 'D'),
			(1194534, 'EE119', 'F806', 'D'),
			(1897694, 'CS856', 'F443', 'E'),
			(1597246, 'EE282', 'S937', 'D'),
			(1913032, 'MAT225', 'W741', 'B'),
			(1201702, 'MAT619', 'F810', 'C'),
			(1001818, 'CS954', 'F214', 'C'),
			(1309298, 'MAT768', 'S484', 'B'),
			(1968909, 'MAT365', 'W859', 'A'),
			(1324248, 'MGT157', 'W844', 'F'),
			(1715811, 'MAT561', 'S834', 'E'),
			(1931305, 'MAT793', 'W157', 'B'),
			(1235571, 'CS315', 'W587', 'A'),
			(1728644, 'EE177', 'S800', 'C'),
			(1850932, 'CS762', 'S442', 'C'),
			(1612521, 'MGT247', 'W936', 'D'),
			(1029240, 'EE652', 'S519', 'B'),
			(1816679, 'MGT716', 'F380', 'F'),
			(1536642, 'CS854', 'S716', 'D'),
			(1371268, 'EE239', 'W873', 'C'),
			(1868396, 'EE337', 'W580', 'C'),
			(1404490, 'CS807', 'S397', 'D'),
			(1516523, 'CS359', 'W188', 'C'),
			(1790801, 'CS665', 'S789', 'E'),
			(1766226, 'CS923', 'W214', 'E'),
			(1055826, 'EE820', 'W613', 'E'),
			(1845496, 'CS735', 'W763', 'A'),
			(1199699, 'EE639', 'W471', 'D'),
			(1654029, 'CS262', 'W115', 'B'),
			(1560203, 'EE988', 'W210', 'E'),
			(1585923, 'MAT141', 'W619', 'A'),
			(1159230, 'EE287', 'W445', 'D'),
			(1780328, 'MAT369', 'F236', 'A'),
			(1575173, 'EE964', 'S331', 'D'),
			(1269340, 'MGT989', 'S802', 'F'),
			(1087211, 'EE615', 'W982', 'C');


SELECT COUNT(*) FROM Student;
SELECT COUNT(*) FROM Professor;
SELECT COUNT(*) FROM Course;
SELECT COUNT(*) FROM Teaching;
SELECT COUNT(*) FROM Transcript;