-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpopulate_data.sql
1162 lines (1148 loc) · 60.4 KB
/
populate_data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
CREATE DATABASE springboardopt;
USE springboardopt;
drop table if exists student;
drop table if exists professor;
drop table if exists course;
drop table if exists teaching;
drop table if exists transcript;
-- 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'),