Commits

yerokhin committed 6c6249a

Update course list, dependencies, classification

Comments (0)

Files changed (1)

test/regress/sql/regress-data.yaml

     ['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', 'ucorpfi', 'B.S. in Corporate Finance', 'bs', null],
-    ['bus', 'ubusad', 'B.S. in Business Administration', 'bs', null],
+    ['bus', 'ubusad', 'Bachelor of Business Administration', 'bs', null],
     ['bus', 'pacc', 'Graduate Certificate in Accounting', 'ct', null],
-    ['bus', 'pcap', 'Certificate in Capital Markets', 'ct', null],
+    ['bus', 'pcap', '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],
     ['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', 3, 'Theory and practice in simulation of complex physical systems.'],
+    ['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 spacetime symmetries, perturbative methods in QFT, definition of the S-matrix for scattering and decay processes.'],
     ['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 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, problematics and evolution from early works to the latest.'],
-    ['eng', 276, 'Introduction to Science Writing', 3, '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', 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, 'Rhetorics', 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, 'Introduction to Poetry', 3, 'Principles of prosody, variety of forms and traditions in the world poetry.'],
+    ['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 phycological and sociological aspects of the language, its influence on cognitive process.'],
     ['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 historicans use primary sources and other research methods; student research project.'],
+    ['hist', 434, 'Historical Method', 3, 'Techniques and guidelines how historicans 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.'],
     ['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', 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', 308, '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', 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 intracellural transport.'],
     ['stdart', 272, 'Prinmaking 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, 'Prinmaking II', 3, 'Basic concepts of lithography, advanced intaglio chechniques'],
+    ['stdart', 370, 'Prinmaking 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.'],
     ['econ', 101, 'Introduction to Microeconomics', 6, 'This course gives students understanding of market mechanism, consumer choise 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, 'Quantitive Method in Microeconomy', 3, 'Quantitive methods and problem solving in microeconomy.'],
-    ['econ', 205, 'Introduction to Global Economy', 3, 'Role of the national economic within the world economy; how the whole economy or its large sectors work, fiscal and monetary policy.'],
+    ['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, 'Probability and Statistics', 4, 'Introduction to mathematical statistics: probability theory, distributions, hypotesis testing, regression.'],
     ['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', 606, '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', 620, 'Accounting Internship', 6, 'Supervised intership 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 practives 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, 'This course 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.'],
     ['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', 411, 'astro', 410],
     ['astro', 418, 'astro', 223],
     ['astro', 432, 'astro', 223],
-    # dep to computer science
+    ['astro', 432, 'mth', 121],
+    ['astro', 432, 'comp', 102],
     ['astro', 433, 'astro', 432],
 
     ['chem', 111, 'chem', 110],
     ['chem', 314, 'chem', 120],
     ['chem', 316, 'chem', 120],
     ['chem', 320, 'chem', 120],
-    #dep to computer science
+    ['chem', 320, 'comp', 102],
     ['chem', 321, 'chem', 320],
     ['chem', 655, 'chem', 300],
 
     ['phys', 130, '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', 289, 'phys', 288],
     ['phys', 350, 'phys', 130],
     ['phys', 366, 'phys', 130],
-    # dep to computer science
+    ['phys', 366, 'mth', 122],
+    ['phys', 366, 'comp', 102],
     ['phys', 407, 'phys', 130],
     ['phys', 435, 'phys', 407],
     ['phys', 512, 'phys', 435],
     ['comp', 819, 'comp', 166],
     ['comp', 819, 'comp', 207],
 
-    ['ee', 412, 'ee', 107],
+    ['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', 225, 'ee', 107],
+    ['ee', 225, 'mth', 122],
+    ['ee', 225, 'mth', 211],
+    ['ee', 225, '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', 344, 'me', 111],
-    ['be', 415, 'be', 112],
-    ['arthis', 710, 'arthis', 202],
-    ['stdart', 614, 'stdart', 333],
-    ['tched', 609, 'tched', 122],
-    ['edpol', 313, 'edpol', 202],
-    ['corpfi', 601, 'corpfi', 404],
-    ['acc', 527, 'acc', 200],
-    ['capmrk', 818, 'acc', 315],
+    ['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, 'chem', 108],
+    ['be', 162, 'chem', 108],
+    ['be', 228, 'be', 108],
+    ['be', 228, 'phys', 121],
+    ['be', 229, 'be', 228],
+    ['be', 230, 'b1', 108],
+    ['be', 230, 'phys', 124],
+    ['be', 241, 'phys', 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', 345, '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
       ['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'],
-        ['ancient', 'department', 'Ancient Art', null, 'arthistory'],
-          ['classical', 'department', 'Classical Art', null, 'ancient'],
-          ['eastern', 'department', 'Near Eastern Art', null, 'ancient'],
-        ['modern', 'department', 'Modern Art', null, 'arthistory'],
-        ['artbus', 'department', 'Business of Art', null, 'arthistory'],
+        ['ancientart', 'department', 'Ancient Art', null, 'arthistory'],
+        ['modernart', 'department', 'Modern Art', null, 'arthistory'],
+        ['eastart', 'department', 'Traditional Eastern Art', null, 'arthistory'],
       ['literature', 'school', 'English and World Literature', null, 'humanities'],
-        ['englit', 'department', 'English Language Literature', null, 'humanities'],
-        ['eurolit', 'department', 'European Literature in Translation', null, 'humanities'],
-        ['nonfiction', 'department', 'NonFiction Writing', null, 'literature'],
+        ['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'],
-        ['amhistory', 'department', 'American History', null, 'humanities'],
-        ['eurohistory', 'department', 'European History', null, 'humanities'],
-        ['nonwesternhist', 'department', 'NonWestern History', null, 'humanities'],
-        ['dischistory', 'department', 'Interdisciplinary 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'],
       ['chemistry', 'school', 'Chemistry', null, 'science'],
         ['chemtheory', 'department', 'Theoretical Chemistry', null, 'chemistry'],
         ['chemlab', 'department', 'Chemistry Laboratory', null, 'chemistry'],
-        ['chemcomputation', 'department', 'Algorithms and Data Visualization for Chemists', null, 'chemistry'],
       ['physics', 'school', 'Physics', null, 'science'],
         ['phystheory', 'department', 'Theoretical Physics', null, 'physics'],
         ['physlab', 'department', 'Practical Physics', null, 'physics'],
-        ['physcomputer', 'department', 'Computer Languages for Physics', null, 'physics'],
       ['math', 'school', 'Mathematics', null, 'science'],
-        ['analysis', 'department', 'Real and Complex Analysis', null, 'math'],
+        ['analysis', 'department', 'Mathematical Analysis', null, 'math'],
         ['algebra', 'department', 'Algebra', null, 'math'],
         ['statistics', 'department', 'Probability and Statistics', null, 'math'],
         ['geometry', 'department', 'Geometry', null, 'math'],
-        ['diffeq', 'department', 'Differential Equations', null, 'math'],
     ['artdesign', 'university', 'Art and Design', null, null],
       ['studio', 'school', 'Studio Arts', null, 'artdesign'],
       ['artstudio', 'school', 'Studio Art', null, 'artdesign'],
         ['drawing', 'department', 'Drawing', null, 'artstudio'],
-        ['sculpture', 'department', 'Sculpture', null, 'artstudio'],
         ['printmaking', 'department', 'Printmaking', null, 'artstudio'],
+        ['craft', 'department', 'Arts and Crafts', null, 'artstudio'],
       ['industrial', 'school', 'Industrial Design', null, 'artdesign'],
       ['digital', 'school', 'Digital Media', null, 'artdesign'],
       ['society', 'school', 'Art and Society', null, 'artdesign'],
         ['softdev', 'department', 'Software Development', null, 'compsci'],
       ['ee', 'school', 'Electrical Engineering', null, 'engineering'],
         ['eetheory', 'department', 'Electrical Engineering Theory', null, 'ee'],
-        ['eeconcentration', 'department', 'EE Concentrations', null, 'ee'],
-          ['signal', 'department', 'Signal Processing', null, 'eeconcentration'],
-          ['power', 'department', 'Power Electronics', null, 'eeconcentration'],
-          ['eecom', 'department', 'Communications', null, 'eeconcentration'],
-          ['eenetworking', 'department', 'Electrical Networking', null, 'eeconcentration'],
+        ['eelab', 'department', 'Electrical Engineering Laboratory', null, 'ee'],
       ['me', 'school', 'Mechanical Engineering', null, 'engineering'],
         ['memechanics', 'department', 'Mechanics', null, 'me'],
         ['medesign', 'department', 'Design and Manufacturing', null, 'me'],
         ['mesystems', 'department', 'Systems and Controls', null, 'me'],
-      ['be', 'school', 'Biomedical Engineering', null, 'engineering'],
-        ['begeneral', 'department', 'General Biomedical Engineering', null, 'be'],
-        ['beclinical', 'department', 'Clinical Engineering', null, 'be'],
-        ['nanotech', 'department', 'Nanotechnology', null, 'be'],
-        ['biomaterials', 'department', 'Biomaterials', null, 'be'],
+      ['be', 'school', 'Biological Engineering', null, 'engineering'],
+        ['bioprocess', 'department', 'Biological Processes', null, 'be'],
+        ['bmeng', 'department', 'Biomedical Engineering', null, 'be'],
+        ['belab', 'department', 'Bioengineering Laboratory', null, 'be'],
     ['education', 'university', 'Education', null, null],
       ['teached', 'school', 'Teacher Education', null, 'education'],
-        ['methods', 'department', 'Teaching Methods', null, 'teached'],
-        ['edmanagement', 'department', 'Education Management', null, 'teached'],
+        ['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],
-      ['ethics', 'school', 'Business Ethics', null, 'business'],
-      ['financial', 'school', 'Financial Analysis', null, 'business'],
-        ['accounting', 'department', 'Accounting', null, 'financial'],
-        ['investment', 'department', 'Investment', null, 'financial'],
-          ['personal', 'department', 'Personal Investment', null, 'investment'],
-          ['institutional', 'department', 'Institutional Investment', null, 'investment'],
-        ['markets', 'school', 'Capital Markets', null, 'financial'],
+      ['econ', 'school', 'Economics', null, 'business'],
+        ['microecon', 'school', 'Microeconomics', null, 'econ'],
+        ['macroecon', 'school', 'Macroeconomics', null, 'econ'],
+        ['interecon', 'school', 'International Economics', null, 'econ'],
+      ['finance', 'school', 'Finance', null, 'business'],
+      ['accounting', 'department', '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', 111, 'astrolab'],
-    ['astro', 120, 'astrotheory'],
-    ['astro', 130, 'astrotheory'],
-    ['astro', 140, 'astrotheory'],
+    ['astro', 122, 'astrotheory'],
     ['astro', 210, 'astrotheory'],
     ['astro', 211, 'astrolab'],
-    ['astro', 220, 'astrotheory'],
-    ['astro', 230, 'astrotheory'],
-    ['astro', 240, 'observation'],
+    ['astro', 215, 'astrotheory'],
+    ['astro', 223, 'astrotheory'],
+    ['astro', 230, 'observation'],
     ['astro', 241, 'observation'],
-    ['astro', 310, 'astrotheory'],
+    ['astro', 315, 'astrotheory'],
     ['astro', 320, 'astrotheory'],
-    ['astro', 330, 'observation'],
-    ['astro', 331, 'observation'],
+    ['astro', 328, 'observation'],
+    ['astro', 329, 'observation'],
     ['astro', 340, 'astronomy'],
-    ['astro', 350, 'astrotheory'],
+    ['astro', 345, 'astrotheory'],
     ['astro', 410, 'astrotheory'],
     ['astro', 411, 'astrolab'],
-    ['astro', 420, 'astrotheory'],
-    ['astro', 430, 'astrotheory'],
-    ['astro', 430, 'astrolab'],
-    ['astro', 431, 'astrolab'],
-    ['astro', 431, '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, 'math'],
+    ['mth', 102, 'remedial'],
+    ['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', 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', 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', 427, 'anclanguage'],
+    ['lang', 437, 'linguistics'],
+    ['lang', 437, 'earlyed'],
+    ['lang', 438, 'linguistics'],
+    ['lang', 438, 'earlyed'],
+
+    ['hist', 112, 'amhistory'],
+    ['hist', 120, 'westernhist'],
+    ['hist', 121, 'westernhist'],
+    ['hist', 122, 'westernhist'],
+    ['hist', 212, 'dischistory'],
+    ['hist', 220, 'nonwesternhist'],
+    ['hist', 220, 'diversity'],
+    ['hist', 238, 'nonwesternhist'],
+    ['hist', 238, 'diversity'],
+    ['hist', 240, 'westernhist'],
+    ['hist', 256, 'westernhist'],
+    ['hist', 329, 'westernhist'],
+    ['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'],
+
     ['chem', 100, 'remedial'],
     ['chem', 110, 'science'],
     ['chem', 115, 'chemlab'],
     ['edu', 'gedlead', 'management', 8, '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', 'edresearch', 22, 'Candidates for the Master of Science in Education will focus on a core requirement of educationrelated 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', 'uacct', 'accounting', 24, 'Students pursuing the B.S. in Accounting will take the majority of their credit hours in accounting.'],
     ['bus', 'uacct', 'investment', 8, 'Students pursuing the B.S. in Accounting must take at least 8 credit hours in general investment topics.'],
     ['bus', 'uacct', 'analysis', 8, 'Students pursuing the B.S. in Accounting must take at least 8 credit hours of relevant mathematics.'],
     ['bus', 'ubusad', 'ethics', 12, 'Students pursuing any undergraduate degree in business will be required to meet a core requirement in business ethics.'],
     ['bus', 'pacc', 'accounting', 20, 'Requirements for the Graduate Certificate in Accounting require a minimum number of credit hours in accounting and accounting theory.'],
     ['bus', 'pcap', 'markets', 20, 'Requirements for the Certificate in Capital Markets include completion of a minimum number of credit hours in markets 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', 'classical', 9, 'Students in the undergraduate Art History program are required to take 9 credit hours of study of classical art.'],
     ['art', 'uhist', 'modern', 9, 'Students in the undergraduate Art History program are required to take 9 credit hours of study of modern art.'],