Commits

yerokhin committed 36d7526

Course list update

  • Participants
  • Parent commits 1c1ef86

Comments (0)

Files changed (1)

File test/regress/sql/regress-data.yaml

 - table: ad.course
   columns: [department_code, 'no', title, credits, description]
   data: [
-    ['astro', 137, 'The 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', 142, 'Solar System Lab', 2, 'Laboratory studies that complement the lecture course ASTRO 137.'],
-    ['astro', 155, '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', 254, '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.'],
-    ['mth', 101, 'College Algebra', 5, 'This course, taken mostly by members from the School of Business is a primary graduate student funding vehicle for the the Department of Mathematics.  This is a 1000 person lecture reviews basic concepts taught in high school.'],
+    ['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 astrophysic 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, 'Organic Chemistry I', 3, 'This course offers a practical introduction to organic chemistry, including a full set of problem sets with solutions. Focus is on the basic principles of understanding the structure and reactivity of organic molecules.'],
-    ['chem', 115, 'Organic Chemistry Laboratory I', 2, 'Complements Organic Chemistry I. Practical laboratory experiments.'],
-    ['chem', 314, 'Laboratory Chemistry', 3, 'Experimental chemistry 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', 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 a full set of 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', 211, 'General Physics I', 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', 303, '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', 388, 'Experimental Physics I', 2, 'In this course students will perform several experiments in different areas of physics. They will also learn fundamental experimental techniques and how to record and report results and perform analysis.'],
+
+    ['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, difraction, polarisation, 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', 3, '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.'],
     ['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', 3, 'This course, taken mostly by members from the School of Business is a primary graduate student funding vehicle for the the Department of Mathematics.  This is a 1000 person lecture reviews basic concepts taught in high school.'],
+    ['mth', 102, 'College Algebra II', 3, '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 Ceasar "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 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', 311, 'Writing Styles', 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', 175, 'College Newspaper', 2, 'Students will perform journalistic writing exercises for publication in the college newspaper.'],
+    ['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', 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.'],
+
+    ['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.'],
+    ['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 differencies between roman laguages 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, 'Morpholody 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, 'Historical context, flow, important figures and significance 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 historicans use primary sources and other research methods; student research project.'],
+    ['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', 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.'],
-    ['lang', 201, 'Introduction to Spanish', 4, 'Introduction to the Spanish language, with an emphasis on every day conversation and basic grammar.'],
-    ['lang', 203, 'Intermediate Spanish', 3, 'Continuation of fundamental Spanish 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', 207, 'Child Second Language Development', 3, 'Examines issues in child second language acquisition, including the critical period hypothesis and universal grammar.'],
-    ['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.'],
-    ['psych', 102, 'General Psychology', 3, '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', 304, 'Introduction to Cognitive Psychology', 3, 'An introduction to the basic concepts of cognitive psychology, including areas such as perception, attention, memory, language, and thought.'],
+    ['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 Reseach 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 Psychopatology', 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', 2, '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 personel, 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 expirience in constitutional law, relationships between individual and government, basic constitutional principles.'],
+    ['poli', 320, 'International Organizations', 3, 'Role of international organizations in global problem solving, intergovernment 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 economical 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, comparision 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 Palestian Statehood'],
-    ['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.'],
-    ['comp', 102, 'Introduction to Computer Science', 3, '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', 230, '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', 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, peripherials, IO concepts.'],
+    ['comp', 216, 'Computer Organization Lab', 2, 'Programming on the laboratory stand, which consists of micro-controller with embedded memory and simple peripherials: 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', 615, 'Introduction to Automata', 3, 'Theory of computing devices and the languages they recognize.'],
+    ['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', 3, '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 Engeneering', 3, 'Topics in mathematics useful in engeneering: differential equations, Fourier series, Laplace transforms, boundary value problems.'],
+    ['ee', 315, 'Signals and Systems', 3, 'Concepts of continious 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 aerodynamical 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, ''],
     ['me', 712, 'Graphic Communication and Design', 3, 'Sketching and orthographic projection. Covers detail and assembly working drawings, dimensioning, tolerance specification, and design projects.'],
+
     ['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', 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', 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', 509, 'Systems of Drug Delivery', 3, 'The mathematics of diffusion through various types of biological media is discussed.'],
+
     ['arthis', 202, 'History of Art Criticism', 3, 'An introductory survey course on Prehistoric through late-Medieval art history.'],
     ['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', 340, '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.'],
 - table: rd.prerequisite
   columns: [of_department_code, of_course_no, on_department_code, on_course_no]
   data: [
-    ['astro', 142, 'astro', 137],
-    ['chem', 314, 'chem', 115],
-    ['chem', 110, 'chem', 100],
-    ['phys', 303, 'phys', 211],
-    ['phys', 713, 'phys', 512],
-    ['eng', 412, 'eng', 276],
-    ['hist', 212, 'hist', 112],
-    ['lang', 203, 'lang', 201],
-    ['lang', 305, 'lang', 207],
+    ['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', 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],
+    # dep to computer science
+    ['astro', 433, 'astro', 432],
+
+    ['chem', 111, 'chem', 110],
+    ['chem', 120, 'chem', 110],
+    ['chem', 121, 'chem', 120],
+    ['chem', 200, 'chem', 120],
+    ['chem', 201, 'chem', 200],
+    ['chem', 210, 'chem', 200],
+    ['chem', 211, 'chem', 210],
+    ['chem', 220, 'chem', 120],
+    ['chem', 220, 'phys', 124],
+    ['chem', 221, 'chem', 220],
+    ['chem', 300, 'chem', 210],
+    ['chem', 301, 'chem', 300],
+    ['chem', 314, 'chem', 120],
+    ['chem', 316, 'chem', 120],
+    ['chem', 320, 'chem', 120],
+    #dep to computer science
+    ['chem', 321, 'chem', 320],
+    ['chem', 655, 'chem', 300],
+
+    ['phys', 109, 'phys', 108],
+    ['phys', 122, 'phys', 121],
+    ['phys', 124, 'phys', 121],
+    ['phys', 125, 'phys', 124],
+    ['phys', 128, 'phys', 124],
+    ['phys', 129, 'phys', 128],
+    ['phys', 130, 'phys', 128],
+    ['phys', 131, 'phys', 130],
+    ['phys', 201, 'phys', 130],
+    ['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],
+    # dep to computer science
+    ['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],
-    ['comp', 710, 'comp', 102],
+    ['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', 412, 'ee', 107],
+
     ['me', 344, 'me', 111],
     ['be', 415, 'be', 112],
     ['arthis', 710, 'arthis', 202],
         ['modern', 'department', 'Modern Art', null, 'arthistory'],
         ['artbus', 'department', 'Business of Art', null, 'arthistory'],
       ['literature', 'school', 'English and World Literature', null, 'humanities'],
-        ['englit', 'department', 'EnglishLanguage Literature', null, 'humanities'],
+        ['englit', 'department', 'English Language Literature', null, 'humanities'],
         ['eurolit', 'department', 'European Literature in Translation', null, 'humanities'],
         ['nonfiction', 'department', 'NonFiction Writing', null, 'literature'],
         ['journalism', 'department', 'Journalistic Writing', null, 'literature'],
         ['anclanguage', 'department', 'Ancient Languages', null, 'language'],
         ['linguistics', 'department', 'Linguistics', null, 'language'],
       ['polisci', 'school', 'Political Science', null, 'humanities'],
-        ['government', 'department', 'Government', null, 'polisci'],
+        ['ampolitics', 'department', 'American Politics', null, 'polisci'],
         ['intrelations', 'department', 'International Relations', null, 'polisci'],
         ['poliecon', 'department', 'Political Economy', null, 'polisci'],
       ['psychology', 'school', 'Psychology', null, 'humanities'],
-        ['cogpsych', 'department', 'Cognitive Science', null, 'psychology'],
-        ['behpsych', 'department', 'Behavioral Science', null, 'psychology'],
-        ['chipsych', 'department', 'Child Psychology and Development', null, 'psychology'],
+        ['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'],
         ['physcomputer', 'department', 'Computer Languages for Physics', null, 'physics'],
       ['math', 'school', 'Mathematics', null, 'science'],
         ['analysis', 'department', 'Real and Complex Analysis', null, 'math'],
-        ['algebra', 'department', 'Abstract Algebra', 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'],
     ['engineering', 'university', 'Engineering', null, null],
       ['compsci', 'school', 'Computer Science', null, 'engineering'],
         ['comptheory', 'department', 'Computationial Science', null, 'compsci'],
-        ['softeng', 'department', 'Software Engineering', null, 'compsci'],
-        ['compai', 'department', 'Artificial Intelligence', 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'],
         ['eeconcentration', 'department', 'EE Concentrations', null, 'ee'],
 - table: rd.course_classification
   columns: [department_code, course_no, classification_code]
   data: [
-    ['astro', 137, 'astronomy'],
-    ['astro', 142, 'astrolab'],
-    ['astro', 155, 'observation'],
-    ['astro', 254, 'astrotheory'],
+    ['astro', 110, 'astrotheory'],
+    ['astro', 111, 'astrolab'],
+    ['astro', 120, 'astrotheory'],
+    ['astro', 130, 'astrotheory'],
+    ['astro', 140, 'astrotheory'],
+    ['astro', 210, 'astrotheory'],
+    ['astro', 211, 'astrolab'],
+    ['astro', 220, 'astrotheory'],
+    ['astro', 230, 'astrotheory'],
+    ['astro', 240, 'observation'],
+    ['astro', 241, 'observation'],
+    ['astro', 310, 'astrotheory'],
+    ['astro', 320, 'astrotheory'],
+    ['astro', 330, 'observation'],
+    ['astro', 331, 'observation'],
+    ['astro', 340, 'astronomy'],
+    ['astro', 350, 'astrotheory'],
+    ['astro', 410, 'astrotheory'],
+    ['astro', 411, 'astrolab'],
+    ['astro', 420, 'astrotheory'],
+    ['astro', 430, 'astrotheory'],
+    ['astro', 430, 'astrolab'],
+    ['astro', 431, 'astrolab'],
+    ['astro', 431, 'astrolab'],
+
     ['mth', 101, 'remedial'],
     ['chem', 100, 'remedial'],
     ['chem', 110, 'science'],
   data: [
     ['ns', 'uastro', 'astrolab', 8, 'Astronomy students are expected to take a minimum of 8 credit hours in the astronomy laboratory.'],
     ['ns', 'uastro', 'observation', 12, 'Undergraduate astronomy students will take a minimum of 12 credit hours of observational astronomy.'],
-    ['ns', 'uastro', 'astrotheory', 24, 'Undergraduate astronomy students will take a minimum of 12 credit hours of coursework on astronomy theory.'],
+    ['ns', 'uastro', 'astrotheory', 24, 'Undergraduate astronomy students will take a minimum of 24 credit hours of coursework on astronomy theory.'],
     ['ns', 'uastro', 'reasoning', 12, 'Undergraduate science students will take a minimum of 12 credit hours in general reasoning.'],
     ['ns', 'uastro', 'research', 12, 'B.S. candidates in the sciences will take a minimum of 12 credit hours in research techniques.'],
     ['ns', 'uastro', 'humanities', 16, 'B.S. candidates in the sciences will take a minimum of 16 credit hours in the humanities.'],
     ['la', 'upsych', 'writing', 12, 'Psychology majors must take a minimum of 12 credit hours in writing.'],
     ['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', 'government', 16, 'Political Science majors will take at least 16 credit hours of coursework in world government'],
+    ['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', 12, 'Political science majors must take a minimum of 12 credit hours in writing.'],