Source

htsql-firebird / test / sql / demo-data.yaml

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
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
#
# Copyright (c) 2006-2012, Prometheus Research, LLC
# See `LICENSE` for license information, `AUTHORS` for the list of authors.
#

# Data for the standard HTSQL regression schema

- table: ad.school
  columns: [code, name, campus]
  data: [
    ['art', 'School of Art and Design', 'old'],
    ['bus', 'School of Business', 'south'],
    ['edu', 'College of Education', 'old'],
    ['eng', 'School of Engineering', 'north'],
    ['la', 'School of Arts and Humanities', 'old'],
    ['mus', 'School of Music & Dance', 'south'],
    ['ns', 'School of Natural Sciences', 'old'],
    ['ph', 'Public Honorariums', null],
    ['sc', 'School of Continuing Studies', null]
  ]

- table: ad.department
  columns: [code, name, school_code]
  data: [
    ['astro', 'Astronomy', 'ns'],
    ['chem', 'Chemistry', 'ns'],
    ['phys', 'Physics', 'ns'],
    ['mth', 'Mathematics', 'ns'],
    ['eng', 'English', 'la'],
    ['lang', 'Foreign Languages', 'la'],
    ['hist', 'History', 'la'],
    ['psych', 'Psychology', 'la'],
    ['poli', 'Political Science', 'la'],
    ['comp', 'Computer Science', 'eng'],
    ['ee', 'Electrical Engineering', 'eng'],
    ['me', 'Mechanical Engineering', 'eng'],
    ['be', 'Bioengineering', 'eng'],
    ['arthis', 'Art History', 'art'],
    ['stdart', 'Studio Art', 'art'],
    ['tched', 'Teacher Education', 'edu'],
    ['edpol', 'Educational Policy', 'edu'],
    ['econ', 'Economics', 'bus'],
    ['acc', 'Accounting', 'bus'],
    ['mm', 'Management & Marketing', 'bus'],
    ['voc', 'Vocals', 'mus'],
    ['pia', 'Piano', 'mus'],
    ['win', 'Wind', 'mus'],
    ['str', 'Strings', 'mus'],
    # Non-Academic Departments
    ['bursar', 'Bursar''s Office', null],
    ['career', 'Career Development', null],
    ['parent', 'Parents & Alumni', null],
  ]

- table: ad.program
  columns: [school_code, code, title, degree, part_of_code]
  data: [
    ['ns', 'uastro', 'Bachelor of Science in Astronomy', 'bs', null],
    ['ns', 'uchem', 'Bachelor of Science in Chemistry', 'bs', null],
    ['ns', 'uphys', 'Bachelor of Science in Physics', 'bs', null],
    ['ns', 'pmth', 'Doctorate of Science in Mathematics', 'ph', null],
    ['ns', 'gmth', 'Masters of Science in Mathematics', 'ms', 'pmth'],
    ['ns', 'umth', 'Bachelor of Science in Mathematics', 'bs', 'gmth'],
    ['la', 'upsych', 'Bachelor of Arts in Psychology', 'ba', null],
    ['la', 'upolisci', 'Bachelor of Arts in Political Science', 'ba', null],
    ['la', 'gscitch', 'Master of Arts in Science Teaching', 'ma', null],
    ['la', 'psciwri', 'Science Writing', 'ct', null],
    ['la', 'gengl', 'Master of Arts in English', 'ma', null],
    ['la', 'uengl', 'Bachelor of Arts in English', 'ba', 'gengl'],
    ['la', 'uhist', 'Bachelor of Arts in History', 'ba', null],
    ['la', 'uspan', 'Bachelor of Arts in Spanish', 'ba', null],
    ['la', 'glang', 'Master of Arts in Modern Languages', 'ma', null],
    ['eng', 'gee', 'M.S. in Electrical Engineering', 'ms', null],
    ['eng', 'gme', 'M.S. in Mechanical Engineering', 'ms', null],
    ['eng', 'gbe', 'M.S. in Bioengineering', 'ms', null],
    ['eng', 'uelec', 'B.S. in Electrical Engineering', 'bs', 'gee'],
    ['eng', 'umech', 'B.S. in Mechanical Engineering', 'bs', 'gme'],
    ['eng', 'ubio', 'B.S. in Bioengineering', 'bs', 'gbe'],
    ['eng', 'ucompsci', 'B.S. in Computer Science', 'bs', null],
    ['eng', 'gbuseng', 'M.S. in Business and Engineering', 'ms', null],
    ['edu', 'umath', 'Bachelor of Arts in Math Education', 'ba', null],
    ['edu', 'usci', 'Bachelor of Arts in Science Education', 'ba', null],
    ['edu', 'psci', 'Certificate in Science Teaching', 'ct', null],
    ['edu', 'glited', 'Master of Arts in Literacy Education', 'ma', null],
    ['edu', 'gedlead', 'Master of Arts in Education Leadership', 'ma', null],
    ['edu', 'gedu', 'M.S. in Education', 'ms', null],
    ['edu', 'gtch', 'Master of Arts in Teaching', 'ma', null],
    ['bus', 'gecon', 'Master of Arts in Economics', 'ma', null],
    ['bus', 'uecon', 'Bachelor of Arts in Economics', 'ba', 'gecon'],
    ['bus', 'uacct', 'B.S. in Accounting', 'bs', null],
    ['bus', 'ubusad', 'Bachelor of Business Administration', 'bs', null],
    ['bus', 'pacc', 'Graduate Certificate in Accounting', 'ct', null],
    ['bus', 'pbusad', 'Certificate in Business Administration', 'ct', null],
    ['art', 'gart', 'Post Baccalaureate in Art History', 'pb', null],
    ['art', 'uhist', 'Bachelor of Arts in Art History', 'ba', null],
    ['art', 'ustudio', 'Bachelor of Arts in Studio Art', 'ba', null],
    ['ph', 'phd', 'Honorary PhD', null, null],
  ]

- table: ad.course
  columns: [department_code, 'no', title, credits, description]
  data: [
    ['astro', 105, 'General Astronomy I', 5, 'Overview of the current astronomy, its goals and problems, basic instruments, space objects classification.'],
    ['astro', 106, 'General Astronomy I Lab', 2, 'Laboratory studies that complement the lecture course.'],
    ['astro', 108, 'Stars and Planets', 3, 'Basics of planet and star formation, their lifecycle from birth to death.'],
    ['astro', 110, 'Solar System', 3, 'Introductory survey of the solar system, including structure and motion of the planets, properties of the sun, and comparison to extrasolar systems.'],
    ['astro', 122, 'Life in the Universe', 3, 'Nature and origin of large numbers in the cosmos, the formation of planets, formation of life, and the anthropic principle.'],
    ['astro', 210, 'General Astronomy II', 5, 'History of the astronomy science and fate of the universe.'],
    ['astro', 211, 'General Astronomy II Lab', 2, 'Laboratory studies that complement the lecture course.'],
    ['astro', 215, 'Space Mechanics', 4, 'Principles of space objects motion, gravitation, General Theory of Relativity applied to Astronomy.'],
    ['astro', 223, 'General Astrophysics', 3, 'Study of structure and evolution of the space objects, observed effects and underlying principles.'],
    ['astro', 230, 'Observational Astronomy', 3, 'Study of various optical instruments for astronomic observations, observation analysis methods.'],
    ['astro', 241, 'Telescope Workshop', 1, 'Introduction to correct use of the 8-inch Schmidt-Cassegrain type telescope. You will learn about magnification, how to locate an object, and how setting circles work.'],
    ['astro', 315, 'Introduction to Cosmology', 3, 'Introduction to modern cosmological theories, history and evolution of the universe.'],
    ['astro', 320, 'Galactic and Extragalactic Astronomy', 3, 'Study of star distribution, structure of our and other galaxies, interactions between them.'],
    ['astro', 328, 'Radio Astronomy', 4, 'Principles of radio astronomy, radio observation technics and instruments.'],
    ['astro', 329, 'Radio Astronomy Lab', 2, 'Laboratory studies that complement the lecture course.'],
    ['astro', 340, 'Spaceflight', 3, 'History of the spaceflight theory and technology evolution, study of current space exploration technologies.'],
    ['astro', 345, 'Stars Lifecycle', 3, 'Intensive study of star formation process, nuclear reactions, star evolution.'],
    ['astro', 410, 'Cosmology and Religion', 3, 'Exploration of the conflict between cosmology and religion, generic principles, theories of conciliation.'],
    ['astro', 411, 'Cosmology and Religion Seminar', 2, 'Discussion of the topics covered with lection course, student presentations.'],
    ['astro', 418, 'Introduction to Planetology', 4, 'Geology and geophysics of planets and satellites.'],
    ['astro', 432, 'Computational Methods for Astrophysics', 3, 'Computational techniques and algorithms for astrophysical purpose and their appliance using scientific software tools.'],
    ['astro', 433, 'Computational Methods for Astrophysics Lab', 2, 'Practice using specific software for astrophysical computations.'],

    ['chem', 100, 'Principles of Chemistry', 3, 'This course offers an introduction to the biological, inorganic, and chemical molecules, with an emphasis on basic principles of atomic and molecular electronic structure.'],
    ['chem', 110, 'General Chemistry I', 5, 'Introduction to chemistry for scientific majors.'],
    ['chem', 111, 'General Chemistry I Lab', 2, 'Experimental chemistry to illustrate lecture course Chemistry 110.'],
    ['chem', 120, 'General Chemistry II', 5, 'Introduction to chemistry for scientific majors. Continuation of General Chemistry I.'],
    ['chem', 121, 'General Chemistry II Lab', 2, 'Experimental chemistry to illustrate lecture course Chemistry 120.'],
    ['chem', 200, 'Organic Chemistry I', 3, 'Practical introduction to organic chemistry, including problem sets with solutions. Focus is on the basic principles of understanding the structure and reactivity of organic molecules.'],
    ['chem', 201, 'Organic Chemistry I Lab', 2, 'Experimental chemistry to illustrate lecture course Chemistry 200.'],
    ['chem', 210, 'Organic Chemistry II', 3, 'Introduction to organic chemistry. Continuation of General Chemistry II.'],
    ['chem', 211, 'Organic Chemistry II Lab', 2, 'Experimental chemistry to illustrate lecture course Chemistry 210.'],
    ['chem', 220, 'Physical Chemistry', 3, 'Principles of physical chemistry covering such concepts as intermolecular forces, reaction kinetics, thermodynamics.'],
    ['chem', 221, 'Physical Chemistry Lab', 2, 'Experimental chemistry to illustrate lecture course Chemistry 220.'],
    ['chem', 300, 'Biological Chemistry', 4, 'Study of chemical processes on cell level with emphasis on function of proteins.'],
    ['chem', 301, 'Biological Chemistry Lab', 2, 'Experimental chemistry to illustrate lecture course Chemistry 300.'],
    ['chem', 314, 'Laboratory Chemistry', 3, 'Extra laboratory for students who are planning to major in chemistry. Covers principles and applications of chemical laboratory techniques, including preparation and analysis of chemical materials.'],
    ['chem', 316, 'Environmental Chemistry', 3, 'Study of chemical and biochemical processes that occur in natural places; includes introduction to atmospheric, aquatic and soil chemistry as well as basics of analytical chemistry.'],
    ['chem', 320, 'Computational Chemistry', 3, 'Computational chemistry with emphasis to simulation of chemical and biological processes.'],
    ['chem', 321, 'Computational Chemistry Lab', 3, 'Laboratory to illustrate theory and give students practice with specific software.'],
    ['chem', 655, 'Protein Folding Problem', 3, 'Focuses on the mechanisms through which the amino acid sequence of polypeptide chains determine their three-dimensional conformation.'],

    ['phys', 108, 'College Physics I', 4, 'This course gives introduction to physics for non-physical majors. Covers mechanics and thermodynamics.'],
    ['phys', 109, 'College Physics II', 4, 'This course gives introduction to physics for non-physical majors. Covers electricity, optics and basics of quantum physics.'],
    ['phys', 121, 'General Physics I: Mechanics', 3, 'This course deals primarily with motions of objects and the forces that underlie these motions, including free fall, collisions between objects, rolling, and spinning.'],
    ['phys', 122, 'General Physics I Lab', 2, 'Laboratory work for lecture course Physics 121.'],
    ['phys', 124, 'General Physics II: Thermodynamics', 3, 'Classic thermodynamic and theory of gases; mechanics of particles, energy, entropy.'],
    ['phys', 125, 'General Physics II Lab', 2, 'Laboratory work for lecture course Physics 124.'],
    ['phys', 128, 'General Physics III: Electricity', 3, 'Electric and magnetic fields, charges, currents, electromagnetic waves.'],
    ['phys', 129, 'General Physics III Lab', 2, 'Laboratory work for lecture course Physics 128.'],
    ['phys', 130, 'General Physics IV: Optics', 3, 'Principles of classical optics including interference, diffraction, polarization, coherence; basics of quantum physics.'],
    ['phys', 131, 'General Physics IV Lab', 2, 'Laboratory work for lecture course Physics 130.'],
    ['phys', 201, 'Relativity Physics', 5, 'Special relativity theory and its influence on mechanics, thermodynamics, electricity, magnetism.'],
    ['phys', 203, 'Relativity & Cosmology', 3, 'The course will describe developments that led to special relativity and its implications about the nature of space and time, as well as general relativity and quantum mechanics.'],
    ['phys', 221, 'Solid State Physics', 6, 'Introduction to solid state physics; crystal structure, conductivity, thermal and optical properties of solids.'],
    ['phys', 222, 'Solid State Physics Lab', 2, 'Laboratory work for lecture course Physics 221.'],
    ['phys', 288, 'Experimental Physics I', 5, 'Extensive laboratory course for students with physical major.'],
    ['phys', 289, 'Experimental Physics II', 4, 'Extensive laboratory course for students with physical major.'],
    ['phys', 350, 'Nuclear Physics', 3, 'Introduction to nuclear and particle physics; elementary particles, nuclear structure, radioactivity.'],
    ['phys', 366, 'Computational Physics', 4, 'Theory and practice in simulation of complex physical systems.'],
    ['phys', 407, 'Quantum Mechanics I', 4, 'Introduction to quantum mechanics: postulates, Heisenberg uncertainty principle, Schrodinger equation, harmonic oscillator, tunneling.'],
    ['phys', 435, 'Quantum Mechanics II', 4, 'Application of the quantum theory to atomic and particle physics.'],
    ['phys', 512, 'Quantum Field Theory', 3, 'This course will cover the basic quantization of bosonic and fermionic fields, discrete space-time symmetries, perturbative methods in QFT, definition of the S-matrix for scattering and decay processes.'],
    ['phys', 713, 'Quarks, Nuclei, and Cosmology', 3, 'General topics covered will include the structure of the nucleon, beta decay and weak interactions, and nucleon-nucleon interaction.'],
    ['phys', 819, 'Superconductivity', 3, 'This course provides a phenomenological approach to superconductivity, emphasizing super-conducting electronics.'],

    ['mth', 101, 'College Algebra I', 4, 'This course, taken mostly by members from the School of Business is a primary graduate student funding vehicle for the Department of Mathematics.  This is a 1000 person lecture reviews basic concepts taught in high school.'],
    ['mth', 102, 'College Algebra II', 4, 'Continuation of the course Mathematics 101.'],
    ['mth', 120, 'Calculus I', 3, 'Introduction to differential and integral calculus (lecture and practice).'],
    ['mth', 121, 'Calculus II', 3, 'Advanced integration techniques. Continuation of course Mathematics 120.'],
    ['mth', 122, 'Calculus III', 3, 'Introduction to multivariable calculus. Continuation of course Mathematics 121.'],
    ['mth', 211, 'Linear Algebra', 4, 'Topics: matrices, vector spaces, linear transformations.'],
    ['mth', 228, 'Probability and Statistics', 5, 'Introduction to probability theory and statistical analysis. Covers such topics as combinatorial analysis, mathematical expectation, common probability distributions, confidence intervals, regression, analysis of variance.'],
    ['mth', 230, 'Ordinary Differential Equations', 3, 'Introduction to theory and solution methods of ordinary differential equations.'],
    ['mth', 253, 'College Geometry', 4, 'Course of advanced Euclidian geometry as well as introduction to other geometries.'],
    ['mth', 315, 'Partial Differential Equations', 3, 'Introduction to theory and solution methods of partial differential equations.'],
    ['mth', 318, 'Modern Algebra', 4, 'Introduction to algebraic structures, theory of groups, rings, fields.'],

    ['eng', 101, 'Introduction to Composition', 3, 'Provides students with the fundamental skills to read, interpret, and write critically at the college level.'],
    ['eng', 102, 'Introduction to Literary Genres', 3, 'Introduction to main genres of the world literature with overview of the most significant works.'],
    ['eng', 105, 'National Epic', 3, 'Study of style, meanings, cultural context and value of North Europe medieval epics.'],
    ['eng', 106, 'Ancient Literature', 5, 'Most significant Greek and Roman authors and their works including Homer "Odyssey", Cicero speeches, Julius Caesar "The Gallic Wars".'],
    ['eng', 155, 'English Literature I', 5, 'English literature of 16-17th centuries.'],
    ['eng', 156, 'English Literature II', 5, 'English literature of Neoclassic, Romantic and Victorian periods.'],
    ['eng', 175, 'College Newspaper', 2, 'Students will perform journalistic writing exercises for publication in the college newspaper.'],
    ['eng', 206, 'American Literature', 5, 'American literature up to the start of the 20th century.'],
    ['eng', 211, 'Writing Styles I', 3, 'This practical course aids in understanding and writing non-fiction. We will look at some of the ways that prominent English writers have constructed their sentences and paragraphs. Students will write weekly exercises exploring these stylistic patterns.'],
    ['eng', 212, 'Writing Styles II', 3, 'Second part of course English 211. Topics of writing are (by student choice): science, art, politics, law, medicine, environment.'],
    ['eng', 222, 'Modern English Grammar', 5, 'Morphology and syntax of modern English language, major English dialects.'],
    ['eng', 247, 'Boccaccio''s Decameron', 3, 'Follows of the arc of the career Boccaccio with an emphasis on the Decameron, which is read in light of its cultural density and contextualized in terms of its antecedents, especially the Commedia of Dante.'],
    ['eng', 250, 'Shakespeare Tragedies', 3, 'Overview of the William Shakespeare''s tragedies with emphasis on style traits, language peculiarity, problematic and evolution from early works to the latest.'],
    ['eng', 276, 'Introduction to Science Writing', 4, 'This course provides an introduction to science writing. Students will learn about the business of science writing and will become familiar with the craft of making complex scientific research understandable for the general public.'],
    ['eng', 306, 'English and American Modern Literature', 5, 'English and American literature of the 20th century and to the present day.'],
    ['eng', 321, 'Rhetoric', 3, 'Theory and practice in being a speaker, rhetorical strategies, argumentation.'],
    ['eng', 324, 'Journalism', 3, 'Principles of journalistic writing, as well as news gathering; student practice.'],
    ['eng', 326, 'Playwriting', 3, 'Principles and requirements of playwriting; students write one act plays, in-class presentation and discussion.'],
    ['eng', 330, 'Fiction Writing', 3, 'Introduction to the craft of fiction writing; student practice.'],
    ['eng', 412, 'Ecology Writing Workshop', 2, 'This monthly workshop will focus on creation of a course assignment, a feature-length magazine article covering a complex topic in ecology.'],
    ['eng', 428, 'Poetry', 3, 'Principles of prosody, variety of forms and traditions in the world poetry, student practice.'],

    ['lang', 105, 'Introduction to Linguistics', 6, 'Broad introduction to linguistics: sound systems of natural languages, common concepts of phonology, morphology, syntax and semantic.'],
    ['lang', 108, 'Language Basics', 3, 'Covers psychological and sociological aspects of the language, its influence on cognitive process.'],
    ['lang', 121, 'Introduction to Spanish', 3, 'Introduction to the Spanish language, with an emphasis on every day conversation and basic grammar.'],
    ['lang', 122, 'Introduction to French', 3, 'Introduction to the French language, with an emphasis on every day conversation and basic grammar.'],
    ['lang', 123, 'Introduction to German', 3, 'Introduction to the German language, with an emphasis on every day conversation and basic grammar.'],
    ['lang', 140, 'Roman Languages', 4, 'This course examines languages of the Roman group, their structure and difference between Roman languages and English.'],
    ['lang', 202, 'Phonetics', 3, 'Mechanisms of speech sound production, sound systems of different languages, perception and production of various sounds, transcription symbol system.'],
    ['lang', 204, 'Morphology & Syntax', 3, 'Morphology and syntax principles, language structure with examples from various modern languages.'],
    ['lang', 221, 'Intermediate Spanish I', 4, 'Continuation of fundamental Spanish language learning, including verb tenses, reading skills, and basic conversation.'],
    ['lang', 222, 'Intermediate French I', 4, 'Continuation of fundamental French language learning, including verb tenses, reading skills, and basic conversation.'],
    ['lang', 223, 'Intermediate German I', 4, 'Continuation of fundamental German language learning, including verb tenses, reading skills, and basic conversation.'],
    ['lang', 304, 'Spanish Conversation Group', 2, 'Informal weekly conversation group designed to improve understanding of spoken Spanish. Suitable for both majors and casual speakers who wish to improve their skills for personal enjoyment or travel.'],
    ['lang', 305, 'Second Language Syntax', 3, 'This course examines the form and acquisition of nonnative syntax. Consideration of whether nonnative grammars are fundamentally different than native grammars.'],
    ['lang', 321, 'Intermediate Spanish II', 4, 'Continuation of fundamental Spanish language learning, second semester of Language 221.'],
    ['lang', 322, 'Intermediate French II', 4, 'Continuation of fundamental Spanish language learning, second semester of Language 222.'],
    ['lang', 323, 'Intermediate German II', 4, 'Continuation of fundamental German language learning, second semester of Language 2232.'],
    ['lang', 345, 'Psycholinguistics', 3, 'Covers dependencies between language and cognitive function, influence of mental illness to speech, connection of language to other mental abilities.'],
    ['lang', 426, 'Latin', 4, 'Basics of the Latin language, ability to read and understand.'],
    ['lang', 427, 'Sanskrit', 5, 'Basics of Sanskrit language with focus on grammar, reading of classical texts.'],
    ['lang', 437, 'Child Speech Function Development', 3, 'Covers development of child speech function during the first years of life, peculiarities of child language perception and strategies of language acquisition.'],
    ['lang', 438, 'Child Second Language Development', 3, 'Examines issues in child second language acquisition, including the critical period hypothesis and universal grammar.'],

    ['hist', 112, 'The United States in World History', 3, 'Examines the meaning of empire in relationship to the historical development of the United States of America.'],
    ['hist', 120, 'Ancient History', 5, 'History of the western civilization from prehistoric period to the fall of the Roman Empire.'],
    ['hist', 121, 'Middle Ages', 5, 'History of the western civilization from 5th to 15th century.'],
    ['hist', 122, 'Modern History', 5, 'History of the western civilization from 15th century to the present day.'],
    ['hist', 212, 'Historical Perspective on the Constitution', 3, 'This course covers the development of the constitutional doctrine from 1787 to the present. The Constitution as an experiment in Republicanism.'],
    ['hist', 220, 'East Asian Empires', 4, 'History of the East Asian region from seventh century to the World War II.'],
    ['hist', 238, 'Islam History', 3, 'Development of the Islam religion from 10th century to the present day, history of Muslims in the South Asia.'],
    ['hist', 240, 'Hundred Year''s War', 3, 'Considers historical context, flow, significant persons and consequences of the war. Student personal investigations and presentations on related topics.'],
    ['hist', 256, 'Ancient Rome', 3, 'History of the Rome from foundation of the city through Republic and Empire to the fall.'],
    ['hist', 329, 'Age of Discovery', 3, 'History of period from early 15th to early 17th centuries - period of intensive exploration and mapping of the planet. Expeditions, persons and global impact of the period.'],
    ['hist', 333, 'History of American Education', 3, 'A study of informal and formal education in American history leading to an understanding of present educational theory and practice.'],
    ['hist', 358, 'Religion in America', 3, 'Covers traditional native American beliefs and modern religions coexisting in US.'],
    ['hist', 415, 'History of the Family in Global Perspective', 3, 'Has the family really declined? What has changed in the last 1000 years? Drawing on cross-cultural examples, primarily from Latin America, the U.S. and Europe, this seminar explores the varieties of domestic forms.'],
    ['hist', 434, 'Historical Method', 3, 'Techniques and guidelines how historians use primary sources and other research methods; student practice.'],
    ['hist', 435, 'Research Project', 3, 'Student practice in History 434 making sample research project.'],
    ['hist', 505, 'Science and History', 3, 'Introduces students to approaches and methods in the history of science, technology, and medicine'],
    ['hist', 519, 'Introduction to Archeology', 3, 'Covers history and evolution of the archeology, investigation methods and overview of the subdisciplines; student practice.'],

    ['psych', 102, 'General Psychology', 5, 'This course introduces the student to the major topics in scientific psychology as applied to human behavior. Applications of these principles will be made to the human experience.'],
    ['psych', 121, 'Measurements and Statistical Analysis', 3, 'Role of measurements in psychology and statistical techniques: frequency distributions, graphic methods, regression and correlation.'],
    ['psych', 122, 'Measurements and Statistical Analysis Lab', 2, 'Practical course to complement Psychology 121.'],
    ['psych', 220, 'Introduction to Neuroscience', 3, 'Study of neural basis of mammals psychological functions. Required for more specific neuroscience courses.'],
    ['psych', 225, 'Behavioral Neuroscience', 3, 'Study of complex behavioral processes of mammals and human.'],
    ['psych', 226, 'Behavioral Neuroscience Research Method', 3, 'Students study brain functions and behavior in laboratory.'],
    ['psych', 231, 'Psychology of Learning', 3, 'Psychological processes that support learning process: memory, motivation, role of practice, award and emotion.'],
    ['psych', 304, 'Introduction to Cognitive Psychology', 4, 'An introduction to the basic concepts of cognitive psychology, including areas such as perception, attention, memory, language, and thought.'],
    ['psych', 305, 'Cognitive Psychology Lab', 2, 'Examines research methods of the cognitive psychology to complement course Psychology 304'],
    ['psych', 339, 'Social Psychology', 3, 'Psychological analysis of human social behavior, interpersonal processes and goup influences.'],
    ['psych', 340, 'Social Psychology Lab', 3, 'Examines research methods of social psychology, student group training.'],
    ['psych', 345, 'Generic Psychopathology', 4, 'Study of mental illnesses, their symptoms and biological reasons.'],
    ['psych', 350, 'Clinical Psychology', 3, 'Study of preventing and relieving psychologically based distress or dysfunction.'],
    ['psych', 351, 'Clinical Psychology Lab', 4, 'Students will have field study in one of the clinics.'],
    ['psych', 450, 'Laboratory in Applied Behavioral Science', 4, 'This course will provide students with hands-on training in the application of behavioral research technology to a clinical population.'],
    ['psych', 560, 'Examination of Real-Time Language Processing', 4, 'This lab course examines methods for the real-time examination of language processing in normal and disordered language populations.'],
    ['psych', 610, 'Applied Child Psychology', 3, 'Introduction to major concepts and models used in psychological assessment and psychotherapeutic intervention of children. Several modalities of psychotherapy (individual, group, and family) will be reviewed along with research on their efficacy.'],

    ['poli', 113, 'American Government and Politics', 3, 'This course examines the structure, services, functions, and problems of government and politics at the national level.'],
    ['poli', 129, 'Civil Rights', 3, 'History of civil rights formation with focus on civil movements in US, detailed examination of civil rights and their religious, philosophical and political aspects.'],
    ['poli', 134, 'American Legal Systems', 3, 'Introduction to US law enforcement system: organizations and personnel, law and procedure.'],
    ['poli', 150, 'Political Regimes', 3, 'Examines variety of political regimes in world history.'],
    ['poli', 176, 'Political Philosophy', 3, 'History of political thinking from ancient era to the present day. Considered philosophers are Plato, Aristotle, Machiavelli, Hobbes, Montesquieu, Adam Smith and others.'],
    ['poli', 177, 'Problems of Political Philosophy', 3, 'Seminars on topics related to the lecture course Politics 176.'],
    ['poli', 223, 'World Political History I', 3, 'Analysis of political events, ideas, movements and leaders. First semester covers topics up to the Renaissance period.'],
    ['poli', 224, 'World Political History II', 3, 'Continuation of the course Politics 223.'],
    ['poli', 243, 'Introduction to World Politics', 3, 'Covers principles and systems of international relations, international behavior of nations, war, diplomacy, world economic.'],
    ['poli', 251, 'Constitution', 3, 'World experience in constitutional law, relationships between individual and government, basic constitutional principles.'],
    ['poli', 320, 'International Organizations', 3, 'Role of international organizations in global problem solving, inter-government and nongovernment organizations, United Nations.'],
    ['poli', 347, 'American Foreign Policy', 3, 'Theories, processes, and problem of American foreign policy and the craft of diplomacy, with special attention to contemporary issues.'],
    ['poli', 354, 'European Political Economy', 5, 'Examines dependencies between political and economic conditions in the modern Europe, reasons and consequences of the Europe integration as well as development prospects.'],
    ['poli', 380, 'American Environmental Policy', 3, 'Study of US environment policies, their development, comparison of national and foreign approaches to environmental politics and policymaking.'],
    ['poli', 392, 'Problems of Environmental Politics', 3, 'Seminar that focuses on tensions between politics and business in the area of environmental policy.'],
    ['poli', 402, 'Government Internship: Semester in Washington', 4, 'Junior or seniors with a 3.0 grade point average or higher may apply for a limited number of internship opportunities in Washington, DC. Interns will live at University House on Capitol Hill and continue their normal class schedule at the DC Campus.'],
    ['poli', 431, 'American Government and Corporate Interests', 3, 'This course will examine the methods by which American business exert influence over legislators and the legislative process.'],
    ['poli', 644, 'Research Seminar in Middle Eastern Affairs', 3, 'Government and Politics of the Middle East and North Africa Spring. Historical background, contemporary setting, political processes, and major problems of some of the countries of Middle East and North Africa.'],
    ['poli', 715, '#5 is the 50% Solution', 3, 'A history of the two-state solution and other approaches to Palestinian Statehood'],

    ['comp', 102, 'Introduction to Computer Science', 6, 'This course in an introduction to the discipline of computer science. Topics include algorithmic foundations, hardware concepts, virtual machine concepts, software systems, applications, and social issues.'],
    ['comp', 130, 'History of Computing', 3, 'This course will survey the history of the computing field from antiquity to the present, focusing on the era of the electronic digital computer. Topics will include historical developments in hardware, software, and the theoretical foundations of computer science.'],
    ['comp', 150, 'Introduction to Programming Languages', 4, 'Examines different types of programming languages, programming paradigms, comparative analysis of features and design. Basic concepts of programming languages: syntax and semantics, typing, scoping and others.'],
    ['comp', 151, 'Programming Lab', 3, 'Practice in programming in university computer lab. Programming language is chosen by instructor.'],
    ['comp', 166, 'Data Structures I', 3, 'Study of different data structures: arrays, stacks, queues, lists, trees, graphs and their application to effective computing.'],
    ['comp', 167, 'Data Structures II', 3, 'Advanced topics on data structures include building of large-scale structures, problems of storing large amounts of data and ways to solve this problems.'],
    ['comp', 206, 'Algorithms I', 3, 'Basics of algorithms theory, algorithmic efficiency, fundamental algorithms and approaches, searching and soring, data compression.'],
    ['comp', 207, 'Algorithms II', 3, 'Continuation of the course Computing 206: tree and graph algorithms.'],
    ['comp', 215, 'Computer Organization', 3, 'Organization of the computer hardware: micro-processor architecture, instruction set, memory, addressing, caches, peripherals, IO concepts.'],
    ['comp', 216, 'Computer Organization Lab', 2, 'Programming on the laboratory stand, which consists of micro-controller with embedded memory and simple peripherals: keyboard, speaker, LCD, nonvolatile memory.'],
    ['comp', 228, 'Operating Systems', 3, 'Concepts and main subsystems of modern operating systems: process management and concurrency, CPU scheduling, memory management, IO device management, file systems, security considerations. Overview of desktop, mainframe and real-time operation systems.'],
    ['comp', 304, 'Database Theory', 4, 'ER-models, normal forms, normalization and denormalization, database design principles, introduction to modern Relational Database Management Systems, overview of non-relational systems.'],
    ['comp', 305, 'Database Theory Lab', 3, 'Provides practice in database design and database management system administration.'],
    ['comp', 314, 'Computer Networks', 4, 'Basic principles of signal transmission, transmission media (wired and wireless), local and global networks, network protocols.'],
    ['comp', 350, 'Introduction to Signal Processing', 3, 'This course covers the nature of information, signals, transforms, and applications. Topics include analog to digital and digital to analog conversion, data storage (such as the audio format MP3), data transforms, and filters.'],
    ['comp', 415, 'Theory of Computation', 3, 'Abstract automata, finite-state machines, Turing machines, formal languages, relationships between automata and languages.'],
    ['comp', 437, 'Information Assurance', 3, 'Topics in information confidentiality, integrity and availability. Authorization and authentication, encryption principles, symmetric and asymmetric encryption.'],
    ['comp', 515, 'Software Design', 3, 'Study of good software development techniques: UML, object-oriented design, design patterns, GUI design principles, testing, debugging and profiling.'],
    ['comp', 710, 'Laboratory in Computer Science', 4, 'Independent research opportunity using the university computer lab. Requires instructor permission and may be repeated.'],
    ['comp', 810, 'Thesis Research', 3, 'Guided research leading to production of the thesis. Requires instructor permission and may be repeated.'],
    ['comp', 819, 'Advanced Algorithms in Bioinformatics', 3, 'This course is focused on fundamental algorithmic techniques in Bioinformatics, including classed methods such as dynamic programming, support vector machines and other statistical and learning optimization methods.'],

    ['ee', 107, 'Exploration of Electrical Engineering', 4, 'Exploration of electrical engineering through several hands-on activities that cover a broad spectrum of applications and fundamental concepts. '],
    ['ee', 202, 'Engineering Electromagnetics', 3, 'Static electric and magnetic fields; solutions to static field problems, electromagnetic waves, boundary conditions, engineering applications.'],
    ['ee', 220, 'Semiconductor Devices', 3, 'Theory of semiconductor devices, principles of design and fabrication, p-n junctions, bipolar transistors, their structure, operation modes and application, MOS capacitors and MOSFETs.'],
    ['ee', 221, 'Semiconductor Devices Lab', 2, 'Provides practical examination of semiconductor devices properties.'],
    ['ee', 228, 'Circuits and Electronics', 3, 'Fundamentals of lumped circuit abstraction: resistive elements and networks, energy storage elements, switches, amplifiers, analog and digital circuit principles.'],
    ['ee', 251, 'Mathematical Methods in Engineering', 3, 'Topics in mathematics useful in engeineering: differential equations, Fourier series, Laplace transforms, boundary value problems.'],
    ['ee', 315, 'Signals and Systems', 3, 'Concepts of continuous and digital signal analysis, modeling continuous and discrete linear dynamical systems.'],
    ['ee', 319, 'Electric Power Systems', 3, 'Introductory course to the field of electric power and electrical to/from mechanical power conversion.'],
    ['ee', 329, 'Optical Communication', 3, 'Study of optical communication systems with emphasis on physics of the optical processes and system functional units.'],
    ['ee', 412, 'Laboratory in Electrical Engineering', 4, 'Hands-on experience covering areas of optical transforms, electro-optics devices, signal processing, fiber optics transmission, and holography.'],
    ['ee', 436, 'PCB Design', 3, 'Principles of PCB design, development and manufacturing process details.'],
    ['ee', 437, 'PCB Design Lab', 3, 'Practice in PCB design using specific software.'],
    ['ee', 505, 'Information Theory', 3, 'Mathematical measurement of information; information transfer in discrete systems; redundancy, efficiency, and channel capacity; encoding systems.'],
    ['ee', 615, 'Learning and Adaptive Systems', 3, 'Adaptive and learning control systems; system identification; performance indices; gradient, stochastic approximation, controlled random search methods; introduction to pattern recognition.'],

    ['me', 111, 'Introduction to Mechanical Engineering', 3, 'Topics include an overview of career opportunities, problem solving processes, an introduction to the basic engineering design process, professionalism, professional registration, and ethics.'],
    ['me', 141, 'Solid Mechanics I', 3, 'Study of properties of different engineering materials, their atomic and molecular origin, forces on and within various engineering structures, relations between forces and deformation.'],
    ['me', 142, 'Solid Mechanics II', 3, 'Continuation of the course Mechanical Engineering 141. Includes such topics as corrosion, thermal and electrical conduction, basics of material selection and how materials limit mechanical design.'],
    ['me', 143, 'Solid Mechanics Lab', 3, 'Practical demonstration of solid materials properties, comparison between theory and experimental results.'],
    ['me', 201, 'Dynamics and Control', 4, 'Considers vibration and other dynamical processes in mechanical systems, system modelling, linear stability analysis, numerical methods in dynamical problem modelling and solving.'],
    ['me', 202, 'Dynamics and Control Lab', 2, 'Dynamical system modelling using specific software.'],
    ['me', 221, 'Hydrodynamics', 3, 'Fundamental principles of hydrodynamics and their application to solving engineering problems, geophysical fluid dynamics, various parameters of the ocean and their balance.'],
    ['me', 222, 'Hydrodynamics Lab', 2, 'Experience in applying principles of fluid mechanics, occasional visits to ocean engineering laboratories.'],
    ['me', 231, 'Aerodynamics', 3, 'Review of fluid dynamics, inviscid flows, finite wing theory, boundary layers, turbulence, compressible aerodynamics.'],
    ['me', 232, 'Aerodynamics Lab', 2, 'Practical fastening of aerodynamic principles using a wind tunnel.'],
    ['me', 315, 'Control Systems', 4, 'Fundamentals of feedback control, linear and non-linear systems, system stability, continuous and discrete control systems.'],
    ['me', 331, 'Mechanical Design', 3, 'Provides knowledge in modelling, design, integration and manufacture of machine mechanisms.'],
    ['me', 332, 'Mechanical Design Lab', 3, 'Laboratory project to model, design and fabricate a mechanical system that has a real engineering purpose.'],
    ['me', 344, 'Undergraduate Research', 4, 'Undergraduates will conduct independent research activities under the direction of their major adviser.'],
    ['me', 420, 'Introduction to Robotics', 3, 'Overview of robot mechanisms, intelligent control, spatial mechanics, manipulators and mobile robots, human interface, embedded software.'],
    ['me', 437, 'Nonlinear Dynamics', 3, 'Introduction to the chaos theory and nonlinear dynamics with application to engineering tasks.'],
    ['me', 501, 'Advanced Welding', 3, 'Advanced applications of welding and machine tool technology. Computer numerical control, multi-axis machining set-up, gas tungsten arc welding, and gas metal arch welding.'],
    ['me', 627, 'Advanced Heating and Air Conditioning', 4, 'Course includes various topics focused on heating and conditioning systems design, operation and controls with emphasis on diagnosis, service requirements and procedures.'],
    ['me', 712, 'Graphic Communication and Design', 3, 'Sketching and orthographic projection. Covers detail and assembly working drawings, dimensioning, tolerance specification, and design projects.'],

    ['be', 108, 'Fundamentals of Biochemistry', 3, 'Fundamental aspects of human biochemistry are introduced in this course for students in the bioinstrumentation/biosensors, biomechanics, and medical-imaging tracks.'],
    ['be', 112, 'Introduction to Biomedical Engineering', 3, 'This course covers topics in multiple formats ranging from lectures by faculty or guest speakers to presentations by participating students.'],
    ['be', 136, 'Introductory Microbiology', 3, 'Study of basic processes on cell and molecular level with emphasis on interaction between human cells and microbes.'],
    ['be', 162, 'Introductory Toxicology', 3, 'Chemicals and their influence on human health: internal distribution, metabolism, biological effect, detection and treatments.'],
    ['be', 173, 'Bioengineering Seminar', 2, 'Student presentations on various bioengineering topics by choice based on scientific articles.'],
    ['be', 228, 'Physiology and Biomechanics I', 3, 'Human physiology with emphasis on biomechanical properties of tissues and their role in physiological regulation, modelling of physiological processes, artificial organs design.'],
    ['be', 229, 'Physiology and Biomechanics II', 3, 'This is second semester of year-long course, continuation of Bioengineering 228.'],
    ['be', 230, 'Biological Engineering Thermodynamics', 3, 'Fundamental laws of thermodynamics, energy, entropy, application of thermodynamics principles to biological systems.'],
    ['be', 241, 'Transport', 4, 'Hydrologic cycle, water and solute movement, fundamental principles of hydrodynamics, heat and mass transfer, diffusion, pumps, blood as a transport medium.'],
    ['be', 272, 'Computational Methods in Bioengineering', 3, 'Mathematical methods in formulating and solving of bioengineering problems, environmental and biological system modelling, numerical analysis and simulation.'],
    ['be', 310, 'Bioengineering Laboratory', 3, 'Students get familiar with experimental biochemical and molecular techniques and laboratory tools.'],
    ['be', 345, 'Environmental Toxicology', 3, 'Study of how chemicals move within the environment, US law regulating chemical composition of air, soil and water, permissible standards of chemicals, pollutions, their sources, effects and control methods.'],
    ['be', 356, 'Cell Membrane and Transport', 3, 'Cell membrane structure, diffusion, passive and active transport, carrier-assisted transport, functions of cytoskeleton and its role in intracellular transport.'],
    ['be', 387, 'Biomedical Imaging', 3, 'Various methods of getting biomedical images including ultrasonic scanning, X-ray tomography, magnetic resonance and others, basic concepts of image processing, enhancement and analysis techniques.'],
    ['be', 415, 'Internship in Biomedical Engineering', 8, 'The student will work twenty hours per week in an area firm to gain experience in the application of biomedical engineering principles in an industrial setting.'],
    ['be', 437, 'Biotechnology Seminar', 2, 'Discussion of modern biotechnology science achievements in the perspective of improving quality of life.'],
    ['be', 509, 'Systems of Drug Delivery', 3, 'The mathematics of diffusion through various types of biological media is discussed.'],

    ['arthis', 102, 'History of Art Criticism I', 4, 'An introductory survey course of world art from Prehistoric through late-Medieval art history.'],
    ['arthis', 103, 'History of Art Criticism II', 3, 'An introductory survey course of world art from 15th century through the present.'],
    ['arthis', 204, 'North American Native Art', 3, 'Visual art of North American natives from prehistoric times to the present day.'],
    ['arthis', 209, 'Antique Art: Greece and Rome', 6, 'Visual art of antique period with emphasis on Greek and Roman art.'],
    ['arthis', 210, 'Antique Art: The Middle East', 4, 'Visual art of ancient world civilizations: Egypt, Mesopotamia, Persia.'],
    ['arthis', 224, 'Arts of Asia', 3, 'An introduction to the history and criticism of Far Eastern art, including the art of China and Japan, fine and decorative arts.'],
    ['arthis', 231, 'Medieval Christian Art', 3, 'Visual art of medieval Europe, role of monasteries, expansion of patronage in the late medieval age.'],
    ['arthis', 315, 'Asian Architecture', 3, 'Overview of basic built forms in Asia and their main traits as well as most significant structures in the cultural context.'],
    ['arthis', 318, 'Italian Renaissance Art', 3, 'Italian architecture, sculpture and painting in 15-16th centuries with emphasis on works of Botticelli, Leonardo, Rafael, Michelangelo, Titian.'],
    ['arthis', 325, 'Dutch and Flemish Painting', 3, 'Development of Netherlandish painting in 15-19th centuries including works of Van Eyck, Vermeer, Rembrandt, Van Gogh.'],
    ['arthis', 354, 'Impressionism', 3, 'French impressionism movement in the second half of the 19th century, social and cultural context.'],
    ['arthis', 436, 'Modernism', 3, 'Development of the modernism from the end of 19th century to the WWII. Major persons and movements like symbolism, futurism, surrealism.'],
    ['arthis', 439, 'Postmodernism', 3, 'Visual art and culture in America and Europe after WWII, postmodernism theory and practice, role of art in the consumerist society.'],
    ['arthis', 476, 'Islamic Art', 5, 'History of Islamic visual arts and their religious value.'],
    ['arthis', 540, 'Art of Photography', 5, 'History of photography from origins to the present. Significant persons, movements, role of photography in the fine arts.'],
    ['arthis', 552, 'Industrial Architecture', 3, 'Overview of the industrial architecture from the end of the 19th century to the present day, modern requirements to the industrial architecture, particular projects.'],
    ['arthis', 623, 'Contemporary Latin American Art', 3, 'A survey of the last twenty years of Latin American art with a focus on the Caribbean and Central America.'],
    ['arthis', 710, 'Methods in Art History', 3, 'This seminar focuses on basic types of art-historical method. Some meetings focus on a single author who exemplifies a particular approach.'],
    ['arthis', 712, 'Museum and Gallery Management', 4, 'Supervised independent field experience and practical work in all areas of Art Museum management in the university and greater metropolitan area communities.'],
    ['arthis', 809, 'Materials and Construction in European Art', 3, 'A scientific examination of the materials and manufacturing techniques employed in Europe over the last two centuries.'],

    ['stdart', 101, 'Introduction to Drawing', 3, 'Exploration of the structure and interrelationships of visual form in drawing, painting, and sculpture. Principal historical modes of drawing are examined.'],
    ['stdart', 106, 'Observational Drawing', 4, 'Studio experience in basic drawing concepts: line, shape, light, space, composition.'],
    ['stdart', 119, 'Spring Basket Weaving Workshop', null, 'A just-for-fun chance to learn the basics of basket weaving.'],
    ['stdart', 130, 'Ceramics I', 4, 'Introduction to pottery and applied chemistry, glaze composition, kiln-firing techniques.'],
    ['stdart', 206, 'Field Drawing', 4, 'Landscape drawing practice with emphasis on space analyzing and tint-taking. Most of the classwork is done outside.'],
    ['stdart', 218, 'Composition', 3, 'Theory of visual organization, design principles and best practices, relationships of light, color and space.'],
    ['stdart', 230, 'Ceramics II', 4, 'Advanced pottery and other ceramics techniques.'],
    ['stdart', 235, 'Introduction to Painting', 4, 'Practical application of color principles, paint application and painting techniques.'],
    ['stdart', 251, 'Photography', 6, 'Lectures, demonstrations and practice in work with 35mm analog photocamera, exploration of various photography genres, personal project.'],
    ['stdart', 272, 'Printmaking I', 3, 'Basic intaglio concepts: etching, engraving, drypoint, aquatint, mezzotint.'],
    ['stdart', 309, 'Life Drawing', 4, 'Practice in drawing live objects and human in particular with main focus to improve sense of shape.'],
    ['stdart', 352, 'Digital Photography', 4, 'Specific of digital photography, techniques of digital image processing.'],
    ['stdart', 370, 'Printmaking II', 3, 'Basic concepts of lithography, advanced intaglio techniques.'],
    ['stdart', 411, 'Underwater Basket Weaving', 4, 'This course provides a novel perspective on the traditional art of basketry as it is experienced in reduced gravity and in the context of fluid dynamics. Requires instructor permission and a valid c-card.'],
    ['stdart', 453, 'Advanced Painting', 6, 'Advanced painting studio, exploration of various painting materials, personal project.'],
    ['stdart', 509, 'Twentieth Century Printmaking', 4, 'Development of personalized concepts and individual aesthetic expression in printmaking with reference to various styles and trends in Twentieth Century printmaking.'],
    ['stdart', 512, 'Art in Therapy', 3, 'Surveys methods and results of using art and craft therapy with developmentally disabled adults.'],
    ['stdart', 614, 'Drawing Master Class', 5, 'For fine arts majors only, an intensive studio study including field trips to local parks and museums and a final group art show.'],
    ['stdart', 714, 'Peer Portfolio Review', 0, 'An opportunity to practice giving and receiving constructive criticism.'],

    ['tched', 110, 'Teaching Methodology', 3, 'Study of pedagogical practices in general including theoretical and research basis.'],
    ['tched', 122, 'Theory and Practice of Early Childhood Education', 3, 'Emphasis on the skills and processes needed for the design and implementation of optimal learning environments. Exploration of issues related to societal and cultural influences on the education of young children.'],
    ['tched', 155, 'Methods of Early Science Education', 3, 'A study of the curriculum methods, concepts, techniques, and materials in the teaching of general science to children in the early grades.'],
    ['tched', 179, 'Play as Education Method', 3, 'Considers various aspects of play and their application to education process of preschool children.'],
    ['tched', 208, 'Developmental Psychology', 4, 'Explores lifespan development of a human individual through development theory, interrelations of biological, cognitive and psychological aspects of development.'],
    ['tched', 211, 'Selection of Learning Resources', 3, 'Methodology of printed, demonstrational and others learning resources.'],
    ['tched', 256, 'Teacher Identity', 3, 'This course explores the nature of teaching and learning, their different forms in the society, ultimate influence of the teacher identity to the teaching process. Case-studies and group training will help students to form their own teacher identity'],
    ['tched', 367, 'Problems in Education Management', 3, 'This course is designed to assist the student to prepare for management of educational organizations and programs. Emphasis will be placed upon identifying specific problems and developing specific techniques by which to solve them.'],
    ['tched', 401, 'Challenges of Teaching the Gifted and Talented', 3, 'The nature and needs of the talented and gifted in all areas of development are explored.'],
    ['tched', 430, 'Techniques of Mathematics Teaching', 4, 'Various techniques and specific aspects related to teaching of mathematics; teaching approach, objectives, short- and long-term planning.'],
    ['tched', 435, 'Techniques of Science Teaching', 4, 'Various techniques and specific aspects related to teaching of science; teaching approach, objectives, short- and long-term planning.'],
    ['tched', 440, 'Techniques of Language Teaching', 4, 'Various techniques and specific aspects related to teaching of language; teaching approach, objectives, short- and long-term planning.'],
    ['tched', 500, 'Problems in Education', 4, 'Student personal investigation and report of a problem, in-class discussion.'],
    ['tched', 509, 'Public School Internship', 5, 'On-site supervised instructional experience within a public school setting under the leadership of an appropriate, competent professional.'],
    ['tched', 510, 'Preschool Internship', 5, 'Supervised internship in a preschool or kindergarten setting.'],
    ['tched', 520, 'Special Topics in Teacher Education', 4, 'Advanced study of selected topics in teacher education. This course may be taken repeatedly.'],
    ['tched', 630, 'Practice of Mathematics Teaching', 6, 'Practice as a competent mathematics teacher in one of the public schools.'],
    ['tched', 635, 'Practice of Science Teaching', 6, 'Practice as a competent science teacher in one of the public schools.'],
    ['tched', 640, 'Practice of Language Teaching', 6, 'Practice as a competent language teacher in one of the public schools.'],

    ['edpol', 102, 'Introduction to Education', 3, 'Historical overview of education in political and philosophical context, role of education, comparison of contemporary and former educational practices.'],
    ['edpol', 117, 'Contemporary Society', 3, 'Provides basics of social analysis and perspectives of contemporary society development.'],
    ['edpol', 131, 'Sociology of Childhood', 3, 'This course gives understanding of various aspects of childhood including historical, philosophical, economic, considers children rights and diversity of childhood experiences, explores how this concepts impact education and care of children.'],
    ['edpol', 202, 'Technology in the Classroom', 3, 'Theories and practice of using educational technologies to support problem-based learning.'],
    ['edpol', 213, 'Technology, Society and Schools', 3, 'Examination of theories and history of interaction of society and technology with implications for instructional technology and schooling. Resources for constructing personal definitions of technology.'],
    ['edpol', 229, 'Economics and Education Policy', 3, 'This course introduces some basic economic concepts and explores how they affect educational process and ways of regulating.'],
    ['edpol', 231, 'Politics and Education Policy', 3, 'This course examines intersection of politics and education, study of US educational system.'],
    ['edpol', 236, 'Education Policy Analysis', 3, 'Explores the variety of concerns when analyzing educational policy, how the policy is generated and how it faces educational problems.'],
    ['edpol', 301, 'Children''s Literature', 3, 'Theory of visual literature, interrelationships between images and text, critical analysis of picture books.'],
    ['edpol', 316, 'Education Policy and Practice', 3, 'This course explores how policy is expressed in practice and how practice forms policy as well as interrelationships between state and social policies.'],
    ['edpol', 337, 'Social Analysis of Education Policy', 3, 'Study of education policy analysis in liberal values and ideals perspective. Course is focused on political philosophy including reading and discussing classical texts.'],
    ['edpol', 351, 'Classroom Visit', null, 'Elective visit to a local classroom for observation.'],
    ['edpol', 413, 'Organizational Analysis of Education Policy', 3, 'This course examines organizational structure of US and foreign education systems to derive main principles of structural organization, develops capability to think and reason analytically using proper concepts and terminology.'],
    ['edpol', 431, 'Seminar in Education Policy I', 3, 'This course introduces cutting edge research in education policy, students read and discuss various documents and articles, get involved in campus research process.'],
    ['edpol', 432, 'Seminar in Education Policy II', 3, 'This is the second semester of two-semester long seminar course Educational Policy 431.'],
    ['edpol', 505, 'Qualitative Research in Education Policy', 3, 'This course provides an introduction to qualitative research at the Master level.'],

    ['econ', 101, 'Introduction to Microeconomics', 6, 'This course gives students understanding of market mechanism, consumer choice theory, formation of prices under competition, monopoly and other conditions, principles of limited resources allocation.'],
    ['econ', 102, 'Introduction to Macroeconomics', 6, 'This course explores basic economic concepts and processes on regional/national level: national income, depression, inflation, unemployment.'],
    ['econ', 112, 'Quantitative Method in Microeconomics', 3, 'Quantitative methods and problem solving in microeconomics.'],
    ['econ', 205, 'Introduction to Global Economy', 3, 'How the whole economy or its large sectors work, fiscal and monetary policy, role of the national economic within the world economy.'],
    ['econ', 213, 'American Economic History', 3, 'Evolution of American economy including technical and technological changes, demographic and labor aspects.'],
    ['econ', 246, 'Microeconomic Theory', 3, 'In-depth study of producer and consumer theory and list of advanced topics in microeconomics.'],
    ['econ', 278, 'Statistics in Economics', 4, 'Introduction to mathematical statistics: probability theory, distributions, hypothesis testing, regression.'],
    ['econ', 321, 'Banking System', 3, 'Explores structure of the banking system and its role in macroeconomic processes.'],
    ['econ', 339, 'Labor Economics', 3, 'This course examines interrelations between employers and employees, their expectations, study of labor law and analysis of the current US labor market.'],
    ['econ', 352, 'History of Economic Thought', 3, 'Ideas and theories of most significant economic thinkers, their role in building contemporary economic system.'],
    ['econ', 370, 'Game Theory', 3, 'Study of the game theory giving abstract modelling of strategic situations and its application to real games and economic situations. Main objective of the course is development of students strategic thinking.'],
    ['econ', 412, 'International Financial Markets', 3, 'Offers an understanding of the international financial structure and studies its impact on business and individuals in various nations.'],
    ['econ', 430, 'Econometrics', 4, 'Mathematical modelling of economic processes, use of the models for analysis and forecasting.'],
    ['econ', 452, 'Government Finance', 3, 'This course examines role of the government in the economic system, methods of administrative regulation, analysis of US government activities and policies.'],
    ['econ', 489, 'Special Topics in Economics', 3, 'Seminar on special topics in economics by choice. This course may be taken repeatedly.'],

    ['acc', 100, 'Practical Bookkeeping', 2, null],
    ['acc', 200, 'Introduction to Accounting', 3, 'The initial course in the theory and practice of financial accounting. Topics emphasized include the preparation, reporting, and analysis of financial data.'],
    ['acc', 234, 'Accounting Information Systems', 3, 'This course bridges the gap between two disciplines critical to business operations. This course of study teaches students to design and deploy information technology to improve the accounting systems of an organization.'],
    ['acc', 315, 'Financial Accounting', 5, 'Integration of the conceptual and computational aspects of asset, liability and stockholders equity accounting.'],
    ['acc', 322, 'Managerial Accounting', 3, 'Methods of evaluating accounting information for managers to support business decision making including such topics as cost accounting, lean accounting, RCA, throughput accounting.'],
    ['acc', 420, 'Individual Taxation', 3, 'Concepts and methods of determining federal income taxation applied to individuals.'],
    ['acc', 426, 'Corporate Taxation', 3, 'Concepts and methods of determining federal tax liability of corporations.'],
    ['acc', 431, 'Nonprofit Organization Accounting', 3, 'Aspects of accounting applied to nonprofit organizations including government.'],
    ['acc', 506, 'Corporate Financial Law', 3, 'Law governing business corporations; fiduciary duties of managers and directors in situations such as mergers, acquisitions, securities offerings, market domination, litigation.'],
    ['acc', 511, 'Audit', 5, 'This course considers legal, procedural and ethical aspects of audit in accounting.'],
    ['acc', 527, 'Advanced Accounting', 3, 'Theory and practical applications of accounting for consolidated entities and partnerships; includes foreign currency transactions, hedging and derivatives.'],
    ['acc', 620, 'Accounting Internship', 6, 'Supervised internship in a business or nonprofit organization on an accounting position.'],

    ['mm', 256, 'Principles of Marketing', 3, 'Introduction to market concepts, historical evolution of marketing, variety of contemporary approaches, customer-oriented policy.'],
    ['mm', 304, 'Managerial Economics I', 3, 'Application of micro- and macroeconomic principles to decision making in business, basic analytical techniques.'],
    ['mm', 305, 'Managerial Economics II', 3, 'Second semester of Managerial Economics course giving students advanced analytical techniques using linear programming, calculus and game theory.'],
    ['mm', 318, 'Marketing Research', 3, 'Study of market research process as a part of business decision making; marketing environment, market segmentation, statistical methods overview.'],
    ['mm', 331, 'Marketing Planning', 4, 'Theory of consumer behavior in marketing perspective, marketing strategy and its dependency to the overall business strategy, marketing specializations.'],
    ['mm', 355, 'Human Resource Management', 5, 'Theory and practices in human resources management; topics include workforce planning, recruitment, skill management, training and development, time management and others.'],
    ['mm', 401, 'Competitive Strategy', 3, 'Strategies and practices of business development within a competitive industry from a resource-based view perspective.'],
    ['mm', 404, 'Corporate Financial Management', 3, 'This course covers advanced topics in corporate financial management, including its role in corporate governance.'],
    ['mm', 430, 'Promotion', 5, 'Role of promotion in theoretical and practical perspective, promotional plan with emphasis on sales promotion, personal selling and public relations.'],
    ['mm', 434, 'Advertising', 3, 'Comprehensive study of advertising, its issues and practices, effective advertising performance, advertising management and budgeting.'],
    ['mm', 520, 'Project Management', 4, 'Basic principles and various approaches of effective project management; topics include project definition, scheduling, risk planning, resource allocation, performance management, project tracking.'],
    ['mm', 531, 'International Business', 3, 'This course explores issues of companies with international scope based on experience of real companies, political, economic and social aspects of multinational management.'],
    ['mm', 601, 'Case Studies in Corporate Finance', 3, 'A course designed to use case studies and financial analysis to further knowledge and ability to make financial management decisions.'],
    ['mm', 650, 'International Marketing', 3, 'Survey of marketing in the global environment, specifics of satisfying global customer needs, strategies of world-wide promotion.'],
    ['mm', 756, 'Capital Risk Management', 3, 'Introduces fundamental principles and techniques of financial risk management.'],
    ['mm', 808, 'Principles of Portfolio Management', 3, 'Comprehensive coverage of the theory and practice of money management as well as in-depth analysis of the theory and practice involved when securities are combined into portfolios.'],
    ['mm', 818, 'Financial Statement Analysis', 3, 'This course presents techniques for analyzing current and projected financial statements for the purposes of credit analysis, security analysis, and internal financial analysis, and cash flow forecasting.'],
  ]

- table: cd.semester
  columns: [year, season, begin_date, end_date]
  data: [
    [2007, 'spring', '2008-01-01', '2008-05-15'],
    [2008, 'spring', '2009-01-01', '2009-05-15'],
    [2009, 'spring', '2010-01-01', '2010-05-15'],
    [2010, 'spring', '2011-01-01', '2011-05-15'],
    [2011, 'spring', '2012-01-01', '2012-05-15'],
    [2012, 'spring', '2013-01-01', '2013-05-15'],
    [2007, 'fall', '2007-08-15', '2007-12-31'],
    [2008, 'fall', '2008-08-15', '2008-12-31'],
    [2009, 'fall', '2009-08-15', '2009-12-31'],
    [2010, 'fall', '2010-08-15', '2010-12-31'],
    [2011, 'fall', '2011-08-15', '2011-12-31'],
    [2012, 'fall', '2012-08-15', '2012-12-31'],
    [2007, 'summer', '2008-06-01', '2008-08-01'],
    [2008, 'summer', '2009-06-01', '2009-08-01'],
    [2009, 'summer', '2010-06-01', '2010-08-01'],
    [2010, 'summer', '2011-06-01', '2011-08-01'],
    [2011, 'summer', '2012-06-01', '2012-08-01'],
    [2012, 'summer', '2013-06-01', '2013-08-01'],
  ]

- table: rd.prerequisite
  columns: [of_department_code, of_course_no, on_department_code, on_course_no]
  data: [
    ['astro', 106, 'astro', 105],
    ['astro', 210, 'astro', 105],
    ['astro', 211, 'astro', 210],
    ['astro', 215, 'phys', 130],
    ['astro', 215, 'astro', 105],
    ['astro', 223, 'phys', 130],
    ['astro', 223, 'astro', 105],
    ['astro', 230, 'phys', 130],
    ['astro', 230, 'astro', 105],
    ['astro', 241, 'astro', 230],
    ['astro', 315, 'astro', 223],
    ['astro', 320, 'astro', 223],
    ['astro', 320, 'phys', 350],
    ['astro', 328, 'astro', 230],
    ['astro', 328, 'phys', 130],
    ['astro', 329, 'astro', 328],
    ['astro', 340, 'astro', 105],
    ['astro', 340, 'astro', 110],
    ['astro', 345, 'astro', 223],
    ['astro', 410, 'astro', 315],
    ['astro', 411, 'astro', 410],
    ['astro', 418, 'astro', 223],
    ['astro', 432, 'astro', 223],
    ['astro', 432, 'mth', 121],
    ['astro', 432, 'comp', 102],
    ['astro', 433, 'astro', 432],

    ['chem', 111, 'chem', 110],
    ['chem', 120, 'chem', 110],
    ['chem', 121, 'chem', 120],
    ['chem', 200, 'chem', 110],
    ['chem', 201, 'chem', 200],
    ['chem', 210, 'chem', 200],
    ['chem', 211, 'chem', 210],
    ['chem', 220, 'chem', 110],
    ['chem', 220, 'phys', 124],
    ['chem', 221, 'chem', 220],
    ['chem', 300, 'chem', 200],
    ['chem', 301, 'chem', 300],
    ['chem', 314, 'chem', 120],
    ['chem', 316, 'chem', 120],
    ['chem', 320, 'chem', 120],
    ['chem', 320, 'comp', 102],
    ['chem', 321, 'chem', 320],
    ['chem', 655, 'chem', 300],

    ['phys', 109, 'phys', 108],
    ['phys', 122, 'phys', 121],
    ['phys', 125, 'phys', 124],
    ['phys', 129, 'phys', 128],
    ['phys', 131, 'phys', 130],
    ['phys', 201, 'phys', 130],
    ['phys', 201, 'mth', 121],
    ['phys', 203, 'phys', 201],
    ['phys', 221, 'phys', 130],
    ['phys', 222, 'phys', 221],
    ['phys', 288, 'phys', 130],
    ['phys', 289, 'phys', 288],
    ['phys', 350, 'phys', 130],
    ['phys', 366, 'phys', 130],
    ['phys', 366, 'mth', 122],
    ['phys', 366, 'comp', 102],
    ['phys', 407, 'phys', 130],
    ['phys', 435, 'phys', 407],
    ['phys', 512, 'phys', 435],
    ['phys', 713, 'phys', 350],
    ['phys', 819, 'phys', 435],

    ['mth', 102, 'mth', 101],
    ['mth', 120, 'mth', 102],
    ['mth', 121, 'mth', 120],
    ['mth', 122, 'mth', 121],
    ['mth', 211, 'mth', 121],
    ['mth', 228, 'mth', 120],
    ['mth', 230, 'mth', 120],
    ['mth', 253, 'mth', 122],
    ['mth', 315, 'mth', 230],
    ['mth', 318, 'mth', 211],

    ['eng', 156, 'eng', 155],
    ['eng', 212, 'eng', 211],

    ['lang', 140, 'lang', 105],
    ['lang', 202, 'lang', 105],
    ['lang', 204, 'lang', 105],
    ['lang', 221, 'lang', 121],
    ['lang', 222, 'lang', 122],
    ['lang', 223, 'lang', 123],
    ['lang', 304, 'lang', 221],
    ['lang', 305, 'lang', 105],
    ['lang', 321, 'lang', 221],
    ['lang', 322, 'lang', 222],
    ['lang', 323, 'lang', 223],
    ['lang', 345, 'lang', 105],
    ['lang', 345, 'lang', 108],
    ['lang', 437, 'lang', 345],
    ['lang', 438, 'lang', 305],
    ['lang', 438, 'lang', 345],

    ['hist', 121, 'hist', 120],
    ['hist', 122, 'hist', 121],
    ['hist', 240, 'hist', 121],
    ['hist', 256, 'hist', 120],
    ['hist', 329, 'hist', 121],
    ['hist', 435, 'hist', 434],
    ['hist', 519, 'hist', 434],

    ['psych', 220, 'psych', 102],
    ['psych', 225, 'psych', 220],
    ['psych', 226, 'psych', 225],
    ['psych', 231, 'psych', 102],
    ['psych', 304, 'psych', 102],
    ['psych', 305, 'psych', 304],
    ['psych', 339, 'psych', 102],
    ['psych', 340, 'psych', 339],
    ['psych', 345, 'psych', 225],
    ['psych', 350, 'psych', 345],
    ['psych', 351, 'psych', 350],
    ['psych', 450, 'psych', 225],
    ['psych', 560, 'psych', 304],
    ['psych', 610, 'psych', 304],
    ['psych', 610, 'psych', 339],

    ['poli', 134, 'poli', 113],
    ['poli', 177, 'poli', 176],
    ['poli', 224, 'poli', 223],
    ['poli', 320, 'poli', 243],
    ['poli', 347, 'poli', 243],
    ['poli', 392, 'poli', 380],
    ['poli', 402, 'poli', 113],
    ['poli', 644, 'poli', 243],
    ['poli', 715, 'poli', 243],

    ['comp', 151, 'comp', 150],
    ['comp', 167, 'comp', 166],
    ['comp', 206, 'comp', 166],
    ['comp', 206, 'comp', 102],
    ['comp', 207, 'comp', 167],
    ['comp', 207, 'comp', 206],
    ['comp', 215, 'comp', 102],
    ['comp', 216, 'comp', 215],
    ['comp', 228, 'comp', 102],
    ['comp', 304, 'comp', 167],
    ['comp', 305, 'comp', 304],
    ['comp', 314, 'comp', 102],
    ['comp', 350, 'comp', 102],
    ['comp', 415, 'comp', 102],
    ['comp', 437, 'comp', 102],
    ['comp', 515, 'comp', 150],
    ['comp', 819, 'comp', 166],
    ['comp', 819, 'comp', 207],

    ['ee', 202, 'ee', 107],
    ['ee', 202, 'phys', 128],
    ['ee', 220, 'ee', 107],
    ['ee', 220, 'phys', 128],
    ['ee', 221, 'ee', 220],
    ['ee', 228, 'ee', 107],
    ['ee', 228, 'phys', 128],
    ['ee', 251, 'ee', 107],
    ['ee', 251, 'mth', 122],
    ['ee', 251, 'mth', 211],
    ['ee', 251, 'mth', 230],
    ['ee', 315, 'mth', 228],
    ['ee', 319, 'ee', 107],
    ['ee', 329, 'ee', 107],
    ['ee', 329, 'phys', 130],
    ['ee', 412, 'ee', 315],
    ['ee', 412, 'ee', 329],
    ['ee', 436, 'ee', 228],
    ['ee', 437, 'ee', 436],
    ['ee', 505, 'ee', 220],
    ['ee', 615, 'ee', 505],
    ['ee', 615, 'ee', 251],

    ['me', 141, 'me', 111],
    ['me', 141, 'phys', 124],
    ['me', 142, 'me', 141],
    ['me', 143, 'me', 142],
    ['me', 201, 'me', 111],
    ['me', 201, 'phys', 124],
    ['me', 201, 'mth', 121],
    ['me', 202, 'me', 201],
    ['me', 202, 'comp', 102],
    ['me', 221, 'me', 111],
    ['me', 221, 'phys', 124],
    ['me', 222, 'me', 221],
    ['me', 231, 'me', 221],
    ['me', 232, 'me', 231],
    ['me', 315, 'mth', 121],
    ['me', 331, 'me', 142],
    ['me', 331, 'me', 201],
    ['me', 332, 'me', 331],
    ['me', 344, 'me', 331],
    ['me', 420, 'me', 331],
    ['me', 437, 'me', 201],
    ['me', 437, 'mth', 318],
    ['me', 501, 'me', 111],
    ['me', 627, 'me', 111],
    ['me', 712, 'me', 331],

    ['be', 108, 'chem', 200],
    ['be', 136, 'be', 108],
    ['be', 162, 'be', 108],
    ['be', 228, 'be', 108],
    ['be', 228, 'phys', 121],
    ['be', 229, 'be', 228],
    ['be', 230, 'be', 108],
    ['be', 230, 'phys', 124],
    ['be', 241, 'be', 136],
    ['be', 272, 'be', 230],
    ['be', 272, 'mth', 122],
    ['be', 310, 'be', 241],
    ['be', 345, 'be', 162],
    ['be', 356, 'be', 136],
    ['be', 356, 'be', 241],
    ['be', 387, 'be', 228],
    ['be', 509, 'be', 356],

    ['arthis', 103, 'arthis', 102],
    ['arthis', 209, 'arthis', 102],
    ['arthis', 210, 'arthis', 102],
    ['arthis', 231, 'arthis', 102],
    ['arthis', 318, 'arthis', 103],
    ['arthis', 325, 'arthis', 103],
    ['arthis', 354, 'arthis', 103],
    ['arthis', 436, 'arthis', 103],
    ['arthis', 439, 'arthis', 436],

    ['stdart', 106, 'stdart', 101],
    ['stdart', 206, 'stdart', 106],
    ['stdart', 218, 'stdart', 106],
    ['stdart', 230, 'stdart', 130],
    ['stdart', 235, 'stdart', 106],
    ['stdart', 251, 'stdart', 106],
    ['stdart', 272, 'stdart', 106],
    ['stdart', 309, 'stdart', 206],
    ['stdart', 352, 'stdart', 251],
    ['stdart', 370, 'stdart', 272],
    ['stdart', 453, 'stdart', 235],
    ['stdart', 509, 'stdart', 370],
    ['stdart', 614, 'stdart', 309],

    ['tched', 155, 'tched', 122],
    ['tched', 179, 'tched', 122],
    ['tched', 211, 'tched', 110],
    ['tched', 401, 'tched', 208],
    ['tched', 430, 'tched', 110],
    ['tched', 430, 'tched', 208],
    ['tched', 435, 'tched', 110],
    ['tched', 435, 'tched', 208],
    ['tched', 440, 'tched', 110],
    ['tched', 440, 'tched', 208],
    ['tched', 509, 'tched', 110],
    ['tched', 509, 'tched', 208],
    ['tched', 510, 'tched', 122],
    ['tched', 630, 'tched', 430],
    ['tched', 635, 'tched', 435],
    ['tched', 640, 'tched', 440],

    ['edpol', 202, 'edpol', 102],
    ['edpol', 213, 'edpol', 202],
    ['edpol', 229, 'edpol', 102],
    ['edpol', 231, 'edpol', 102],
    ['edpol', 236, 'edpol', 229],
    ['edpol', 236, 'edpol', 231],
    ['edpol', 301, 'edpol', 131],
    ['edpol', 316, 'edpol', 236],
    ['edpol', 337, 'edpol', 102],
    ['edpol', 337, 'edpol', 117],
    ['edpol', 351, 'edpol', 236],
    ['edpol', 413, 'edpol', 236],
    ['edpol', 431, 'edpol', 236],
    ['edpol', 432, 'edpol', 236],
    ['edpol', 505, 'edpol', 236],

    ['econ', 101, 'mth', 102],
    ['econ', 102, 'econ', 101],
    ['econ', 102, 'mth', 102],
    ['econ', 112, 'econ', 101],
    ['econ', 205, 'econ', 102],
    ['econ', 213, 'econ', 102],
    ['econ', 246, 'econ', 102],
    ['econ', 278, 'mth', 102],
    ['econ', 321, 'econ', 102],
    ['econ', 339, 'econ', 102],
    ['econ', 370, 'econ', 278],
    ['econ', 412, 'econ', 205],
    ['econ', 430, 'econ', 112],
    ['econ', 430, 'econ', 278],
    ['econ', 452, 'econ', 321],

    ['acc', 200, 'mth', 102],
    ['acc', 234, 'acc', 200],
    ['acc', 234, 'comp', 102],
    ['acc', 315, 'acc', 200],
    ['acc', 322, 'acc', 315],
    ['acc', 420, 'acc', 315],
    ['acc', 426, 'acc', 315],
    ['acc', 431, 'acc', 315],
    ['acc', 506, 'acc', 315],
    ['acc', 511, 'acc', 426],
    ['acc', 511, 'acc', 506],
    ['acc', 527, 'acc', 322],
    ['acc', 620, 'acc', 426],
    ['acc', 620, 'acc', 431],

    ['mm', 256, 'econ', 101],
    ['mm', 304, 'econ', 101],
    ['mm', 304, 'econ', 102],
    ['mm', 305, 'mm', 304],
    ['mm', 305, 'econ', 370],
    ['mm', 318, 'mm', 256],
    ['mm', 331, 'mm', 256],
    ['mm', 331, 'mm', 304],
    ['mm', 355, 'mm', 304],
    ['mm', 401, 'mm', 256],
    ['mm', 404, 'mm', 304],
    ['mm', 430, 'mm', 256],
    ['mm', 434, 'mm', 430],
    ['mm', 520, 'mm', 304],
    ['mm', 531, 'mm', 304],
    ['mm', 601, 'mm', 404],
    ['mm', 650, 'mm', 430],
    ['mm', 756, 'mm', 404],
    ['mm', 808, 'mm', 305],
    ['mm', 808, 'mm', 404],
    ['mm', 818, 'mm', 305],
    ['mm', 818, 'mm', 404],
  ]

- table: rd.classification
  columns: [code, type, title, description, part_of_code]
  data: [
    ['cross', null, 'Cross-Cutting Requirements', null, null],
      ['writing', 'university', 'Writing Intensive', 'Writing intensive courses involve 3 or more papers per semester; at least one of which is a research paper of 20 pages or more.', 'cross'],
      ['reasoning', 'university', 'Quantitative Reasoning', 'Quantitative resoning courses focus on numerical analysis to evaluate, describe and justify outcomes of complex decisions.', 'cross'],
      ['diversity', 'university', 'Region and Ethnic Diversity', 'Courses which provide a rich exposure to foreign cultures and regions qualify for this classification.', 'cross'],
      ['research', 'university', 'Research Experience', 'Research courses focus on the scientific method to create hypothesis and test them in a structured laboratory environment.', 'cross'],
    ['humanities', 'university', 'Arts, Letters, and the Humanities', null, null],
      ['arthistory', 'school', 'Art', null, 'humanities'],
        ['euroart', 'department', 'European Art', null, 'arthistory'],
        ['worldart', 'department', 'World Art', null, 'arthistory'],
        ['modernart', 'department', 'Modern Art', null, 'arthistory'],
      ['literature', 'school', 'English and World Literature', null, 'humanities'],
        ['worldlit', 'department', 'World Literature', null, 'literature'],
        ['englit', 'department', 'English Language Literature', null, 'literature'],
        ['nonfiction', 'department', 'Non Fiction Writing', null, 'literature'],
        ['journalism', 'department', 'Journalistic Writing', null, 'literature'],
        ['fiction', 'department', 'Fiction Writing', null, 'literature'],
        ['poetry', 'department', 'Poetry Writing', null, 'literature'],
      ['history', 'school', 'American and World History', null, 'humanities'],
        ['histmethod', 'department', 'Historical Method', null, 'history'],
        ['amhistory', 'department', 'American History', null, 'history'],
        ['westernhist', 'department', 'History of Western Civilization', null, 'history'],
        ['nonwesternhist', 'department', 'Non Western History', null, 'history'],
        ['dischistory', 'department', 'Interdisciplinary History', null, 'history'],
      ['language', 'school', 'World Languages', null, 'humanities'],
        ['modlanguage', 'department', 'Modern Languages', null, 'language'],
          ['french', 'department', 'French', null, 'modlanguage'],
          ['german', 'department', 'German', null, 'modlanguage'],
          ['spanish', 'department', 'Spanish', null, 'modlanguage'],
        ['anclanguage', 'department', 'Ancient Languages', null, 'language'],
        ['linguistics', 'department', 'Linguistics', null, 'language'],
      ['polisci', 'school', 'Political Science', null, 'humanities'],
        ['ampolitics', 'department', 'American Politics', null, 'polisci'],
        ['worldpol', 'department', 'World Politics', null, 'polisci'],
        ['intrelations', 'department', 'International Relations', null, 'polisci'],
        ['poliecon', 'department', 'Political Economy', null, 'polisci'],
      ['psychology', 'school', 'Psychology', null, 'humanities'],
        ['genpsych', 'department', 'Generic Psychology', null, 'psychology'],
        ['biopsych', 'department', 'Biological Psychology', null, 'psychology'],
        ['socpsych', 'department', 'Social Psychology', null, 'psychology'],
        ['abnormpsych', 'department', 'Abnormal Psychology', null, 'psychology'],
    ['science', 'university', 'Natural Sciences', null, null],
      ['astronomy', 'school', 'Astronomy', null, 'science'],
        ['astrotheory', 'department', 'Astrophysics Theory', null, 'astronomy'],
        ['astrolab', 'department', 'Astronomy Laboratory', null, 'astronomy'],
        ['observation', 'department', 'Observing Skills', null, 'astronomy'],
      ['chemistry', 'school', 'Chemistry', null, 'science'],
        ['chemtheory', 'department', 'Theoretical Chemistry', null, 'chemistry'],
        ['chemlab', 'department', 'Chemistry Laboratory', null, 'chemistry'],
      ['physics', 'school', 'Physics', null, 'science'],
        ['phystheory', 'department', 'Theoretical Physics', null, 'physics'],
        ['physlab', 'department', 'Practical Physics', null, 'physics'],
      ['math', 'school', 'Mathematics', null, 'science'],
        ['analysis', 'department', 'Mathematical Analysis', null, 'math'],
        ['algebra', 'department', 'Algebra', null, 'math'],
        ['statistics', 'department', 'Probability and Statistics', null, 'math'],
        ['geometry', 'department', 'Geometry', null, 'math'],
    ['artdesign', 'university', 'Art and Design', null, null],
      ['visual', 'school', 'Visual Art', null, 'artdesign'],
        ['arttheory', 'department', 'Visual Art Theory', null, 'visual'],
        ['drawing', 'department', 'Drawing', null, 'visual'],
        ['painting', 'department', 'Painting', null, 'visual'],
        ['printmaking', 'department', 'Printmaking', null, 'visual'],
        ['craft', 'department', 'Arts and Crafts', null, 'visual'],
        ['photography', 'department', 'Photography', null, 'visual'],
      ['industrial', 'school', 'Industrial Design', null, 'artdesign'],
      ['digital', 'school', 'Digital Media', null, 'artdesign'],
      ['society', 'school', 'Art and Society', null, 'artdesign'],
    ['engineering', 'university', 'Engineering', null, null],
      ['compsci', 'school', 'Computer Science', null, 'engineering'],
        ['comptheory', 'department', 'Computationial Theory', null, 'compsci'],
        ['comporg', 'department', 'Computer Organization', null, 'compsci'],
        ['softdev', 'department', 'Software Development', null, 'compsci'],
      ['ee', 'school', 'Electrical Engineering', null, 'engineering'],
        ['eetheory', 'department', 'Electrical Engineering Theory', null, 'ee'],
        ['eelab', 'department', 'Electrical Engineering Laboratory', null, 'ee'],
      ['me', 'school', 'Mechanical Engineering', null, 'engineering'],
        ['memechanics', 'department', 'Mechanics', null, 'me'],
        ['melab', 'department', 'Mechanical Engineering Laboratory', null, 'me'],
        ['medesign', 'department', 'Design and Manufacturing', null, 'me'],
        ['mesystems', 'department', 'Systems and Controls', null, 'me'],
      ['be', 'school', 'Biological Engineering', null, 'engineering'],
        ['bioprocess', 'department', 'Biological Processes', null, 'be'],
        ['bmeng', 'department', 'Biomedical Engineering', null, 'be'],
        ['belab', 'department', 'Bioengineering Practice', null, 'be'],
    ['education', 'university', 'Education', null, null],
      ['teached', 'school', 'Teacher Education', null, 'education'],
        ['pedagogy', 'department', 'Pedagogy', null, 'teached'],
        ['tmethods', 'department', 'Teaching Methods', null, 'teached'],
        ['earlyed', 'department', 'Early Education', null, 'teached'],
      ['edpol', 'school', 'Educational Policy', null, 'education'],
        ['edstudies', 'department', 'Policy Studies', null, 'edpol'],
        ['edresearch', 'department', 'Educational Research', null, 'edpol'],
    ['business', 'university', 'Business', null, null],
      ['econ', 'school', 'Economics', null, 'business'],
        ['mathecon', 'department', 'Mathematical Economy', null, 'econ'],
        ['microecon', 'department', 'Microeconomics', null, 'econ'],
        ['macroecon', 'department', 'Macroeconomics', null, 'econ'],
        ['interecon', 'department', 'International Economics', null, 'econ'],
      ['finance', 'school', 'Finance', null, 'business'],
      ['accounting', 'school', 'Accounting', null, 'business'],
      ['management', 'school', 'Management', null, 'business'],
      ['marketing', 'school', 'Marketing', null, 'business'],
    ['remedial', 'university', 'Remedial Courses', 'Classes for which credit is not typically given for degree programs in the same school; e.g.  College Algebra courses do not earn credit for those in the School of Natural Science.', null],
  ]

- table: rd.course_classification
  columns: [department_code, course_no, classification_code]
  data: [
    ['astro', 105, 'astrotheory'],
    ['astro', 106, 'astrolab'],
    ['astro', 108, 'astrotheory'],
    ['astro', 110, 'astrotheory'],
    ['astro', 122, 'astrotheory'],
    ['astro', 210, 'astrotheory'],
    ['astro', 211, 'astrolab'],
    ['astro', 215, 'astrotheory'],
    ['astro', 223, 'astrotheory'],
    ['astro', 230, 'observation'],
    ['astro', 241, 'observation'],
    ['astro', 315, 'astrotheory'],
    ['astro', 320, 'astrotheory'],
    ['astro', 328, 'observation'],
    ['astro', 329, 'observation'],
    ['astro', 340, 'astronomy'],
    ['astro', 345, 'astrotheory'],
    ['astro', 410, 'astrotheory'],
    ['astro', 411, 'astrolab'],
    ['astro', 411, 'reasoning'],
    ['astro', 418, 'astrotheory'],
    ['astro', 432, 'astrotheory'],
    ['astro', 432, 'comptheory'],
    ['astro', 433, 'astrolab'],
    ['astro', 433, 'reasoning'],

    ['chem', 100, 'chemtheory'],
    ['chem', 110, 'chemtheory'],
    ['chem', 111, 'chemlab'],
    ['chem', 120, 'chemtheory'],
    ['chem', 121, 'chemlab'],
    ['chem', 200, 'chemtheory'],
    ['chem', 201, 'chemlab'],
    ['chem', 210, 'chemtheory'],
    ['chem', 211, 'chemlab'],
    ['chem', 220, 'chemtheory'],
    ['chem', 221, 'chemlab'],
    ['chem', 300, 'chemtheory'],
    ['chem', 301, 'chemlab'],
    ['chem', 314, 'chemlab'],
    ['chem', 314, 'research'],
    ['chem', 316, 'chemtheory'],
    ['chem', 320, 'chemtheory'],
    ['chem', 320, 'comptheory'],
    ['chem', 321, 'chemlab'],
    ['chem', 321, 'reasoning'],
    ['chem', 655, 'chemtheory'],

    ['phys', 108, 'remedial'],
    ['phys', 108, 'phystheory'],
    ['phys', 109, 'remedial'],
    ['phys', 121, 'phystheory'],
    ['phys', 122, 'physlab'],
    ['phys', 124, 'phystheory'],
    ['phys', 125, 'physlab'],
    ['phys', 128, 'phystheory'],
    ['phys', 129, 'physlab'],
    ['phys', 130, 'phystheory'],
    ['phys', 131, 'physlab'],
    ['phys', 201, 'phystheory'],
    ['phys', 203, 'phystheory'],
    ['phys', 221, 'phystheory'],
    ['phys', 222, 'physlab'],
    ['phys', 288, 'physlab'],
    ['phys', 288, 'research'],
    ['phys', 289, 'physlab'],
    ['phys', 289, 'research'],
    ['phys', 350, 'phystheory'],
    ['phys', 366, 'phystheory'],
    ['phys', 366, 'reasoning'],
    ['phys', 407, 'phystheory'],
    ['phys', 435, 'phystheory'],
    ['phys', 512, 'phystheory'],
    ['phys', 713, 'phystheory'],
    ['phys', 819, 'phystheory'],

    ['mth', 101, 'remedial'],
    ['mth', 101, 'reasoning'],
    ['mth', 101, 'math'],
    ['mth', 102, 'remedial'],
    ['mth', 102, 'reasoning'],
    ['mth', 102, 'math'],
    ['mth', 120, 'analysis'],
    ['mth', 121, 'analysis'],
    ['mth', 122, 'analysis'],
    ['mth', 211, 'algebra'],
    ['mth', 228, 'statistics'],
    ['mth', 230, 'analysis'],
    ['mth', 253, 'geometry'],
    ['mth', 315, 'analysis'],
    ['mth', 318, 'algebra'],

    ['eng', 101, 'worldlit'],
    ['eng', 102, 'worldlit'],
    ['eng', 105, 'worldlit'],
    ['eng', 105, 'diversity'],
    ['eng', 106, 'worldlit'],
    ['eng', 106, 'diversity'],
    ['eng', 155, 'englit'],
    ['eng', 156, 'englit'],
    ['eng', 175, 'journalism'],
    ['eng', 175, 'writing'],
    ['eng', 206, 'englit'],
    ['eng', 211, 'nonfiction'],
    ['eng', 211, 'writing'],
    ['eng', 212, 'nonfiction'],
    ['eng', 212, 'writing'],
    ['eng', 222, 'linguistics'],
    ['eng', 247, 'worldlit'],
    ['eng', 247, 'diversity'],
    ['eng', 250, 'englit'],
    ['eng', 276, 'nonfiction'],
    ['eng', 276, 'writing'],
    ['eng', 306, 'englit'],
    ['eng', 321, 'worldlit'],
    ['eng', 321, 'reasoning'],
    ['eng', 324, 'journalism'],
    ['eng', 326, 'fiction'],
    ['eng', 330, 'fiction'],
    ['eng', 412, 'nonfiction'],
    ['eng', 412, 'writing'],
    ['eng', 428, 'poetry'],

    ['lang', 105, 'linguistics'],
    ['lang', 108, 'linguistics'],
    ['lang', 121, 'spanish'],
    ['lang', 122, 'french'],
    ['lang', 123, 'german'],
    ['lang', 140, 'linguistics'],
    ['lang', 140, 'diversity'],
    ['lang', 202, 'linguistics'],
    ['lang', 204, 'linguistics'],
    ['lang', 221, 'spanish'],
    ['lang', 222, 'french'],
    ['lang', 223, 'german'],
    ['lang', 304, 'spanish'],
    ['lang', 305, 'linguistics'],
    ['lang', 321, 'spanish'],
    ['lang', 322, 'french'],
    ['lang', 323, 'german'],
    ['lang', 345, 'linguistics'],
    ['lang', 426, 'anclanguage'],
    ['lang', 426, 'diversity'],
    ['lang', 427, 'anclanguage'],
    ['lang', 427, 'diversity'],
    ['lang', 437, 'linguistics'],
    ['lang', 437, 'earlyed'],
    ['lang', 438, 'linguistics'],
    ['lang', 438, 'earlyed'],

    ['hist', 112, 'amhistory'],
    ['hist', 120, 'westernhist'],
    ['hist', 120, 'diversity'],
    ['hist', 121, 'westernhist'],
    ['hist', 121, 'diversity'],
    ['hist', 122, 'westernhist'],
    ['hist', 122, 'diversity'],
    ['hist', 212, 'dischistory'],
    ['hist', 220, 'nonwesternhist'],
    ['hist', 220, 'diversity'],
    ['hist', 238, 'nonwesternhist'],
    ['hist', 238, 'diversity'],
    ['hist', 240, 'westernhist'],
    ['hist', 240, 'diversity'],
    ['hist', 256, 'westernhist'],
    ['hist', 256, 'diversity'],
    ['hist', 329, 'westernhist'],
    ['hist', 329, 'diversity'],
    ['hist', 333, 'amhistory'],
    ['hist', 358, 'amhistory'],
    ['hist', 415, 'dischistory'],
    ['hist', 434, 'histmethod'],
    ['hist', 434, 'research'],
    ['hist', 434, 'reasoning'],
    ['hist', 435, 'histmethod'],
    ['hist', 435, 'research'],
    ['hist', 505, 'dischistory'],
    ['hist', 505, 'histmethod'],
    ['hist', 519, 'histmethod'],
    ['hist', 519, 'research'],
    ['hist', 519, 'diversity'],

    ['psych', 102, 'genpsych'],
    ['psych', 121, 'genpsych'],
    ['psych', 121, 'reasoning'],
    ['psych', 122, 'genpsych'],
    ['psych', 122, 'reasoning'],
    ['psych', 220, 'biopsych'],
    ['psych', 225, 'biopsych'],
    ['psych', 226, 'biopsych'],
    ['psych', 226, 'research'],
    ['psych', 226, 'reasoning'],
    ['psych', 231, 'genpsych'],
    ['psych', 304, 'genpsych'],
    ['psych', 305, 'genpsych'],
    ['psych', 305, 'research'],
    ['psych', 305, 'reasoning'],
    ['psych', 339, 'socpsych'],
    ['psych', 340, 'socpsych'],
    ['psych', 340, 'research'],
    ['psych', 340, 'reasoning'],
    ['psych', 345, 'abnormpsych'],
    ['psych', 350, 'abnormpsych'],
    ['psych', 351, 'abnormpsych'],
    ['psych', 450, 'abnormpsych'],
    ['psych', 560, 'genpsych'],
    ['psych', 560, 'research'],
    ['psych', 610, 'genpsych'],
    ['psych', 610, 'abnormpsych'],

    ['poli', 113, 'ampolitics'],
    ['poli', 129, 'ampolitics'],
    ['poli', 129, 'worldpol'],
    ['poli', 134, 'ampolitics'],
    ['poli', 150, 'worldpol'],
    ['poli', 150, 'diversity'],
    ['poli', 176, 'worldpol'],
    ['poli', 176, 'diversity'],
    ['poli', 177, 'worldpol'],
    ['poli', 177, 'diversity'],
    ['poli', 223, 'worldpol'],
    ['poli', 223, 'diversity'],
    ['poli', 224, 'worldpol'],
    ['poli', 224, 'diversity'],
    ['poli', 243, 'intrelations'],
    ['poli', 251, 'worldpol'],
    ['poli', 320, 'intrelations'],
    ['poli', 347, 'ampolitics'],
    ['poli', 347, 'intrelations'],
    ['poli', 354, 'poliecon'],
    ['poli', 380, 'ampolitics'],
    ['poli', 392, 'ampolitics'],
    ['poli', 402, 'ampolitics'],
    ['poli', 431, 'ampolitics'],
    ['poli', 644, 'worldpol'],
    ['poli', 644, 'intrelations'],
    ['poli', 644, 'diversity'],
    ['poli', 715, 'worldpol'],
    ['poli', 715, 'intrelations'],
    ['poli', 715, 'diversity'],

    ['comp', 102, 'comporg'],
    ['comp', 102, 'reasoning'],
    ['comp', 130, 'comptheory'],
    ['comp', 150, 'softdev'],
    ['comp', 151, 'softdev'],
    ['comp', 166, 'comptheory'],
    ['comp', 167, 'comptheory'],
    ['comp', 206, 'comptheory'],
    ['comp', 206, 'softdev'],
    ['comp', 206, 'reasoning'],
    ['comp', 207, 'comptheory'],
    ['comp', 207, 'softdev'],
    ['comp', 207, 'reasoning'],
    ['comp', 215, 'comporg'],
    ['comp', 216, 'comporg'],
    ['comp', 228, 'comporg'],
    ['comp', 304, 'comptheory'],
    ['comp', 305, 'comptheory'],
    ['comp', 314, 'comporg'],
    ['comp', 350, 'comporg'],
    ['comp', 415, 'comptheory'],
    ['comp', 437, 'comptheory'],
    ['comp', 515, 'softdev'],
    ['comp', 710, 'comporg'],
    ['comp', 710, 'softdev'],
    ['comp', 710, 'research'],
    ['comp', 810, 'research'],
    ['comp', 810, 'writing'],
    ['comp', 819, 'comptheory'],

    ['ee', 107, 'eetheory'],
    ['ee', 107, 'reasoning'],
    ['ee', 202, 'eetheory'],
    ['ee', 220, 'eetheory'],
    ['ee', 221, 'eelab'],
    ['ee', 228, 'eetheory'],
    ['ee', 251, 'eetheory'],
    ['ee', 251, 'reasoning'],
    ['ee', 315, 'eetheory'],
    ['ee', 319, 'eetheory'],
    ['ee', 329, 'eetheory'],
    ['ee', 412, 'eelab'],
    ['ee', 436, 'eetheory'],
    ['ee', 437, 'eelab'],
    ['ee', 505, 'eetheory'],
    ['ee', 615, 'eetheory'],

    ['me', 111, 'me'],
    ['me', 141, 'memechanics'],
    ['me', 142, 'memechanics'],
    ['me', 143, 'melab'],
    ['me', 201, 'mesystems'],
    ['me', 202, 'melab'],
    ['me', 221, 'memechanics'],
    ['me', 222, 'melab'],
    ['me', 231, 'memechanics'],
    ['me', 232, 'melab'],
    ['me', 315, 'mesystems'],
    ['me', 331, 'medesign'],
    ['me', 332, 'medesign'],
    ['me', 344, 'medesign'],
    ['me', 344, 'research'],
    ['me', 420, 'mesystems'],
    ['me', 437, 'memechanics'],
    ['me', 501, 'mesystems'],
    ['me', 627, 'mesystems'],
    ['me', 712, 'medesign'],

    ['be', 108, 'bioprocess'],
    ['be', 112, 'bmeng'],
    ['be', 136, 'bioprocess'],
    ['be', 162, 'bioprocess'],
    ['be', 173, 'bioprocess'],
    ['be', 228, 'bmeng'],
    ['be', 229, 'bmeng'],
    ['be', 230, 'bioprocess'],
    ['be', 241, 'bioprocess'],
    ['be', 272, 'bioprocess'],
    ['be', 310, 'belab'],
    ['be', 345, 'bioprocess'],
    ['be', 356, 'bioprocess'],
    ['be', 387, 'bmeng'],
    ['be', 415, 'belab'],
    ['be', 437, 'bmeng'],
    ['be', 509, 'bmeng'],

    ['arthis', 102, 'worldart'],
    ['arthis', 102, 'diversity'],
    ['arthis', 103, 'worldart'],
    ['arthis', 103, 'diversity'],
    ['arthis', 204, 'worldart'],
    ['arthis', 209, 'worldart'],
    ['arthis', 209, 'diversity'],
    ['arthis', 210, 'worldart'],
    ['arthis', 210, 'diversity'],
    ['arthis', 224, 'worldart'],
    ['arthis', 224, 'diversity'],
    ['arthis', 231, 'euroart'],
    ['arthis', 231, 'diversity'],
    ['arthis', 315, 'worldart'],
    ['arthis', 315, 'diversity'],
    ['arthis', 318, 'euroart'],
    ['arthis', 318, 'diversity'],
    ['arthis', 325, 'euroart'],
    ['arthis', 325, 'diversity'],
    ['arthis', 354, 'euroart'],
    ['arthis', 436, 'modernart'],
    ['arthis', 439, 'modernart'],
    ['arthis', 476, 'worldart'],
    ['arthis', 476, 'diversity'],
    ['arthis', 540, 'modernart'],
    ['arthis', 552, 'modernart'],
    ['arthis', 623, 'modernart'],
    ['arthis', 710, 'worldart'],
    ['arthis', 710, 'reasoning'],
    ['arthis', 712, 'worldart'],
    ['arthis', 809, 'euroart'],

    ['stdart', 101, 'drawing'],
    ['stdart', 106, 'drawing'],
    ['stdart', 119, 'craft'],
    ['stdart', 130, 'craft'],
    ['stdart', 206, 'drawing'],
    ['stdart', 218, 'arttheory'],
    ['stdart', 230, 'craft'],
    ['stdart', 235, 'painting'],
    ['stdart', 251, 'photography'],
    ['stdart', 272, 'printmaking'],
    ['stdart', 309, 'drawing'],
    ['stdart', 352, 'photography'],
    ['stdart', 370, 'printmaking'],
    ['stdart', 411, 'craft'],
    ['stdart', 453, 'painting'],
    ['stdart', 509, 'printmaking'],
    ['stdart', 512, 'society'],
    ['stdart', 614, 'drawing'],
    ['stdart', 714, 'research'],

    ['tched', 110, 'pedagogy'],
    ['tched', 122, 'earlyed'],
    ['tched', 155, 'earlyed'],
    ['tched', 179, 'earlyed'],
    ['tched', 208, 'pedagogy'],
    ['tched', 211, 'tmethods'],
    ['tched', 256, 'pedagogy'],
    ['tched', 367, 'pedagogy'],
    ['tched', 401, 'pedagogy'],
    ['tched', 430, 'tmethods'],
    ['tched', 435, 'tmethods'],
    ['tched', 440, 'tmethods'],
    ['tched', 500, 'pedagogy'],
    ['tched', 500, 'research'],
    ['tched', 509, 'tmethods'],
    ['tched', 520, 'pedagogy'],
    ['tched', 630, 'tmethods'],
    ['tched', 635, 'tmethods'],
    ['tched', 640, 'tmethods'],

    ['edpol', 102, 'edstudies'],
    ['edpol', 117, 'edstudies'],
    ['edpol', 131, 'edstudies'],
    ['edpol', 131, 'earlyed'],
    ['edpol', 202, 'edstudies'],
    ['edpol', 202, 'tmethods'],
    ['edpol', 213, 'edstudies'],
    ['edpol', 229, 'edstudies'],
    ['edpol', 231, 'edstudies'],
    ['edpol', 236, 'edstudies'],
    ['edpol', 301, 'edstudies'],
    ['edpol', 301, 'earlyed'],
    ['edpol', 316, 'edstudies'],
    ['edpol', 337, 'edstudies'],
    ['edpol', 351, 'edresearch'],
    ['edpol', 413, 'edstudies'],
    ['edpol', 431, 'edresearch'],
    ['edpol', 432, 'edresearch'],
    ['edpol', 505, 'edresearch'],
    ['edpol', 505, 'research'],

    ['econ', 101, 'microecon'],
    ['econ', 102, 'macroecon'],
    ['econ', 112, 'microecon'],
    ['econ', 112, 'reasoning'],
    ['econ', 205, 'interecon'],
    ['econ', 213, 'macroecon'],
    ['econ', 246, 'microecon'],
    ['econ', 278, 'mathecon'],
    ['econ', 278, 'reasoning'],
    ['econ', 321, 'finance'],
    ['econ', 339, 'macroecon'],
    ['econ', 352, 'econ'],
    ['econ', 370, 'mathecon'],
    ['econ', 370, 'management'],
    ['econ', 412, 'interecon'],
    ['econ', 412, 'finance'],
    ['econ', 430, 'mathecon'],
    ['econ', 452, 'macroecon'],
    ['econ', 452, 'finance'],
    ['econ', 489, 'econ'],

    ['acc', 100, 'accounting'],
    ['acc', 100, 'remedial'],
    ['acc', 200, 'accounting'],
    ['acc', 234, 'accounting'],
    ['acc', 234, 'comptheory'],
    ['acc', 315, 'accounting'],
    ['acc', 322, 'accounting'],
    ['acc', 420, 'accounting'],
    ['acc', 426, 'accounting'],
    ['acc', 431, 'accounting'],
    ['acc', 506, 'accounting'],
    ['acc', 511, 'accounting'],
    ['acc', 527, 'accounting'],
    ['acc', 620, 'accounting'],

    ['mm', 256, 'marketing'],
    ['mm', 304, 'management'],
    ['mm', 305, 'management'],
    ['mm', 318, 'marketing'],
    ['mm', 331, 'marketing'],
    ['mm', 355, 'management'],
    ['mm', 401, 'microecon'],
    ['mm', 401, 'marketing'],
    ['mm', 404, 'management'],
    ['mm', 404, 'finance'],
    ['mm', 430, 'marketing'],
    ['mm', 434, 'marketing'],
    ['mm', 520, 'management'],
    ['mm', 531, 'management'],
    ['mm', 601, 'finance'],
    ['mm', 601, 'management'],
    ['mm', 650, 'marketing'],
    ['mm', 756, 'finance'],
    ['mm', 756, 'management'],
    ['mm', 808, 'finance'],
    ['mm', 808, 'management'],
    ['mm', 818, 'finance'],
  ]

- table: rd.program_requirement
  columns: [school_code, program_code, classification_code, credit_hours, rationale]
  data: [
    ['ns', 'uastro', 'math', 12, 'Undergraduate science students will take a minimum of 12 credit hours in mathematics.'],
    ['ns', 'uastro', 'physics', 20, 'Undergraduate astronomy students will take a minimum of 20 credit hours in physics.'],
    ['ns', 'uastro', 'astrotheory', 28, 'Undergraduate astronomy students will take a minimum of 28 credit hours of coursework on astronomy theory.'],
    ['ns', 'uastro', 'astrolab', 8, 'Astronomy students are expected to take a minimum of 8 credit hours in the astronomy laboratory.'],
    ['ns', 'uastro', 'observation', 8, 'Undergraduate astronomy students will take a minimum of 8 credit hours of observational astronomy.'],
    ['ns', 'uastro', 'humanities', 16, 'B.S. candidates in the sciences will take a minimum of 16 credit hours in the humanities.'],
    ['ns', 'uchem', 'math', 12, 'Undergraduate science students will take a minimum of 12 credit hours in mathematics.'],
    ['ns', 'uchem', 'chemtheory', 30, 'Undergraduate chemistry students must satisfy a minimum requirement for chemistry theory.'],
    ['ns', 'uchem', 'physics', 8, 'Undergraduate chemistry students must satisfy a minimum requirement for physics.'],
    ['ns', 'uchem', 'chemlab', 16, 'Undergraduate chemistry students must satisfy a minimum requirement for chemistry labwork.'],
    ['ns', 'uchem', 'research', 8, 'B.S. candidates in the sciences will take a minimum of 8 credit hours in research techniques.'],
    ['ns', 'uchem', 'humanities', 16, 'B.S. candidates in the sciences will take a minimum of 16 credit hours in the humanities.'],
    ['ns', 'uphys', 'math', 12, 'Undergraduate science students will take a minimum of 12 credit hours in mathematics.'],
    ['ns', 'uphys', 'phystheory', 26, 'Candidates for the B.S. in physics must take a minimum of 26 hours of physics theory.'],
    ['ns', 'uphys', 'physlab', 12, 'Candidates for the B.S. in physics must take a minimum of 12 hours of physics laboratory work.'],
    ['ns', 'uphys', 'humanities', 16, 'B.S. candidates in the sciences will take a minimum of 12 credit hours in the humanities.'],
    ['ns', 'uphys', 'science', 12, 'Physics majors are expected to take a minimum of 12 credit hours in other scientific disciplines.'],

    ['la', 'upsych', 'psychology', 24, 'Psychology majors must take the minimum credit hours in one or more of the four major psychology concentrations: general, biological, social, abnormal.'],
    ['la', 'upsych', 'writing', 9, 'Psychology majors must take a minimum of 9 credit hours in writing.'],
    ['la', 'upsych', 'research', 12, 'Psychology majors must take a minimum of 12 credit hours in research.'],
    ['la', 'upsych', 'diversity', 16, 'In recognition of the importance of diversity in modern society, undergraduate humanities majors must take a minimum of 16 credits hours of course emphasizing cultural diversity.'],
    ['la', 'upsych', 'reasoning', 6, 'B.A. candidates in the humanities will take a minimum of two courses emphasizing reasoning.'],
    ['la', 'upolisci', 'worldpol', 16, 'Political Science majors will take at least 16 credit hours of coursework in World Politics.'],
    ['la', 'upolisci', 'ampolitics', 16, 'Political Science majors will take at least 16 credit hours of coursework in American Politics.'],
    ['la', 'upolisci', 'intrelations', 12, 'Political Science majors will take at least 12 credit hours of coursework in international relations.'],
    ['la', 'upolisci', 'poliecon', 12, 'Political Science majors will take at least 12 credit hours of coursework in political economy.'],
    ['la', 'upolisci', 'writing', 9, 'Political science majors must take a minimum of 9 credit hours in writing.'],
    ['la', 'upolisci', 'diversity', 16, 'In recognition of the importance of diversity in modern society, undergraduate humanities majors must take a minimum of 16 credits hours of course emphasizing cultural diversity.'],
    ['la', 'upolisci', 'reasoning', 6, 'B.A. candidates in the humanities will take a minimum of two courses emphasizing reasoning.'],
    ['la', 'gscitch', 'science', 18, 'M.S. candidates for the science teaching degree who do not have undergraduate degrees in science must take a minimum of 18 credit hours in one scientific discipline.'],
    ['la', 'gscitch', 'pedagogy', 15, 'M.S. candidates should complete a minimum of 18 credit hours focused on pedagogy.'],
    ['la', 'gscitch', 'tmethods', 15, 'M.S. candidates should complete a minimum of 18 credit hours focused on teaching methods.'],
    ['la', 'gscitch', 'earlyed', 12, 'M.S. candidates will take a minimum of 12 hours of early childhood education instruction.'],
    ['la', 'psciwri', 'science', 12, 'Candidates for the Certificate in Science Writing will take four three-hour classes in general science.'],
    ['la', 'psciwri', 'journalism', 12, 'Candidates will take four three-hour classes in writing focused on scientific journalism'],
    ['la', 'gengl', 'literature', 36, 'Candidates for the M.A. in English will take a minimum of 36 credit hours of literature courses.'],
    ['la', 'uengl', 'worldlit', 20, 'B.A. candidates in English are expected to take 20 credit hours in world literature.'],
    ['la', 'uengl', 'englit', 15, 'B.A. candidates in English are expected to take 15 credit hours in English literature.'],
    ['la', 'uengl', 'linguistics', 15, 'B.A. candidates in English are expected to take 12 credit hours in linguistics.'],
    ['la', 'uengl', 'reasoning', 6, 'B.A. candidates in the humanities will take a minimum of two courses emphasizing reasoning.'],
    ['la', 'uengl', 'humanities', 16, 'B.A. candidates in the humanities will take a minimum of 16 credit hours in general humanities outside their major.'],
    ['la', 'uengl', 'modlanguage', 16, 'B.A. candidates in the humanities will take a minimum of two years of a modern language of their choice.'],
    ['la', 'uhist', 'history', 50, 'B.A. candidates in History are expected to take 50 credit hours in history of their choice.'],
    ['la', 'uhist', 'diversity', 16, 'In recognition of the importance of diversity in modern society, undergraduate humanities majors must take a minimum of 16 credits hours of course emphasizing cultural diversity.'],
    ['la', 'uspan', 'spanish', 12, 'Spanish majors will take a minimum of 12 credit hours in the Spanish majors.'],
    ['la', 'uspan', 'reasoning', 6, 'B.A. candidates in the humanities will take a minimum of two courses emphasizing reasoning.'],
    ['la', 'uspan', 'humanities', 16, 'B.A. candidates in the humanities will take a minimum of 16 credit hours in general humanities outside their major.'],
    ['la', 'uspan', 'modlanguage', 12, 'B.A. candidates in the humanities will take a minimum of two years of a modern language of their choice.'],
    ['la', 'uspan', 'diversity', 16, 'In recognition of the importance of diversity in modern society, undergraduate humanities majors must take a minimum of 16 credits hours of course emphasizing cultural diversity.'],
    ['la', 'glang', 'language', 22, 'Candidates for the Master of Arts in Modern Languages must take a minimum of 22 credit hours in the modern language of their concentration.'],

    ['eng', 'uelec', 'physics', 20, 'Bachelor of Engineering candidates are expected to take at least 20 hours of credit in physics.'],
    ['eng', 'uelec', 'eetheory', 24, 'Bachelor of Engineering candidates in Electrical Engineering are expected to take at least 24 hours of credit in EE theory.'],
    ['eng', 'uelec', 'eelab', 16, 'Bachelor of Engineering candidates in Electrical Engineering are expected to take at least 16 hours of credit in their area of concentration.'],
    ['eng', 'uelec', 'compsci', 12, 'Bachelor of Engineering candidates are expected to take at least 12 hours of credit in computer science and/or programming related to their major.'],
    ['eng', 'uelec', 'humanities', 12, 'Bachelor of Engineering candidates are expected to take at least 12 hours of credit in general humanities.'],
    ['eng', 'umech', 'physics', 20, 'Bachelor of Engineering candidates are expected to take at least 20 hours of credit in physics.'],
    ['eng', 'umech', 'me', 28, 'Bachelor of Engineering candidates in Mechanical Engineering are expected to take at least 28 hours of credit in mechanical engineering.'],
    ['eng', 'umech', 'melab', 9, 'Bachelor of Engineering candidates in Mechanical Engineering are expected to take at least 9 hours of credit in laboratory work.'],
    ['eng', 'umech', 'compsci', 12, 'Bachelor of Engineering candidates are expected to take at least 12 hours of credit in computer science and/or programming related to their major.'],
    ['eng', 'umech', 'humanities', 12, 'Bachelor of Engineering candidates are expected to take at least 12 hours of credit in general humanities.'],
    ['eng', 'ubio', 'be', 28, 'Bachelor of Engineering candidates in Bioengineering are expected to take at least 28 hours of credit in their area of concentration.'],
    ['eng', 'ubio', 'mesystems', 10, 'Bachelor of Engineering candidates in Bioengineering are expected to take at least 10 hours of credit in mechanical systems.'],
    ['eng', 'ubio', 'compsci', 12, 'Bachelor of Engineering candidates are expected to take at least 12 hours of credit in computer science and/or programming related to their major.'],
    ['eng', 'ubio', 'humanities', 12, 'Bachelor of Engineering candidates are expected to take at least 12 hours of credit in general humanities.'],
    ['eng', 'gbuseng', 'business', 16, 'Candidates for the Master of Science in Business and Engineering are required to take at least 16 credit hours in general business.'],
    ['eng', 'gbuseng', 'engineering', 22, 'Candidates for the Master of Science in Business and Engineering are required to take at least 22 credit hours in one or more relevant engineering disciplines.'],
    ['eng', 'gee', 'ee', 34, 'Candidates for the Master of Science in Electrical Engineering must take at least 34 credit hours in graduate electrical engineering.'],
    ['eng', 'gme', 'me', 36, 'Candidates for the Master of Science in Mechanical Engineering must take at least 36 credit hours in graduate mechanical engineering.'],
    ['eng', 'gbe', 'be', 38, 'Candidates for the Master of Science in Bioengineering must take at least 38 credit hours in graduate biological engineering.'],

    ['edu', 'umath', 'teached', 20, 'Bachelor of Arts students in Math Education must take at least 20 credit hours of general teacher education.'],
    ['edu', 'umath', 'math', 16, 'Bachelor of Arts students in Science Education must take at least 16 hours of general math.'],
    ['edu', 'umath', 'diversity', 8, 'In acknowledgement of the importance of diversity in education, all candidates for education degrees must take at least 8 credit hours in diverse cultures and history.'],
    ['edu', 'usci', 'teached', 22, 'Bachelor of Arts students in Science Education must take at least 22 credit hours of general science education.'],
    ['edu', 'usci', 'science', 14, 'Bachelor of Arts students in Science Education must take at least 14 hours of general science.'],
    ['edu', 'usci', 'diversity', 8, 'In acknowledgement of the importance of diversity in education, all candidates for education degrees must take at least 8 credit hours in diverse cultures and history.'],
    ['edu', 'psci', 'tmethods', 12, 'Candidates for the Certificate in Science Teaching are required to take a minimum number of credit hours in teaching methods.'],
    ['edu', 'psci', 'science', 12, 'Candidates for the Certificate in Science Teaching are required to take a minimum number of credit hours in general science.'],
    ['edu', 'glited', 'teached', 28, 'Candidates for the Master of Arts in Literacy Education will take the majority of their credit hours in teacher education, focusing on literacy.'],
    ['edu', 'gedlead', 'edpol', 20, 'Candidates for the Master of Arts in Educational Leadership will concentrate in educational policy.'],
    ['edu', 'gedlead', 'management', 12, 'Candidates for the Master of Arts in Educational Leadership will take a minimum number of credit hours in management at the School of Business.'],
    ['edu', 'gedu', 'edstudies', 15, 'Candidates for the Master of Science in Education are required to take a minimum number of credit hours in education policy study.'],
    ['edu', 'gedu', 'edresearch', 15, 'Candidates for the Master of Science in Education will focus on a core requirement of education related research leading up to the master''s thesis.'],
    ['edu', 'gtch', 'teached', 28, 'Candidates for the Master of Arts in Teaching will concentrate on the study of teaching methods in their chosen concentration.'],

    ['bus', 'uecon', 'math', 8, 'Students pursuing the B.S. in Economics must take at least 8 credit hours of relevant mathematics.'],
    ['bus', 'uecon', 'mathecon', 8, 'Students pursuing the B.S. in Economics must take at least 8 credit hours of mathematical economics.'],
    ['bus', 'uecon', 'econ', 24, 'Students pursuing the B.S. in Economics must take at least 30 credit hours in economics by their choise.'],
    ['bus', 'uecon', 'finance', 12, 'Students pursuing the B.S. in Economics must take at least 12 credit hours in general finance.'],
    ['bus', 'uecon', 'marketing', 12, 'Students pursuing the B.S. in Economics must take at least 12 credit hours in marketing.'],
    ['bus', 'uecon', 'humanities', 12, 'B.S. candidates will take a minimum of 12 credit hours in the humanities.'],
    ['bus', 'gecon', 'econ', 15, 'Candidates for the Master of Arts in Economics will must take at least 15 credit hours of advanced topics in economics.'],
    ['bus', 'gecon', 'finance', 10, 'Candidates for the Master of Arts in Economics will must take at least 15 credit hours of advanced topics in finance.'],
    ['bus', 'gecon', 'management', 10, 'Candidates for the Master of Arts in Economics will must take at least 15 credit hours of advanced topics in business management.'],
    ['bus', 'uacct', 'math', 8, 'Students pursuing the B.S. in Accounting must take at least 8 credit hours of relevant mathematics.'],
    ['bus', 'uacct', 'econ', 12, 'Students pursuing the B.S. in Accounting must take minimum number of credit hours in economics.'],
    ['bus', 'uacct', 'accounting', 30, 'Students pursuing the B.S. in Accounting will take the majority of their credit hours in accounting.'],
    ['bus', 'uacct', 'finance', 8, 'Students pursuing the B.S. in Accounting must take at least 8 credit hours in general finance topics.'],
    ['bus', 'uacct', 'humanities', 12, 'B.S. candidates will take a minimum of 12 credit hours in the humanities.'],
    ['bus', 'ubusad', 'math', 8, 'Candidates for the Bachelor of Business Administration must take at least 8 credit hours of relevant mathematics.'],
    ['bus', 'ubusad', 'econ', 16, 'Candidates for the Bachelor of Business Administration must take at least 16 credit hours of general economics.'],
    ['bus', 'ubusad', 'management', 24, 'Candidates for the Bachelor of Business Administration will focus on corporate management.'],
    ['bus', 'ubusad', 'marketing', 16, 'Candidates for the Bachelor of Business Administration must take at least 16 credit hours in marketing.'],
    ['bus', 'ubusad', 'humanities', 12, 'B.S. candidates will take a minimum of 12 credit hours in the humanities.'],
    ['bus', 'pacc', 'accounting', 20, 'Requirements for the Graduate Certificate in Accounting require a minimum number of credit hours in accounting and accounting theory.'],
    ['bus', 'pbusad', 'management', 20, 'Requirements for the Certificate in Business Administration include completion of a minimum number of credit hours in business management topics.'],

    ['art', 'gart', 'arthistory', 20, 'Candidates for the Post Baccalaureate in Art History must complete a minimum number of core art history courses.'],
    ['art', 'uhist', 'euroart', 15, 'Students in the undergraduate Art History program are required to take 15 credit hours of study of european art.'],
    ['art', 'uhist', 'worldart', 18, 'Students in the undergraduate Art History program are required to take 18 credit hours of study of world art.'],
    ['art', 'uhist', 'modernart', 15, 'Students in the undergraduate Art History program are required to take 15 credit hours of study of modern art.'],
    ['art', 'uhist', 'history', 14, 'Students in the undergraduate Art History program are required to take 14 credit hours of elective classes in history.'],
    ['art', 'ustudio', 'visual', 24, 'Students in the undergraduate Studio Art program will concentrate on their selected studio discipline.'],
    ['art', 'ustudio', 'drawing', 8, 'All Studio Art undergraduate students must take a minimum 8 hours of credit in freehand drawing.'],
    ['art', 'ustudio', 'society', 6, 'All Studio Art undergraduate students must take a minimum of 6 hours of credit in Art & Society.'],
    ['art', 'ustudio', 'arthistory', 16, 'All Studio Art undergraduate students must take a minimum of 16 hours of credit in art history.'],
  ]