Kirill Simonov avatar Kirill Simonov committed e8492eb

Added advanced regression schema for PostgreSQL and some basic tests.

Comments (0)

Files changed (5)

src/htsql_pgsql/introspect.py

                     scale = (att.atttypmod-4) & 0xFFFF
                 return PGDecimalDomain(schema_name, name,
                                        precision=precision, scale=scale)
-            if base_name == 'char':
+            if base_name == 'bpchar':
                 length = att.atttypmod-4 if att.atttypmod != -1 else None
                 return PGCharDomain(schema_name, name, length=length)
             if base_name == 'varchar':

test/input/pgsql.yaml

 - title: Queries
   id: queries-pgsql
   tests:
-  - uri: /
-  - uri: /{2+2}
-    skip: true
-  - uri: /test
-  - uri: /test{id}
-  - uri: /test{data}?id=1
-    skip: true
-  - uri: /test
-    headers:
-      Accept: application/json
-  - uri: /test
-    headers:
-      Accept: text/csv
-  - uri: /test
-    headers:
-      Accept: text/plain
-  - uri: /test
-    headers:
-      Accept: text/html
 
+  # Display all tables in the regression schema.
+  - title: Regression schema
+    tests:
+    - uri: /school
+    - uri: /department
+    - uri: /program
+    - uri: /course
+    - uri: /instructor
+    - uri: /confidential
+    - uri: /appointment
+    - uri: /semester
+    - uri: /class
+    - uri: /student
+    - uri: /enrollment
+    - uri: /prerequisite
+    - uri: /classification
+    - uri: /course_classification
+    - uri: /program_requirement
+
+  # Empty and scalar queries.
+  - title: Scalar queries
+    tests:
+    - uri: /
+    - uri: /{'HT'+'SQL'}
+
+  # Simple (non-aggregate) filters.
+  - title: Simple filters
+    tests:
+    - uri: /school?code='ns'
+    - uri: /department?school.code='ns'
+    - uri: /program?school.code='ns'&code='uchem'
+    - uri: /course?credits=5
+
+  # Simple (non-aggregate) selectors.
+  - title: Simple selectors
+    tests:
+    - uri: /school{name}
+    - uri: /department{school.*,*}
+    - uri: /department{school.name+' - '+name}
+
+  # Plural links and aggregates.
+  - title: Aggregates
+    tests:
+    - uri: /department{code,count(course{credits=3})}
+    - uri: /school{code,count(department.course{credits=3})}
+    - uri: /school{code}?count(department.course{credits=3})=20
+
+  # Demonstrate selection of a formatter based on the `Accept` header.
+  - title: Formatters
+    tests:
+    - uri: /school
+      headers:
+        Accept: application/json
+    - uri: /school
+      headers:
+        Accept: text/csv
+    - uri: /school
+      headers:
+        Accept: text/plain
+    - uri: /school
+      headers:
+        Accept: text/html
+

test/output/pgsql.yaml

 tests:
 - id: queries-pgsql
   tests:
-  - uri: /
-    status: 200 OK
-    headers:
-    - [Content-Type, text/plain; charset=UTF-8]
-    body: |
-      (no data)
+  - id: regression-schema
+    tests:
+    - uri: /school
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | school                                  |
+        -+-----------------------------------------+-
+         | code | name                             |
+        -+------+----------------------------------+-
+         | art  | School of Art and Design         |
+         | bus  | School of Business               |
+         | edu  | College of Education             |
+         | egn  | School of Engineering            |
+         | la   | School of Arts, Letters, and the |
+         :      : Humanities                       :
+         | mart | School of Modern Art             |
+         | mus  | Musical School                   |
+         | ns   | School of Natural Sciences       |
+         | sc   | School of Continuing Studies     |
+                                            (9 rows)
 
-       ----
-       /
-  - uri: /{2+2}
-    status: 200 OK
-    headers:
-    - [Content-Type, text/plain]
-    body: |
-      /{2+2}
-  - uri: /test
-    status: 200 OK
-    headers:
-    - [Content-Type, text/plain; charset=UTF-8]
-    body: |2
-       | test       |
-      -+------------+-
-       | id | data  |
-      -+----+-------+-
-       |  1 | one   |
-       |  2 | two   |
-       |  3 | three |
-             (3 rows)
+         ----
+         /school
+         SELECT "school"."code", "school"."name" FROM "ad"."school" AS "school" ORDER BY 1 ASC
+    - uri: /department
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | department                               |
+        -+------------------------------------------+-
+         | code   | name                   | school |
+        -+--------+------------------------+--------+-
+         | acc    | Accounting             | bus    |
+         | arthis | Art History            | art    |
+         | artstd | Studio Art             | art    |
+         | astro  | Astronomy              | ns     |
+         | be     | Bioengineering         | egn    |
+         | capmrk | Capital Markets        | bus    |
+         | chem   | Chemistry              | ns     |
+         | comp   | Computer Science       | egn    |
+         | corpfi | Corporate Finance      | bus    |
+         | edpol  | Educational Policy     | edu    |
+         | ee     | Electrical Engineering | egn    |
+         | eng    | English                | la     |
+         | hist   | History                | la     |
+         | lang   | Foreign Languages      | la     |
+         | me     | Mechanical Engineering | egn    |
+         | mth    | Mathematics            | ns     |
+         | phys   | Physics                | ns     |
+         | pia    | Piano                  | mus    |
+         | poli   | Political Science      | la     |
+         | psych  | Psychology             | la     |
+         | str    | Strings                | mus    |
+         | tched  | Teacher Education      | edu    |
+         | voc    | Vocals                 | mus    |
+         | win    | Wind                   | mus    |
+                                            (24 rows)
 
-       ----
-       /test
-  - uri: /test{id}
-    status: 200 OK
-    headers:
-    - [Content-Type, text/plain; charset=UTF-8]
-    body: |2
-       | test   |
-      -+--------+-
-       | id     |
-      -+--------+-
-       |      1 |
-       |      2 |
-       |      3 |
-         (3 rows)
+         ----
+         /department
+         SELECT "department"."code", "department"."name", "department"."school" FROM "ad"."department" AS "department" ORDER BY 1 ASC
+    - uri: /program
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | program                                                       |
+        -+---------------------------------------------------------------+-
+         | school | code     | title                            | degree |
+        -+--------+----------+----------------------------------+--------+-
+         | art    | gart     | Post Baccalaureate in Art        | pb     |
+         :        :          : History                          :        :
+         | art    | uhist    | Bachelor of Arts in Art History  | ba     |
+         | art    | ustudio  | Bachelor of Arts in Studio Art   | ba     |
+         | bus    | pacc     | Graduate Certificate in          | ct     |
+         :        :          : Accounting                       :        :
+         | bus    | pcap     | Certificate in Capital Markets   | ct     |
+         | bus    | uacct    | Bachelor of Science in           | bs     |
+         :        :          : Accounting                       :        :
+         | bus    | ubusad   | Bachelor of Science in Business  | bs     |
+         :        :          : Administration                   :        :
+         | bus    | ucorpfi  | Bachelor of Science in Corporate | bs     |
+         :        :          : Finance                          :        :
+         | edu    | gedlead  | Master of Arts in Educational    | ma     |
+         :        :          : Leadership                       :        :
+         | edu    | gedu     | Master of Science in Education   | ms     |
+         | edu    | glited   | Master of Arts in Literacy       | ma     |
+         :        :          : Education                        :        :
+         | edu    | gtch     | Master of Arts in Teaching       | ma     |
+         | edu    | psci     | Certificate in Science Teaching  | ct     |
+         | edu    | umath    | Bachelor of Arts in Math         | ba     |
+         :        :          : Education                        :        :
+         | edu    | usci     | Bachelor of Arts in Science      | ba     |
+         :        :          : Education                        :        :
+         | egn    | gbe      | Master of Science in             | ms     |
+         :        :          : Bioengineering                   :        :
+         | egn    | gbuseng  | Master of Science in Business    | ms     |
+         :        :          : and Engineering                  :        :
+         | egn    | gee      | Master of Science in Electrical  | ms     |
+         :        :          : Engineering                      :        :
+         | egn    | gme      | Master of Science in Mechanical  | ms     |
+         :        :          : Engineering                      :        :
+         | egn    | ubio     | Bachelor of Science in           | bs     |
+         :        :          : Bioengineering                   :        :
+         | egn    | ucompsci | Bachelor of Science in Computer  | bs     |
+         :        :          : Science                          :        :
+         | egn    | uelec    | Bachelor of Science in           | bs     |
+         :        :          : Electrical Engineering           :        :
+         | egn    | umech    | Bachelor of Science in           | bs     |
+         :        :          : Mechanical Engineering           :        :
+         | la     | gengl    | Master of Arts in English        | ma     |
+         | la     | glang    | Master of Arts in Modern         | ma     |
+         :        :          : Languages                        :        :
+         | la     | gscitch  | Master of Arts in Science        | ma     |
+         :        :          : Teaching                         :        :
+         | la     | psciwri  | Science Writing                  | ct     |
+         | la     | uengl    | Bachelor of Arts in English      | ba     |
+         | la     | uhist    | Bachelor of Arts in History      | ba     |
+         | la     | upolisci | Bachelor of Arts in Political    | ba     |
+         :        :          : Science                          :        :
+         | la     | upsych   | Bachelor of Arts in Psychology   | ba     |
+         | la     | uspan    | Bachelor of Arts in Spanish      | ba     |
+         | mart   | bmart    | Bachelor of Modern Art           | ba     |
+         | ns     | uastro   | Bachelor of Science in Astronomy | bs     |
+         | ns     | uchem    | Bachelor of Science in Chemistry | bs     |
+         | ns     | uphys    | Bachelor of Science in Physics   | bs     |
+                                                                 (36 rows)
 
-       ----
-       /test{id}
-  - uri: /test
-    status: 200 OK
-    headers:
-    - [Content-Type, application/json]
-    body: |
-      [
-        [1, "one"],
-        [2, "two"],
-        [3, "three"]
-      ]
-  - uri: /test
-    status: 200 OK
-    headers:
-    - [Content-Type, text/csv; charset=UTF-8]
-    body: "id,data\r\n1,one\r\n2,two\r\n3,three\r\n"
-  - uri: /test
-    status: 200 OK
-    headers:
-    - [Content-Type, text/plain; charset=UTF-8]
-    body: |2
-       | test       |
-      -+------------+-
-       | id | data  |
-      -+----+-------+-
-       |  1 | one   |
-       |  2 | two   |
-       |  3 | three |
-             (3 rows)
+         ----
+         /program
+         SELECT "program"."school", "program"."code", "program"."title", "program"."degree" FROM "ad"."program" AS "program" ORDER BY 1 ASC, 2 ASC
+    - uri: /course
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | course                                                                                              |
+        -+-----------------------------------------------------------------------------------------------------+-
+         | department | number | title                            | credits | description                      |
+        -+------------+--------+----------------------------------+---------+----------------------------------+-
+         | acc        |    100 | Practical Bookkeeping            |       2 | A introduction to business with  |
+         :            :        :                                  :         : practical bookkeeping            :
+         :            :        :                                  :         : application.                     :
+         | acc        |    200 | Principles of Accounting I       |       3 | The initial course in the theory |
+         :            :        :                                  :         : and practice of financial        :
+         :            :        :                                  :         : accounting. Topics emphasized    :
+         :            :        :                                  :         : include the preparation,         :
+         :            :        :                                  :         : reporting, and analysis of       :
+         :            :        :                                  :         : financial data.                  :
+         | acc        |    315 | Financial Accounting             |       5 | Integration of the conceptual    |
+         :            :        :                                  :         : and computational aspects of     :
+         :            :        :                                  :         : asset, liability and             :
+         :            :        :                                  :         : stockholders equity accounting.  :
+         | acc        |    426 | Corporate Taxation               |       3 | Concepts and methods of          |
+         :            :        :                                  :         : determining federal tax          :
+         :            :        :                                  :         : liability of corporations.       :
+         | 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.                      :
+         | arthis     |    202 | History of Art Criticism         |       3 | An introductory survey course on |
+         :            :        :                                  :         : Prehistoric through              :
+         :            :        :                                  :         : late-Medieval art history.       :
+         | 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.                            :
+         | arthis     |    623 | Contemporary Latin American Art  |       3 | A survey of the last twenty      |
+         :            :        :                                  :         : years of Latin American art with :
+         :            :        :                                  :         : a focus on the Caribbean and     :
+         :            :        :                                  :         : Central America.                 :
+         | arthis     |    710 | Methods in Art History           |       3 | This seminar focuses on basic    |
+         :            :        :                                  :         : types of art-historical method.  :
+         :            :        :                                  :         : Some meetings focus on a single  :
+         :            :        :                                  :         : author who exemplifies a         :
+         :            :        :                                  :         : particular approach.             :
+         | arthis     |    712 | Museum and Gallery Management    |       4 | Supervised independent field     |
+         :            :        :                                  :         : experience and practical work in :
+         :            :        :                                  :         : all areas of Art Museum          :
+         :            :        :                                  :         : management in the university and :
+         :            :        :                                  :         : greater metropolitan area        :
+         :            :        :                                  :         : communities.                     :
+         | arthis     |    809 | Materials and Construction in    |       3 | A scientific examination of the  |
+         :            :        : European Art                     :         : materials and manufacturing      :
+         :            :        :                                  :         : techniques employed in Europe    :
+         :            :        :                                  :         : over the last two centuries.     :
+         | artstd     |    119 | Spring Basket Weaving Workshop   |         | A just-for-fun chance to learn   |
+         :            :        :                                  :         : the basics of basket weaving.    :
+         | artstd     |    333 | Drawing                          |       3 | Exploration of the structure and |
+         :            :        :                                  :         : interrelationships of visual     :
+         :            :        :                                  :         : form in drawing, painting, and   :
+         :            :        :                                  :         : sculpture. Principal historical  :
+         :            :        :                                  :         : modes of drawing are examined.   :
+         | artstd     |    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.   :
+         | artstd     |    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.   :
+         | artstd     |    512 | Art in Therapy                   |       3 | Surveys methods and results of   |
+         :            :        :                                  :         : using art and craft therapy with :
+         :            :        :                                  :         : developmentally disabled adults. :
+         | artstd     |    614 | Drawing Master Class             |       5 | For fine arts majors only, an    |
+         :            :        :                                  :         : intensive studio study including :
+         :            :        :                                  :         : field trips to local parks and   :
+         :            :        :                                  :         : museums and a final group art    :
+         :            :        :                                  :         : show.                            :
+         | artstd     |    714 | Peer Portfolio Review            |       0 | An opportunity to practice       |
+         :            :        :                                  :         : giving and receiving             :
+         :            :        :                                  :         : constructive criticism.          :
+         | 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.                       :
+         | be         |    112 | Introduction to Biomedical       |       3 | This course covers topics in     |
+         :            :        : Engineering                      :         : 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         |       8 | The student will work twenty     |
+         :            :        : Engineering                      :         : 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.   :
+         | capmrk     |    712 | International Financial Markets  |       3 | Offers an understanding of the   |
+         :            :        :                                  :         : international financial          :
+         :            :        :                                  :         : structure and studies its impact :
+         :            :        :                                  :         : on business and individuals in   :
+         :            :        :                                  :         : various nations.                 :
+         | capmrk     |    756 | Capital Risk Management          |       3 | This course introduces           |
+         :            :        :                                  :         : fundamental principles and       :
+         :            :        :                                  :         : techniques of financial risk     :
+         :            :        :                                  :         : management.                      :
+         | capmrk     |    808 | Principles of Portfolio          |       3 | Comprehensive coverage of the    |
+         :            :        : Management                       :         : theory and practice of money     :
+         :            :        :                                  :         : management as well as in-depth   :
+         :            :        :                                  :         : analysis of the theory and       :
+         :            :        :                                  :         : practice involved when           :
+         :            :        :                                  :         : securities are combined into     :
+         :            :        :                                  :         : portfolios.                      :
+         | capmrk     |    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.           :
+         | 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       |    655 | Protein Folding Problem          |       3 | Focuses on the mechanisms        |
+         :            :        :                                  :         : through which the amino acid     :
+         :            :        :                                  :         : sequence of polypeptide chains   :
+         :            :        :                                  :         : determine their                  :
+         :            :        :                                  :         : three-dimensional conformation.  :
+         | 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       |    350 | Introduction to Signal           |       3 | This course covers the nature of |
+         :            :        : Processing                       :         : 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       |    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           |       3 | This course is focused on        |
+         :            :        : Bioinformatics                   :         : fundamental algorithmic          :
+         :            :        :                                  :         : techniques in Bioinformatics,    :
+         :            :        :                                  :         : including classed methods such   :
+         :            :        :                                  :         : as dynamic programming, support  :
+         :            :        :                                  :         : vector machines and other        :
+         :            :        :                                  :         : statistical and learning         :
+         :            :        :                                  :         : optimization methods.            :
+         | corpfi     |    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.                    :
+         | corpfi     |    404 | Corporate Financial Management   |       3 | This course covers advanced      |
+         :            :        :                                  :         : topics in corporate financial    :
+         :            :        :                                  :         : management, including its role   :
+         :            :        :                                  :         : in corporate governance.         :
+         | corpfi     |    601 | Case Studies in Corporate        |       3 | A course designed to use case    |
+         :            :        : Finance                          :         : studies and financial analysis   :
+         :            :        :                                  :         : to further knowledge and ability :
+         :            :        :                                  :         : to make financial management     :
+         :            :        :                                  :         : decisions.                       :
+         | edpol      |    202 | Technology in the Classroom      |       3 | Theories and practice of using   |
+         :            :        :                                  :         : educational technologies to      :
+         :            :        :                                  :         : support problem-based learning.  :
+         | edpol      |    313 | Technology, Society and Schools  |       3 | Examination of theories and      |
+         :            :        :                                  :         : history of interaction of        :
+         :            :        :                                  :         : society and technology with      :
+         :            :        :                                  :         : implications for instructional   :
+         :            :        :                                  :         : technology and schooling.        :
+         :            :        :                                  :         : Resources for constructing       :
+         :            :        :                                  :         : personal definitions of          :
+         :            :        :                                  :         : technology.                      :
+         | edpol      |    505 | Qualitative Research for         |       3 | This course provides an          |
+         :            :        : Educators                        :         : introduction to qualitative      :
+         :            :        :                                  :         : research at the Master level.    :
+         | edpol      |    551 | Classroom Visit                  |         | Elective visit to a local        |
+         :            :        :                                  :         : classroom for observation.       :
+         | edpol      |    617 | Educational Policy Analysis      |       3 | Frameworks for analyzing,        |
+         :            :        :                                  :         : designing policy proposals, and  :
+         :            :        :                                  :         : implementing plans.              :
+         | ee         |    107 | Exploration of Electrical        |       3 | "Exploration of electrical       |
+         :            :        : Engineering                      :         : 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         |    412 | Laboratory in Electrical         |       4 | Hands-on experience covering     |
+         :            :        : Engineering                      :         : areas of optical transforms,     :
+         :            :        :                                  :         : electro-optics devices, signal   :
+         :            :        :                                  :         : processing, fiber optics         :
+         :            :        :                                  :         : transmission, and holography.    :
+         | 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.                     :
+         | eng        |    101 | Introduction to Composition      |       3 | Provides students with the       |
+         :            :        :                                  :         : fundamental skills to read,      :
+         :            :        :                                  :         : interpret, and write critically  :
+         :            :        :                                  :         : at the college level.            :
+         | eng        |    175 | College Newspaper                |       2 | Students will perform            |
+         :            :        :                                  :         : journalistic writing exercises   :
+         :            :        :                                  :         : for publication in the college   :
+         :            :        :                                  :         : newspaper.                       :
+         | 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        |    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        |    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        |    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.        :
+         | hist       |    112 | The United States in World       |       3 | Examines the meaning of empire   |
+         :            :        : History                          :         : in relationship to the           :
+         :            :        :                                  :         : historical development of the    :
+         :            :        :                                  :         : United States of America.        :
+         | hist       |    212 | Historical Perspective on the    |       3 | This course covers the           |
+         :            :        : Constitution                     :         : development of the               :
+         :            :        :                                  :         : constitutional doctrine from     :
+         :            :        :                                  :         : 1787 to the present. The         :
+         :            :        :                                  :         : Constitution as an experiment in :
+         :            :        :                                  :         : Republicanism.                   :
+         | 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       |    415 | History of the Family in Global  |       3 | Has the family really declined?  |
+         :            :        : Perspective                      :         : 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       |    505 | Science and History              |       3 | Introduces students to           |
+         :            :        :                                  :         : approaches and methods in the    :
+         :            :        :                                  :         : history of science, technology,  :
+         :            :        :                                  :         : and medicine                     :
+         | 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       |    207 | Child Second Language            |       3 | Examines issues in child second  |
+         :            :        : Development                      :         : language acquisition, including  :
+         :            :        :                                  :         : the critical period hypothesis   :
+         :            :        :                                  :         : and universal grammar.           :
+         | 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.                 :
+         | me         |    111 | Introduction to Mechanical       |       3 | Topics include an overview of    |
+         :            :        : Engineering                      :         : career opportunities, problem    :
+         :            :        :                                  :         : solving processes, an            :
+         :            :        :                                  :         : introduction to the basic        :
+         :            :        :                                  :         : engineering design process,      :
+         :            :        :                                  :         : professionalism, professional    :
+         :            :        :                                  :         : registration, and ethics.        :
+         | me         |    344 | Undergraduate Research           |       4 | Undergraduates will conduct      |
+         :            :        :                                  :         : independent research activities  :
+         :            :        :                                  :         : under the direction of their     :
+         :            :        :                                  :         : major adviser.                   :
+         | 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         |       4 | Open to juniors and seniors.     |
+         :            :        : Conditioning                     :         : Requires permission of           :
+         :            :        :                                  :         : instructor.                      :
+         | me         |    712 | Graphic Communication and Design |       3 | Sketching and orthographic       |
+         :            :        :                                  :         : projection. Covers detail and    :
+         :            :        :                                  :         : assembly working drawings,       :
+         :            :        :                                  :         : dimensioning, tolerance          :
+         :            :        :                                  :         : specification, and design        :
+         :            :        :                                  :         : projects.                        :
+         | 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.  :
+         | 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       |    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.    :
+         | 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       |    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       |    402 | Government Internship: Semester  |       4 | Junior or seniors with a 3.0     |
+         :            :        : in Washington                    :         : 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          |       3 | This course will examine the     |
+         :            :        : Corporate Interests              :         : methods by which American        :
+         :            :        :                                  :         : business exert influence over    :
+         :            :        :                                  :         : legislators and the legislative  :
+         :            :        :                                  :         : process.                         :
+         | poli       |    644 | Research Seminar in Middle       |       3 | Government and Politics of the   |
+         :            :        : Eastern Affairs                  :         : 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              :
+         | 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        |       3 | An introduction to the basic     |
+         :            :        : Psychology                       :         : concepts of cognitive            :
+         :            :        :                                  :         : psychology, including areas such :
+         :            :        :                                  :         : as perception, attention,        :
+         :            :        :                                  :         : memory, language, and thought.   :
+         | psych      |    450 | Laboratory in Applied Behavioral |       4 | This course will provide         |
+         :            :        : Science                          :         : students with hands-on training  :
+         :            :        :                                  :         : in the application of behavioral :
+         :            :        :                                  :         : research technology to a         :
+         :            :        :                                  :         : clinical population.             :
+         | psych      |    560 | Examination of Real-Time         |       4 | This lab course examines methods |
+         :            :        : Language Processing              :         : 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.                  :
+         | tched      |    122 | Theory and Practice of Early     |       3 | Emphasis on the skills and       |
+         :            :        : Childhood Education              :         : processes needed for the design  :
+         :            :        :                                  :         : and implementation of optimal    :
+         :            :        :                                  :         : learning environments.           :
+         :            :        :                                  :         : Exploration of issues related to :
+         :            :        :                                  :         : societal and cultural influences :
+         :            :        :                                  :         : on the education of young        :
+         :            :        :                                  :         : children.                        :
+         | tched      |    155 | Methods of Early Science         |       3 | A study of the curriculum        |
+         :            :        : Education                        :         : methods, concepts, techniques,   :
+         :            :        :                                  :         : and materials in the teaching of :
+         :            :        :                                  :         : general science to children in   :
+         :            :        :                                  :         : the early grades.                :
+         | tched      |    367 | Problems in Education Management |       3 | This course is designed to       |
+         :            :        :                                  :         : assist the student to prepare    :
+         :            :        :                                  :         : for management of educational    :
+         :            :        :                                  :         : organizations and programs.      :
+         :            :        :                                  :         : Emphasis will be placed upon     :
+         :            :        :                                  :         : identifying specific problems    :
+         :            :        :                                  :         : and developing specific          :
+         :            :        :                                  :         : techniques by which to solve     :
+         :            :        :                                  :         : them.                            :
+         | tched      |    501 | Challenges of Teaching the       |       3 | The nature and needs of the      |
+         :            :        : Gifted and Talented              :         : talented and gifted in all areas :
+         :            :        :                                  :         : of development are explored.     :
+         | tched      |    609 | Supervised Internship in         |       4 | Supervised Internship I provides |
+         :            :        : Education                        :         : on-site, supervised              :
+         :            :        :                                  :         : instructional experience within  :
+         :            :        :                                  :         : a public school setting under    :
+         :            :        :                                  :         : the leadership of an             :
+         :            :        :                                  :         : appropriate, competent           :
+         :            :        :                                  :         : professional.                    :
+                                                                                                      (100 rows)
 
-       ----
-       /test
-  - uri: /test
-    status: 200 OK
-    headers:
-    - [Content-Type, text/html; charset=UTF-8]
-    body: |
-      <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
-      <html>
-      <head>
-      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
-      <title>/test</title>
-      <style type="text/css">
-      body { font-family: sans-serif; font-size: 90%; color: #515151; background: #ffffff }
-      a:link, a:visited { color: #1f4884; text-decoration: none }
-      a:hover { text-decoration: underline }
-      table { border-collapse: collapse; margin: 0.5em auto; width: 100% }
-      table, tr { border-style: solid; border-width: 0 }
-      td, th { padding: 0.2em 0.5em; vertical-align: top; text-align: left }
-      div.tab { position: relative; left: -1px; margin-right: 60%; padding: 0.2em 0.5em; background: #ffffff; border-style: solid; border-width: 5px 1px 0; border-top-left-radius: 10px; border-top-right-radius: 10px; -moz-border-radius-topleft: 10px; -moz-border-radius-topright: 10px; -webkit-border-top-left-radius: 10px; -webkit-border-top-right-radius: 10px }
-      table.page { border: 0; padding: 1em; width: auto }
-      tr.content { padding: 1em 1em 0.5em }
-      tr.footer { padding: 0 1em 1em; text-align: left; font-style: italic }
-      table.chart .number { text-align: right }
-      tr.caption { font-size: 105%; background: transparent }
-      tr.caption th { padding: 0 }
-      div.tab { border-color: #6f9ad3 #c3c3c3 }
-      tr.header { background: #dae3ea; border-color: #c3c3c3; border-width: 1px 1px 0 }
-      tr.odd { background: #ffffff; border-color: #c3c3c3; border-width: 0 1px }
-      tr.even { background: #f2f2f2; border-color: #c3c3c3; border-width: 0 1px }
-      tr.odd:hover, tr.even:hover { background: #ffe3bd }
-      tr.total { background: transparent;border-color: #c3c3c3; border-width: 1px 0 0 }
-      tr.total td { text-align: right; font-size: 75%; font-style: italic; padding: 0.3em 0.5em 0 }
-      table.void { text-align: center; border-color: #c3c3c3; border-width: 1px 0 }
-      </style>
-      </head>
-      <body>
-      <table class="page" summary="/test">
-      <tr>
-      <td class="content">
-      <table class="chart" summary="test">
-      <tr class="caption"><th colspan="2"><div class="tab">test</div></th></tr>
-      <tr class="header"><th class="number">id</th><th>data</th></tr>
-      <tr class="odd"><td class="number">1</td><td>one</td></tr>
-      <tr class="even"><td class="number">2</td><td>two</td></tr>
-      <tr class="odd"><td class="number">3</td><td>three</td></tr>
-      <tr class="total"><td colspan="2">(3 rows)</td></tr></table></td>
-      </tr>
-      <tr><td class="footer">/test</td></tr>
-      </table>
-      </body>
-      </html>
-  - uri: /test{data}?id=1
-    status: 200 OK
-    headers:
-    - [Content-Type, text/plain]
-    body: |
-      /test{data}?id=1
+         ----
+         /course
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" ORDER BY 1 ASC, 2 ASC
+    - uri: /instructor
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | instructor                                                                        |
+        -+-----------------------------------------------------------------------------------+-
+         | code         | title | full_name            | phone    | email                    |
+        -+--------------+-------+----------------------+----------+--------------------------+-
+         | acaspar      | dr    | Alesia Caspar        |          |                          |
+         | afrenski     | mr    | Andre Frenski        | 555-1723 | afrenski@example.com     |
+         | alang42      | prof  | Adrian Laang         | 555-0973 | alang42@example.com      |
+         | amiller213   | ms    | Antoinette Miller    | 555-7728 | amiller213@example.com   |
+         | anabib       | prof  | Ashish Nabib         | 555-1667 | anabib@example.com       |
+         | asacco       | prof  | Andrea Sacco         | 555-1381 | asacco@example.com       |
+         | astone77     | mr    | Alan P. Stone        | 555-1738 | astone77@example.com     |
+         | bburling     | prof  | Benjamin Burling     | 555-1823 | bburling@example.com     |
+         | bsacks66     | prof  | Benjamin Sacks       | 555-2212 | bsacks66@example.com     |
+         | cfergus12    | prof  | Adam Ferguson        |          | cfergus12@example.com    |
+         | dbundt31     | dr    | David Bundt          | 555-1553 | dbundt31@example.com     |
+         | dfallon23    | prof  | David N. Fallon      | 555-1666 | dfallon23@example.com    |
+         | dsims51      | mr    | Dante Sims           |          | dsims51@example.com      |
+         | egasner      | dr    | Ernst Gasner         | 555-6652 | egasner@example.com      |
+         | elhill4      | dr    | Ellen Last Hill      | 555-1995 | ehill4@example.com       |
+         | emurphy55    | prof  | Erin L. Murphy       |          | emurphy55@example.com    |
+         | evargas112   | prof  | Elena Vargas         | 555-1572 | evargas112@example.com   |
+         | hbarone      | prof  | Harold Barone        | 555-0911 | hbarone@example.com      |
+         | hbenmahem    | mr    | Hani Ben-Mahem       | 555-1827 | hbenmahem@example.com    |
+         | icampbell12  | prof  | Ian W. Campbell      | 555-2275 | icampbell12@example.com  |
+         | jconnell51   | dr    | Jamie Connell        | 555-2157 | jconnell51@example.com   |
+         | jflug29      | dr    | Jason Flug           | 555-6672 | jflug23@example.com      |
+         | kcavallaro   | prof  | Katherine Cavallaro  | 555-4325 | kvallaro@example.com     |
+         | kmaas11      | prof  | Kari Maas            | 555-1027 | kmaas11@example.com      |
+         | kmarkman     | ms    | Kristen Maison       |          | kmarkman@example.com     |
+         | kmurray44    | mr    | Kevin Murray         | 555-1753 | kmurray44@example.com    |
+         | lbrooks61    | prof  | Lynn L. Brooks       | 555-8872 | lbrooks61@example.com    |
+         | lmcooper11   | prof  | Louisa M. Cooper     | 555-2112 | lmscooper11@example.com  |
+         | mbyer55      | prof  | Michael L. Byer      | 555-1287 |                          |
+         | mcardana     | prof  | Maximo Cardana       | 555-1738 | mcardana@example.com     |
+         | mscott51     | prof  | Mindy Scott          | 555-3521 | mscott51@example.com     |
+         | pblum21      | ms    | Petra Blum           | 555-2873 | pblum21@example.com      |
+         | rrosenfeld31 | ms    | Rebecca L. Rosenfeld | 555-8816 | rrosenfeld31@example.com |
+         | sbadhreya    | prof  | Said Badhreya        | 555-2873 | sbadhreya@example.com    |
+         | sbyrne202    | ms    | Susan Byrne          | 555-9002 |                          |
+         | srandrews    | mr    | Stuart Andrews       | 555-2113 | srandrews@example.com    |
+         | tobrien21    | prof  | Timothy O'Brien      |          | tobrien21@example.com    |
+         | vball77      | ms    | Vivienne Ball        | 555-2830 |                          |
+         | wyu112       | mr    | Walter Yu            | 555-2954 | wyu112@example.com       |
+                                                                                     (39 rows)
+
+         ----
+         /instructor
+         SELECT "instructor"."code", "instructor"."title", "instructor"."full_name", "instructor"."phone", "instructor"."email" FROM "id"."instructor" AS "instructor" ORDER BY 1 ASC
+    - uri: /confidential
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | confidential                                           |
+        -+--------------------------------------------------------+-
+         | instructor   | ssn         | pay_grade | home_phone    |
+        -+--------------+-------------+-----------+---------------+-
+         | afrenski     | 987-65-4321 |         4 |               |
+         | alang42      | 788-33-0000 |         6 | 702-555-1721  |
+         | amiller213   | 987-65-4324 |         7 | 452-555-7728  |
+         | anabib       | 787-22-0000 |         7 | 702-55-1627   |
+         | asacco       | 783-78-0000 |         5 | 702-555-1692  |
+         | astone77     | 688-33-0000 |         8 | 702-555-0173  |
+         | bburling     | 672-88-0000 |         5 |               |
+         | bsacks66     | 782-78-0000 |         7 | 202-555-7283  |
+         | cfergus12    | 987-65-4320 |         6 | 702-555-1738  |
+         | dbundt31     | 000-53-2873 |         7 | 202-555-1738  |
+         | dfallon23    | 274-66-0000 |         4 | 702-555-1778  |
+         | dsims51      | 987-65-4325 |         5 | 452-555-9273  |
+         | egasner      | 784-44-0000 |         8 | 702-555-8995  |
+         | elhill4      | 933-55-0000 |         4 | 702-555-8829  |
+         | emurphy55    | 787-22-0000 |         8 | 452-555-7849  |
+         | hbarone      | 511-66-0000 |         4 | 702-555-1089  |
+         | hbenmahem    | 674-57-0000 |         4 | 702-555-0115  |
+         | icampbell12  | 000-52-8758 |         5 |               |
+         | jconnell51   | 717-67-0000 |         8 | 702-555-1672  |
+         | jflug29      | 578-41-0000 |         6 | 702-555-7727  |
+         | kcavallaro   | 123-74-0000 |         5 | 702-555-1670  |
+         | kmaas11      | 371-55-0000 |         7 | 702-555-1875  |
+         | kmarkman     | 000-72-1875 |         4 | 702-555-8211  |
+         | kmurray44    | 152-62-0000 |         7 | 702-555-6612  |
+         | lbrooks61    | 673-11-0000 |         8 | 452-555-7276  |
+         | lmcooper11   | 987-65-4329 |         8 | 702-555-9992  |
+         | mbyer55      | 000-22-4320 |         6 | 452-555-7311  |
+         | mscott51     | 126-33-0000 |         7 | 702-555-7819  |
+         | pblum21      | 000-33-2783 |         5 | 702-555-6522  |
+         | rrosenfeld31 | 857-22-0000 |         7 | 702-555-0989  |
+         | sbadhreya    | 987-65-4328 |         4 | 702-555-66738 |
+         | sbyrne202    | 987-65-4327 |         5 | 617-555-8382  |
+         | srandrews    | 987-65-4326 |         8 | 702-555-3627  |
+         | tobrien21    | 000-38-2875 |         4 |               |
+         | vball77      | 799-11-0000 |         4 | 702-555-1425  |
+         | wyu112       | 987-65-4323 |         5 | 702-555-2954  |
+                                                          (36 rows)
+
+         ----
+         /confidential
+         SELECT "confidential"."instructor", "confidential"."ssn", "confidential"."pay_grade", "confidential"."home_phone" FROM "id"."confidential" AS "confidential" ORDER BY 1 ASC
+    - uri: /appointment
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | appointment                         |
+        -+-------------------------------------+-
+         | department | instructor   | percent |
+        -+------------+--------------+---------+-
+         | acc        | dfallon23    |    1.00 |
+         | arthis     | emurphy55    |    0.50 |
+         | arthis     | icampbell12  |    1.00 |
+         | artstd     | acaspar      |    1.00 |
+         | artstd     | egasner      |    1.00 |
+         | astro      | asacco       |         |
+         | astro      | cfergus12    |    0.50 |
+         | astro      | kmaas11      |         |
+         | be         | hbarone      |    0.50 |
+         | be         | pblum21      |    0.50 |
+         | capmrk     | jflug29      |    1.00 |
+         | chem       | bsacks66     |    1.00 |
+         | chem       | evargas112   |    1.00 |
+         | chem       | hbenmahem    |    0.50 |
+         | comp       | anabib       |    0.50 |
+         | comp       | sbadhreya    |    1.00 |
+         | corpfi     | astone77     |    1.00 |
+         | edpol      | kmarkman     |    1.00 |
+         | edpol      | rrosenfeld31 |    1.00 |
+         | ee         | alang42      |    1.00 |
+         | ee         | lmcooper11   |    1.00 |
+         | eng        | mcardana     |         |
+         | eng        | wyu112       |    0.50 |
+         | hist       | dsims51      |    0.50 |
+         | hist       | vball77      |    1.00 |
+         | lang       | amiller213   |    1.00 |
+         | lang       | jconnell51   |    1.00 |
+         | me         | kcavallaro   |    1.00 |
+         | me         | mbyer55      |    1.00 |
+         | phys       | afrenski     |    1.00 |
+         | phys       | bburling     |    1.00 |
+         | phys       | mscott51     |    1.00 |
+         | poli       | lbrooks61    |    0.50 |
+         | poli       | sbyrne202    |    1.00 |
+         | psych      | kmurray44    |    1.00 |
+         | psych      | srandrews    |    1.00 |
+         | tched      | dbundt31     |    0.50 |
+         | tched      | elhill4      |    1.00 |
+                                       (38 rows)
+
+         ----
+         /appointment
+         SELECT "appointment"."department", "appointment"."instructor", "appointment"."percent" FROM "id"."appointment" AS "appointment" ORDER BY 1 ASC, 2 ASC
+    - uri: /semester
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | semester                                |
+        -+-----------------------------------------+-
+         | year | season | begin_date | end_date   |
+        -+------+--------+------------+------------+-
+         | 2009 | fall   | 2009-08-15 | 2009-12-31 |
+         | 2009 | spring | 2010-01-01 | 2010-05-15 |
+         | 2009 | summer | 2010-06-01 | 2010-08-01 |
+         | 2010 | fall   | 2010-08-15 | 2010-12-31 |
+         | 2010 | spring | 2011-01-01 | 2011-05-15 |
+         | 2010 | summer | 2011-06-01 | 2011-08-01 |
+         | 2011 | fall   | 2011-08-15 | 2011-12-31 |
+         | 2011 | spring | 2012-01-01 | 2012-05-15 |
+         | 2011 | summer | 2012-06-01 | 2012-08-01 |
+         | 2012 | fall   | 2012-08-15 | 2012-12-31 |
+         | 2012 | spring | 2013-01-01 | 2013-05-15 |
+         | 2012 | summer | 2013-06-01 | 2013-08-01 |
+                                           (12 rows)
+
+         ----
+         /semester
+         SELECT "semester"."year", "semester"."season", "semester"."begin_date", "semester"."end_date" FROM "cd"."semester" AS "semester" ORDER BY 1 ASC, 2 ASC
+    - uri: /class
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | class                                                                    |
+        -+--------------------------------------------------------------------------+-
+         | department | course | year | season | section | instructor   | class_seq |
+        -+------------+--------+------+--------+---------+--------------+-----------+-
+         | acc        |    200 | 2010 | summer | 001     | dfallon23    |     10086 |
+         | acc        |    315 | 2011 | fall   | 003     | dfallon23    |     10087 |
+         | acc        |    426 | 2011 | fall   | 001     | dfallon23    |     10088 |
+         | acc        |    527 | 2011 | spring | 001     | dfallon23    |     10089 |
+         | acc        |    606 | 2011 | spring | 001     | dfallon23    |     10090 |
+         | arthis     |    202 | 2011 | fall   | 003     | emurphy55    |     10063 |
+         | arthis     |    340 | 2011 | spring | 001     | icampbell12  |     10065 |
+         | arthis     |    623 | 2009 | fall   | 002     | icampbell12  |     10068 |
+         | arthis     |    710 | 2011 | spring | 001     | emurphy55    |     10066 |
+         | arthis     |    712 | 2011 | fall   | 001     | icampbell12  |     10064 |
+         | arthis     |    809 | 2011 | summer | 001     | emurphy55    |     10067 |
+         | artstd     |    333 | 2010 | spring | 001     | acaspar      |     10073 |
+         | artstd     |    411 | 2009 | spring | 002     | acaspar      |     10069 |
+         | artstd     |    509 | 2012 | summer | 001     | acaspar      |     10072 |
+         | artstd     |    512 | 2010 | fall   | 001     | egasner      |     10070 |
+         | artstd     |    614 | 2009 | summer | 003     | egasner      |     10071 |
+         | astro      |    137 | 2009 | fall   | 001     | egasner      |     10001 |
+         | astro      |    142 | 2009 | spring | 001     | asacco       |     10002 |
+         | astro      |    155 | 2010 | fall   | 001     | cfergus12    |     10003 |
+         | astro      |    254 | 2009 | summer | 002     | cfergus12    |     10004 |
+         | be         |    112 | 2011 | spring | 001     | hbarone      |     10059 |
+         | be         |    308 | 2011 | summer | 002     | hbarone      |     10060 |
+         | be         |    415 | 2010 | spring | 002     | pblum21      |     10061 |
+         | be         |    509 | 2012 | summer | 001     | pblum21      |     10062 |
+         | capmrk     |    712 | 2011 | summer | 001     | jflug29      |     10091 |
+         | capmrk     |    756 | 2011 | spring | 001     | jflug29      |     10094 |
+         | capmrk     |    808 | 2012 | summer | 002     | jflug29      |     10092 |
+         | capmrk     |    818 | 2010 | spring | 002     | jflug29      |     10093 |
+         | chem       |    100 | 2010 | fall   | 002     | bsacks66     |     10005 |
+         | chem       |    110 | 2010 | spring | 001     | evargas112   |     10006 |
+         | chem       |    115 | 2012 | summer | 003     | hbenmahem    |     10007 |
+         | chem       |    314 | 2011 | fall   | 001     | evargas112   |     10008 |
+         | chem       |    655 | 2011 | fall   | 001     | bsacks66     |     10009 |
+         | comp       |    102 | 2010 | spring | 001     | anabib       |     10042 |
+         | comp       |    230 | 2010 | summer | 001     | anabib       |     10043 |
+         | comp       |    350 | 2011 | fall   | 002     | sbadhreya    |     10044 |
+         | comp       |    615 | 2011 | fall   | 002     | sbadhreya    |     10045 |
+         | comp       |    710 | 2011 | spring | 001     | sbadhreya    |     10046 |
+         | comp       |    810 | 2011 | spring | 003     | anabib       |     10047 |
+         | comp       |    819 | 2011 | summer | 001     | anabib       |     10048 |
+         | corpfi     |    234 | 2009 | summer | 001     | astone77     |     10083 |
+         | corpfi     |    404 | 2010 | fall   | 002     | astone77     |     10084 |
+         | corpfi     |    601 | 2012 | summer | 002     | astone77     |     10085 |
+         | edpol      |    202 | 2012 | fall   | 003     | kmarkman     |     10079 |
+         | edpol      |    313 | 2009 | fall   | 001     | kmarkman     |     10080 |
+         | edpol      |    505 | 2009 | spring | 001     | rrosenfeld31 |     10081 |
+         | edpol      |    617 | 2010 | fall   | 001     | rrosenfeld31 |     10082 |
+         | ee         |    107 | 2009 | fall   | 001     | alang42      |     10049 |
+         | ee         |    202 | 2012 | spring | 001     | alang42      |     10050 |
+         | ee         |    412 | 2010 | fall   | 001     | lmcooper11   |     10051 |
+         | ee         |    505 | 2009 | summer | 002     | alang42      |     10052 |
+         | ee         |    615 | 2010 | fall   | 002     | lmcooper11   |     10053 |
+         | eng        |    101 | 2009 | summer | 001     | mcardana     |     10016 |
+         | eng        |    175 | 2010 | summer | 001     | wyu112       |     10019 |
+         | eng        |    247 | 2010 | fall   | 001     | wyu112       |     10017 |
+         | eng        |    276 | 2012 | fall   | 002     | mcardana     |     10020 |
+         | eng        |    311 | 2010 | spring | 001     | wyu112       |     10018 |
+         | eng        |    412 | 2011 | fall   | 002     | mcardana     |     10021 |
+         | hist       |    112 | 2011 | spring | 001     | dsims51      |     10022 |
+         | hist       |    212 | 2011 | spring | 003     | vball77      |     10023 |
+         | hist       |    333 | 2009 | spring | 001     | dsims51      |     10026 |
+         | hist       |    415 | 2012 | fall   | 001     | dsims51      |     10024 |
+         | hist       |    505 | 2009 | fall   | 001     | vball77      |     10025 |
+         | lang       |    201 | 2010 | fall   | 001     | amiller213   |     10027 |
+         | lang       |    203 | 2012 | spring | 002     | amiller213   |     10028 |
+         | lang       |    207 | 2010 | spring | 001     | jconnell51   |     10030 |
+         | lang       |    304 | 2010 | fall   | 002     | jconnell51   |     10029 |
+         | lang       |    305 | 2010 | summer | 003     | jconnell51   |     10031 |
+         | me         |    111 | 2010 | spring | 001     | kcavallaro   |     10054 |
+         | me         |    344 | 2010 | summer | 003     | kcavallaro   |     10055 |
+         | me         |    501 | 2012 | fall   | 001     | mbyer55      |     10056 |
+         | me         |    627 | 2011 | fall   | 001     | mbyer55      |     10057 |
+         | me         |    712 | 2011 | spring | 001     | mbyer55      |     10058 |
+         | phys       |    211 | 2011 | spring | 001     | afrenski     |     10010 |
+         | phys       |    303 | 2012 | fall   | 001     | bburling     |     10011 |
+         | phys       |    388 | 2011 | summer | 002     | mscott51     |     10012 |
+         | phys       |    512 | 2009 | fall   | 002     | afrenski     |     10013 |
+         | phys       |    713 | 2009 | spring | 001     | bburling     |     10014 |
+         | phys       |    819 | 2010 | fall   | 003     | bsacks66     |     10015 |
+         | poli       |    113 | 2009 | fall   | 002     | lbrooks61    |     10037 |
+         | poli       |    347 | 2012 | spring | 001     | lbrooks61    |     10038 |
+         | poli       |    402 | 2010 | fall   | 003     | sbyrne202    |     10039 |
+         | poli       |    431 | 2010 | fall   | 001     | sbyrne202    |     10041 |
+         | poli       |    644 | 2009 | summer | 001     | sbyrne202    |     10040 |
+         | psych      |    102 | 2011 | fall   | 001     | kmurray44    |     10032 |
+         | psych      |    304 | 2011 | fall   | 001     | srandrews    |     10033 |
+         | psych      |    450 | 2011 | spring | 001     | srandrews    |     10034 |
+         | psych      |    560 | 2012 | fall   | 001     | kmurray44    |     10035 |
+         | psych      |    610 | 2011 | summer | 002     | kmurray44    |     10036 |
+         | tched      |    122 | 2010 | summer | 001     | dbundt31     |     10074 |
+         | tched      |    155 | 2011 | fall   | 001     | elhill4      |     10075 |
+         | tched      |    367 | 2011 | fall   | 002     | elhill4      |     10076 |
+         | tched      |    501 | 2011 | spring | 002     | dbundt31     |     10077 |
+         | tched      |    609 | 2011 | spring | 001     | dbundt31     |     10078 |
+                                                                            (94 rows)
+
+         ----
+         /class
+         SELECT "class"."department", "class"."course", "class"."year", "class"."season", "class"."section", "class"."instructor", "class"."class_seq" FROM "cd"."class" AS "class" ORDER BY 1 ASC, 2 ASC, 3 ASC, 4 ASC, 5 ASC
+    - uri: /student
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: " | student                                                                                            |\n-+----------------------------------------------------------------------------------------------------+-\n
+        | number | name                   | gender | dob        | school | program
+        \ | start_date | is_active |\n-+--------+------------------------+--------+------------+--------+----------+------------+-----------+-\n
+        |  12328 | Karen Yuen             | f      | 1991-09-10 | ns     | uphys    |
+        2007-05-16 | true      |\n |  12738 | Helmut Dietmark        | m      | 1989-11-27
+        | edu    | psci     | 2008-03-17 | true      |\n |  12837 | Christine Leung
+        \       | f      | 1991-06-06 | egn    | gme      | 2009-08-17 | true      |\n
+        |  13723 | Narissa Maya           | f      | 1992-04-30 | la     | upsych
+        \  | 2007-11-21 | false     |\n |  17283 | Lucy Ryong             | f      |
+        1988-01-25 | edu    | gedu     | 2009-01-27 | true      |\n |  17385 | Valeria
+        Rinaldi        | f      | 1985-09-02 | bus    | pcap     | 2004-09-01 | false
+        \    |\n |  20927 | Glenn L. McNair        | m      | 1987-12-13 | egn    |
+        gee      | 2009-08-23 | true      |\n |  21135 | Luis Riviera Espinoza  |
+        m      | 1993-05-21 | egn    | gbe      | 2010-02-19 | true      |\n |  21166
+        | Laura Elmer Long       | f      | 1991-02-14 | ns     | uastro   | 2009-01-31
+        | true      |\n |  21263 | Ari Ben David          | m      | 1989-03-15 |
+        la     | gengl    | 2006-12-15 | true      |\n |  21837 | Jalene Flambeau
+        \       | f      | 1989-03-23 | art    | gart     | 2010-06-11 | true      |\n
+        |  22313 | James Earl Sims III    | m      | 2002-07-06 | egn    | umech    |
+        2004-08-16 | true      |\n |  23137 | Rachel Feld            | f      | 1992-09-27
+        | ns     | uchem    | 2008-12-23 | true      |\n |  23817 | Benjamin Wen           |
+        m      | 1993-12-16 | la     | uhist    | 2009-01-12 | true      |\n |  24431
+        | Annette Dupree         | f      | 1987-01-28 | egn    | umech    | 2006-01-16
+        | true      |\n |  24672 | Mahesh Basa            | m      | 1995-08-21 |
+        egn    | ucompsci | 2008-04-15 | false     |\n |  25371 | John L. Hanley         |
+        m      | 1990-04-28 | egn    | gbuseng  | 2009-07-15 | true      |\n |  25723
+        | Kumar Suresh           | m      | 1994-09-11 | egn    | ucompsci | 2009-08-23
+        | true      |\n |  26743 | Ulf Knudsen            | m      | 1990-11-14 |
+        ns     | uphys    | 2008-04-27 | true      |\n |  26764 | Bernard Careval
+        \       | m      | 1992-08-23 | art    | gart     | 2008-07-30 | true      |\n
+        |  27138 | Artem Karpov           | m      | 1991-10-16 | egn    | gbe      |
+        2009-08-22 | true      |\n |  27281 | Jos\xE9 N. Marte\xF1es       | m      |
+        1993-11-19 | egn    | ucompsci | 2007-06-15 | true      |\n |  27817 | Niall
+        Crawford         | m      | 1998-12-14 | bus    | pacc     | 2010-01-02 |
+        true      |\n |  28371 | Ken Tanaka             | m      | 1992-11-03 | art
+        \   | gart     | 2010-09-08 | true      |\n |  28382 | Martha O'Mally         |
+        f      | 1995-05-14 | bus    | pacc     | 2005-01-01 | true      |\n |  29301
+        | Eduardo Serrano        | m      | 1991-09-09 | art    | uhist    | 2006-01-14
+        | true      |\n |  29878 | Ellen Lansburgh        | f      | 1992-02-01 |
+        bus    | uacct    | 2008-01-05 | true      |\n |  31331 | Khadija Hamad Azzan
+        \   | f      | 1992-11-26 | ns     | uastro   | 2008-09-21 | false     |\n
+        |  31332 | Dara Subramanya        | f      | 1994-11-16 | la     | upsych
+        \  | 2008-09-10 | true      |\n |  31735 | Demetrios Kanakis      | m      |
+        1995-04-17 | egn    | ucompsci | 2009-05-21 | true      |\n |  31835 | Paavo
+        Kekkonen         | m      | 2000-09-08 | ns     | uphys    | 2008-06-11 |
+        true      |\n |  32214 | Joseph Tan             | m      | 1992-08-01 | egn
+        \   | gbuseng  | 2008-01-06 | true      |\n |  32711 | Peter Zajac Jr.        |
+        m      | 1994-01-23 | bus    | ucorpfi  | 2009-09-10 | true      |\n |  32718
+        | Raisa Antonov          | f      | 1992-12-09 | egn    | gbe      | 2008-09-15
+        | false     |\n |  33278 | Andrea Kaminski        | f      | 1981-04-20 |
+        bus    | pcap     | 2009-01-15 | true      |\n |  35163 | Nicola Ralls Jr.
+        \      | f      | 1993-06-02 | bus    | uacct    | 2010-01-12 | true      |\n
+        |  35183 | Teisha Worth Day       | f      | 1983-12-31 | edu    | gedlead
+        \ | 2009-08-21 | true      |\n |  35523 | Nikki Agbo             | m      |
+        1985-05-05 | la     | gengl    | 2006-02-25 | true      |\n |  35572 | Corinna
+        Ellis          | f      | 1995-07-22 | edu    | glited   | 2007-05-14 | true
+        \     |\n |  36446 | Milton Mahanga         | m      | 1991-11-06 | art    |
+        gart     | 2009-05-05 | true      |\n |  37182 | Amy Yang               |
+        f      | 1992-12-17 | ns     | uphys    | 2002-08-10 | false     |\n |  37278
+        | Ming Wang              | m      | 1988-03-15 | la     | gengl    | 2002-11-27
+        | false     |\n |  37283 | Janine Sylvia          | f      | 1993-12-02 |
+        ns     | uastro   | 2009-08-14 | true      |\n |  37744 | Scott Blank            |
+        m      | 1988-06-12 | bus    | ucorpfi  | 2007-12-15 | true      |\n |  37855
+        | Amina N. Elsaeed       | f      | 1987-10-29 | la     | uhist    | 2005-09-02
+        | true      |\n |  38187 | Mary Ann Flenderson    | f      | 1993-05-16 |
+        ns     | uphys    | 2010-08-26 | true      |\n |  38721 | Alicia Montez-Galliano
+        | f      | 1994-07-11 | ns     | uchem    | 2010-09-10 | true      |\n |  38794
+        | Bailey Melvin          | m      | 1988-03-13 | la     | psciwri  | 2005-04-20
+        | true      |\n |  43278 | Trina Wood Campbell    | f      | 1990-02-12 |
+        egn    | gme      | 2007-09-01 | true      |\n |  57382 | Paul Duncan Ulam
+        \      | m      | 2001-05-05 | la     | uspan    | 2009-05-21 | true      |\n
+        |  92039 | Syed Ishaq             | m      | 1992-10-23 | art    | gart     |
+        2010-09-02 | true      |\n                                                                                              (51
+        rows)\n\n ----\n /student\n SELECT \"student\".\"number\", \"student\".\"name\",
+        \"student\".\"gender\", \"student\".\"dob\", \"student\".\"school\", \"student\".\"program\",
+        \"student\".\"start_date\", \"student\".\"is_active\" FROM \"ed\".\"student\"
+        AS \"student\" ORDER BY 1 ASC\n"
+    - uri: /enrollment
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | enrollment                       |
+        -+----------------------------------+-
+         | student | class | status | grade |
+        -+---------+-------+--------+-------+-
+         |   25371 | 10051 | enr    |  3.70 |
+         |   25371 | 10086 | ngr    |       |
+         |   29878 | 10086 | inc    |       |
+         |   37278 | 10018 | enr    |  2.60 |
+         |   92039 | 10071 | enr    |  3.10 |
+                                     (5 rows)
+
+         ----
+         /enrollment
+         SELECT "enrollment"."student", "enrollment"."class", "enrollment"."status", "enrollment"."grade" FROM "ed"."enrollment" AS "enrollment" ORDER BY 1 ASC, 2 ASC
+    - uri: /prerequisite
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | prerequisite                                          |
+        -+-------------------------------------------------------+-
+         | of_department | of_course | on_department | on_course |
+        -+---------------+-----------+---------------+-----------+-
+         | acc           |       527 | acc           |       200 |
+         | arthis        |       710 | arthis        |       202 |
+         | artstd        |       614 | artstd        |       333 |
+         | astro         |       142 | astro         |       137 |
+         | be            |       415 | be            |       112 |
+         | capmrk        |       818 | acc           |       315 |
+         | chem          |       110 | chem          |       100 |
+         | chem          |       314 | chem          |       115 |
+         | comp          |       710 | comp          |       102 |
+         | corpfi        |       601 | corpfi        |       404 |
+         | edpol         |       313 | edpol         |       202 |
+         | ee            |       412 | ee            |       107 |
+         | eng           |       412 | eng           |       276 |
+         | hist          |       212 | hist          |       112 |
+         | lang          |       203 | lang          |       201 |
+         | lang          |       305 | lang          |       207 |
+         | me            |       344 | me            |       111 |
+         | phys          |       303 | phys          |       211 |
+         | phys          |       713 | phys          |       512 |
+         | poli          |       402 | poli          |       113 |
+         | tched         |       609 | tched         |       122 |
+                                                         (21 rows)
+
+         ----
+         /prerequisite
+         SELECT "prerequisite"."of_department", "prerequisite"."of_course", "prerequisite"."on_department", "prerequisite"."on_course" FROM "rd"."prerequisite" AS "prerequisite" ORDER BY 1 ASC, 2 ASC, 3 ASC, 4 ASC
+    - uri: /classification
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | classification                                                                                                         |
+        -+------------------------------------------------------------------------------------------------------------------------+-
+         | code             | type       | title                            | description                      | part_of          |
+        -+------------------+------------+----------------------------------+----------------------------------+------------------+-
+         | accounting       | department | Accounting                       |                                  | financial        |
+         | algebra          | department | Abstract Algebra                 |                                  | math             |
+         | am-history       | department | American History                 |                                  | humanities       |
+         | analysis         | department | Real and Complex Analysis        |                                  | math             |
+         | ancient          | department | Ancient Art                      |                                  | art-history      |
+         | anc-language     | department | Ancient Languages                |                                  | language         |
+         | art-bus          | department | Business of Art                  |                                  | art-history      |
+         | art-design       | university | Art and Design                   |                                  |                  |
+         | art-history      | school     | Art                              |                                  | humanities       |
+         | art-studio       | school     | Studio Art                       |                                  | art-design       |
+         | astro-lab        | department | Astronomy Laboratory             |                                  | astronomy        |
+         | astronomy        | school     | Astronomy                        |                                  | science          |
+         | astro-theory     | department | Astrophysics Theory              |                                  | astronomy        |
+         | be               | school     | Biomedical Engineering           |                                  | engineering      |
+         | be-clinical      | department | Clinical Engineering             |                                  | be               |
+         | be-general       | department | General Biomedical Engineering   |                                  | be               |
+         | beh-psych        | department | Behavioral Science               |                                  | psychology       |
+         | biomaterials     | department | Biomaterials                     |                                  | be               |
+         | business         | university | Business                         |                                  |                  |
+         | chem-computation | department | Algorithms and Data              |                                  | chemistry        |
+         :                  :            : Visualization for Chemists       :                                  :                  :
+         | chemistry        | school     | Chemistry                        |                                  | science          |
+         | chem-lab         | department | Chemistry Laboratory             |                                  | chemistry        |
+         | chem-theory      | department | Theoretical Chemistry            |                                  | chemistry        |
+         | chi-psych        | department | Child Psychology and Development |                                  | psychology       |
+         | classical        | department | Classical Art                    |                                  | ancient          |
+         | cog-psych        | department | Cognitive Science                |                                  | psychology       |
+         | comp-ai          | department | Artificial Intelligence          |                                  | comp-sci         |
+         | comp-sci         | school     | Computer Science                 |                                  | engineering      |
+         | comp-theory      | department | Computationial Science           |                                  | comp-sci         |
+         | cross            |            | Cross-Cutting Requirements       |                                  |                  |
+         | digital          | school     | Digital Media                    |                                  | art-design       |
+         | disc-history     | department | Interdisciplinary History        |                                  | humanities       |
+         | diversity        | university | Region and Ethnic Diversity      | Courses which provide a rich     | cross            |
+         :                  :            :                                  : exposure to foreign cultures and :                  :
+         :                  :            :                                  : regions qualify for this         :                  :
+         :                  :            :                                  : classification.                  :                  :
+         | drawing          | department | Drawing                          |                                  | art-studio       |
+         | early-ed         | department | Early Education                  |                                  | teach-ed         |
+         | eastern          | department | Near Eastern Art                 |                                  | ancient          |
+         | ed-management    | department | Education Management             |                                  | teach-ed         |
+         | ed-pol           | school     | Educational Policy               |                                  | education        |
+         | ed-research      | department | Educational Research             |                                  | ed-pol           |
+         | ed-studies       | department | Policy Studies                   |                                  | ed-pol           |
+         | education        | university | Education                        |                                  |                  |
+         | ee               | school     | Electrical Engineering           |                                  | engineering      |
+         | ee-com           | department | Communications                   |                                  | ee-concentration |
+         | ee-concentration | department | EE Concentrations                |                                  | ee               |
+         | ee-networking    | department | Electrical Networking            |                                  | ee-concentration |
+         | ee-theory        | department | Electrical Engineering Theory    |                                  | ee               |
+         | engineering      | university | Engineering                      |                                  |                  |
+         | eng-lit          | department | English-Language Literature      |                                  | humanities       |
+         | ethics           | school     | Business Ethics                  |                                  | business         |
+         | euro-history     | department | European History                 |                                  | humanities       |
+         | euro-lit         | department | European Literature in           |                                  | humanities       |
+         :                  :            : Translation                      :                                  :                  :
+         | fiction          | department | Fiction Writing                  |                                  | literature       |
+         | financial        | school     | Financial Analysis               |                                  | financial        |
+         | french           | department | French                           |                                  | mod-language     |
+         | german           | department | German                           |                                  | mod-language     |
+         | government       | department | Government                       |                                  | poli-sci         |
+         | history          | school     | American and World History       |                                  | humanities       |
+         | humanities       | university | Arts, Letters, and the           |                                  |                  |
+         :                  :            : Humanities                       :                                  :                  :
+         | industrial       | school     | Industrial Design                |                                  | art-design       |
+         | institutional    | department | Institutional Investment         |                                  | investment       |
+         | int-relations    | department | International Relations          |                                  | poli-sci         |
+         | investment       | department | Investment                       |                                  | financial        |
+         | journalism       | department | Journalistic Writing             |                                  | literature       |
+         | language         | school     | World Languages                  |                                  | humanities       |
+         | linguistics      | department | Linguistics                      |                                  | language         |
+         | literature       | school     | English and World Literature     |                                  | humanities       |
+         | management       | school     | Management                       |                                  | business         |
+         | markets          | school     | Capital Markets                  |                                  | financial        |
+         | math             | school     | Mathematics                      |                                  | science          |
+         | me               | school     | Mechanical Engineering           |                                  | engineering      |
+         | me-design        | department | Design and Manufacturing         |                                  | me               |
+         | me-mechanics     | department | Mechanics                        |                                  | me               |
+         | me-systems       | department | Systems and Controls             |                                  | me               |
+         | methods          | department | Teaching Methods                 |                                  | teach-ed         |
+         | modern           | department | Modern Art                       |                                  | art-history      |
+         | mod-language     | department | Modern Languages                 |                                  | language         |
+         | nanotech         | department | Nanotechnology                   |                                  | be               |
+         | non-fiction      | department | Non-Fiction Writing              |                                  | literature       |
+         | non-western-hist | department | Non-Western History              |                                  | humanities       |
+         | observation      | department | Observing Skills                 |                                  | astronomy        |
+         | personal         | department | Personal Investment              |                                  | investment       |
+         | phys-computer    | department | Computer Languages for Physics   |                                  | physics          |
+         | physics          | school     | Physics                          |                                  | science          |
+         | phys-lab         | department | Practical Physics                |                                  | physics          |
+         | phys-theory      | department | Theoretical Physics              |                                  | physics          |
+         | poetry           | department | Poetry Writing                   |                                  | literature       |
+         | poli-econ        | department | Political Economy                |                                  | poli-sci         |
+         | poli-sci         | school     | Political Science                |                                  | humanities       |
+         | power            | department | Power Electronics                |                                  | ee-concentration |
+         | printmaking      | department | Printmaking                      |                                  | art-studio       |
+         | psychology       | school     | Psychology                       |                                  | humanities       |
+         | reasoning        | university | Quantitative Reasoning           | Quantitative resoning courses    | cross            |
+         :                  :            :                                  : focus on numerical analysis to   :                  :
+         :                  :            :                                  : evaluate, describe and justify   :                  :
+         :                  :            :                                  : outcomes of complex decisions.   :                  :
+         | 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.       :                  :
+         | research         | university | Research Experience              | Research courses focus on the    | cross            |
+         :                  :            :                                  : scientific method to create      :                  :
+         :                  :            :                                  : hypothesis and test them in a    :                  :
+         :                  :            :                                  : structured laboratory            :                  :
+         :                  :            :                                  : environment.                     :                  :
+         | science          | university | Natural Sciences                 |                                  |                  |
+         | sculpture        | department | Sculpture                        |                                  | art-studio       |
+         | signal           | department | Signal Processing                |                                  | ee-concentration |
+         | society          | school     | Art and Society                  |                                  | art-design       |
+         | soft-eng         | department | Software Engineering             |                                  | comp-sci         |
+         | spanish          | department | Spanish                          |                                  | mod-language     |
+         | statistics       | department | Probability and Statistics       |                                  | math             |
+         | studio           | school     | Studio Arts                      |                                  | art-design       |
+         | teach-ed         | school     | Teacher Education                |                                  | education        |
+         | writing          | university | Writing Intensive                | Writing intensive courses        | cross            |
+         :                  :            :                                  : involve 3 or more papers per     :                  :
+         :                  :            :                                  : semester; at least one of which  :                  :
+         :                  :            :                                  : is a research paper of 20 pages  :                  :
+         :                  :            :                                  : or more.                         :                  :
+                                                                                                                         (104 rows)
+
+         ----
+         /classification
+         SELECT "classification"."code", "classification"."type", "classification"."title", "classification"."description", "classification"."part_of" FROM "rd"."classification" AS "classification" ORDER BY 1 ASC
+    - uri: /course_classification
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | course_classification                |
+        -+--------------------------------------+-
+         | department | course | classification |
+        -+------------+--------+----------------+-
+         | acc        |    100 | remedial       |
+         | acc        |    200 | accounting     |
+         | acc        |    315 | accounting     |
+         | acc        |    426 | accounting     |
+         | acc        |    527 | accounting     |
+         | acc        |    606 | accounting     |
+         | arthis     |    202 | modern         |
+         | arthis     |    340 | eastern        |
+         | arthis     |    623 | diversity      |
+         | arthis     |    623 | modern         |
+         | arthis     |    710 | modern         |
+         | arthis     |    712 | art-bus        |
+         | arthis     |    712 | management     |
+         | arthis     |    809 | modern         |
+         | artstd     |    119 | sculpture      |
+         | artstd     |    333 | drawing        |
+         | artstd     |    411 | phys-lab       |
+         | artstd     |    411 | sculpture      |
+         | artstd     |    509 | printmaking    |
+         | artstd     |    512 | society        |
+         | artstd     |    614 | drawing        |
+         | artstd     |    714 | drawing        |
+         | astro      |    137 | astronomy      |
+         | astro      |    142 | astro-lab      |
+         | astro      |    155 | observation    |
+         | astro      |    254 | astro-theory   |
+         | be         |    112 | be-general     |
+         | be         |    308 | be-general     |
+         | be         |    415 | be-clinical    |
+         | be         |    509 | be-clinical    |
+         | capmrk     |    712 | markets        |
+         | capmrk     |    756 | markets        |
+         | capmrk     |    808 | institutional  |
+         | capmrk     |    818 | institutional  |
+         | chem       |    100 | remedial       |
+         | chem       |    110 | science        |
+         | chem       |    115 | chem-lab       |
+         | chem       |    655 | chem-theory    |
+         | comp       |    102 | remedial       |
+         | comp       |    230 | comp-theory    |
+         | comp       |    350 | comp-theory    |
+         | comp       |    615 | comp-ai        |
+         | comp       |    710 | soft-eng       |
+         | comp       |    810 | soft-eng       |
+         | comp       |    819 | comp-theory    |
+         | corpfi     |    234 | financial      |
+         | corpfi     |    404 | financial      |
+         | corpfi     |    601 | financial      |
+         | edpol      |    202 | ed-research    |
+         | edpol      |    313 | am-history     |
+         | edpol      |    313 | ed-research    |
+         | edpol      |    505 | ed-research    |
+         | edpol      |    551 | ed-research    |
+         | edpol      |    617 | ed-studies     |
+         | ee         |    107 | ee-theory      |
+         | ee         |    202 | ee-theory      |
+         | ee         |    412 | ee-theory      |
+         | ee         |    505 | ee-theory      |
+         | ee         |    615 | ee-com         |
+         | eng        |    101 | remedial       |
+         | eng        |    175 | journalism     |
+         | eng        |    175 | writing        |
+         | eng        |    247 | euro-lit       |
+         | eng        |    276 | non-fiction    |
+         | eng        |    276 | writing        |
+         | eng        |    311 | non-fiction    |
+         | eng        |    412 | non-fiction    |
+         | eng        |    412 | writing        |
+         | hist       |    112 | am-history     |
+         | hist       |    212 | am-history     |
+         | hist       |    333 | disc-history   |
+         | hist       |    415 | disc-history   |
+         | hist       |    415 | diversity      |
+         | hist       |    415 | early-ed       |
+         | lang       |    201 | mod-language   |
+         | lang       |    203 | mod-language   |
+         | lang       |    207 | early-ed       |
+         | lang       |    207 | linguistics    |
+         | lang       |    305 | linguistics    |
+         | me         |    111 | me-mechanics   |
+         | me         |    344 | me-mechanics   |
+         | me         |    501 | me-systems     |
+         | me         |    627 | me-mechanics   |
+         | me         |    712 | industrial     |
+         | me         |    712 | me-design      |
+         | mth        |    101 | remedial       |
+         | phys       |    211 | science        |
+         | phys       |    303 | phys-theory    |
+         | phys       |    388 | phys-lab       |
+         | phys       |    388 | reasoning      |
+         | phys       |    512 | phys-theory    |
+         | phys       |    713 | phys-theory    |
+         | phys       |    819 | phys-theory    |
+         | poli       |    113 | government     |
+         | poli       |    402 | government     |
+         | poli       |    431 | government     |
+         | poli       |    644 | int-relations  |
+         | poli       |    715 | int-relations  |
+         | psych      |    102 | remedial       |
+         | psych      |    304 | cog-psych      |
+         | psych      |    304 | reasoning      |
+         | psych      |    450 | beh-psych      |
+         | psych      |    560 | cog-psych      |
+         | psych      |    560 | comp-ai        |
+         | psych      |    610 | chi-psych      |
+         | psych      |    610 | early-ed       |
+         | psych      |    610 | research       |
+         | tched      |    122 | early-ed       |
+         | tched      |    155 | methods        |
+         | tched      |    367 | ed-management  |
+         | tched      |    367 | management     |
+         | tched      |    501 | early-ed       |
+         | tched      |    609 | early-ed       |
+                                       (113 rows)
+
+         ----
+         /course_classification
+         SELECT "course_classification"."department", "course_classification"."course", "course_classification"."classification" FROM "rd"."course_classification" AS "course_classification" ORDER BY 1 ASC, 2 ASC, 3 ASC
+    - uri: /program_requirement
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | program_requirement                                                                    |
+        -+----------------------------------------------------------------------------------------+-
+         | school | program  | classification   | credit_hours | rationale                        |
+        -+--------+----------+------------------+--------------+----------------------------------+-
+         | art    | gart     | art-history      |           20 | Candidates for the Post          |
+         :        :          :                  :              : Baccalaureate in Art History     :
+         :        :          :                  :              : must complete a minimum number   :
+         :        :          :                  :              : of core art history courses.     :
+         | art    | uhist    | art-history      |           14 | Students in the undergraduate    |
+         :        :          :                  :              : Art History program are required :
+         :        :          :                  :              : to take 9 credit hours of        :
+         :        :          :                  :              : elective classes in art history. :
+         | 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    | eastern          |            6 | Students in the undergraduate    |
+         :        :          :                  :              : Art History program are required :
+         :        :          :                  :              : to take 9 credit hours of study  :
+         :        :          :                  :              : of eastern art.                  :
+         | art    | uhist    | modern           |            9 | Students in the undergraduate    |
+         :        :          :                  :              : Art History program are required :
+         :        :          :                  :              : to take 9 credit hours of study  :
+         :        :          :                  :              : of modern art.                   :
+         | art    | ustudio  | art-studio       |           24 | Students in the undergraduate    |
+         :        :          :                  :              : Studio Art program will          :
+         :        :          :                  :              : concentrate on their selected    :
+         :        :          :                  :              : studio discipline.               :
+         | art    | ustudio  | digital          |            6 | All Studio Art undergraduate     |
+         :        :          :                  :              : students must take a minimum of  :
+         :        :          :                  :              : 6 hours of credit in Digital     :
+         :        :          :                  :              : Art.                             :
+         | art    | ustudio  | drawing          |            8 | All Studio Art undergraduate     |
+         :        :          :                  :              : students must take a minimum 8   :
+         :        :          :                  :              : hours of credit in freehand      :
+         :        :          :                  :              : drawing.                         :
+         | art    | ustudio  | society          |            6 | All Studio Art undergraduate     |
+         :        :          :                  :              : students must take a minimum of  :
+         :        :          :                  :              : 6 hours of credit in Art &       :
+         :        :          :                  :              : Society.                         :
+         | 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.                          :
+         | bus    | uacct    | accounting       |           24 | Students pursuing the B.S. in    |
+         :        :          :                  :              : Accounting will take the         :
+         :        :          :                  :              : majority of their credit hours   :
+         :        :          :                  :              : in accounting.                   :
+         | bus    | uacct    | analysis         |            8 | Students pursuing the B.S. in    |
+         :        :          :                  :              : Accounting must take at least 8  :
+         :        :          :                  :              : credit hours of relevant         :
+         :        :          :                  :              : mathematics.                     :
+         | bus    | uacct    | ethics           |           12 | Students pursuing any            |
+         :        :          :                  :              : undergraduate degree in business :
+         :        :          :                  :              : will be required to meet a core  :
+         :        :          :                  :              : requirement in business ethics.  :
+         | bus    | uacct    | investment       |            8 | Students pursuing the B.S. in    |
+         :        :          :                  :              : Accounting must take at least 8  :
+         :        :          :                  :              : credit hours in general          :
+         :        :          :                  :              : investment topics.               :
+         | bus    | ubusad   | ethics           |           12 | Students pursuing any            |
+         :        :          :                  :              : undergraduate degree in business :
+         :        :          :                  :              : will be required to meet a core  :
+         :        :          :                  :              : requirement in business ethics.  :
+         | bus    | ubusad   | management       |           24 | B.S. students in Business        |
+         :        :          :                  :              : Administration will focus on     :
+         :        :          :                  :              : corporate management.            :
+         | bus    | ucorpfi  | accounting       |           10 | Students pursuing the B.S. in    |
+         :        :          :                  :              : Corporate Finance must take a    :
+         :        :          :                  :              : minimum of 10 credit hours in    :
+         :        :          :                  :              : accounting.                      :
+         | bus    | ucorpfi  | ethics           |           12 | Students pursuing any            |
+         :        :          :                  :              : undergraduate degree in business :
+         :        :          :                  :              : will be required to meet a core  :
+         :        :          :                  :              : requirement in business ethics.  :
+         | bus    | ucorpfi  | financial        |           18 | Students pursuing the B.S. in    |
+         :        :          :                  :              : Corporate Finance will take the  :
+         :        :          :                  :              : majority of their credit hours   :
+         :        :          :                  :              : in general financial classes.    :
+         | bus    | ucorpfi  | management       |            6 | Students pursuing the B.S. in    |
+         :        :          :                  :              : Corporate Finance must take a    :
+         :        :          :                  :              : minimum number of credits in     :
+         :        :          :                  :              : corporate management.            :
+         | edu    | gedlead  | ed-pol           |           20 | Candidates for the Master of     |
+         :        :          :                  :              : Arts in Educational Leadership   :
+         :        :          :                  :              : will concentrate in educational  :
+         :        :          :                  :              : policy.                          :
+         | 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     | ed-research      |           22 | Candidates for the Master of     |
+         :        :          :                  :              : Science in Education will focus  :
+         :        :          :                  :              : on a core requirement of         :
+         :        :          :                  :              : education-related research       :
+         :        :          :                  :              : leading up to the master's       :
+         :        :          :                  :              : thesis.                          :
+         | edu    | glited   | teach-ed         |           28 | Candidates for the Master of     |
+         :        :          :                  :              : Arts in Literacy Education will  :
+         :        :          :                  :              : take the majority of their       :
+         :        :          :                  :              : credit hours in teacher          :
+         :        :          :                  :              : education, focusing on literacy. :
+         | edu    | gtch     | teach-ed         |           28 | Candidates for the Master of     |
+         :        :          :                  :              : Arts in Teaching will            :
+         :        :          :                  :              : concentrate on the study of      :
+         :        :          :                  :              : teaching methods in their chosen :
+         :        :          :                  :              : concentration.                   :
+         | edu    | psci     | methods          |           12 | Candidates for the Certificate   |
+         :        :          :                  :              : in Science Teaching are required :
+         :        :          :                  :              : to take a minimum number of      :
+         :        :          :                  :              : credit hours in teaching         :
+         :        :          :                  :              : methods.                         :
+         | edu    | psci     | science          |           12 | Candidates for the Certificate   |
+         :        :          :                  :              : in Science Teaching are required :
+         :        :          :                  :              : to take a minimum number of      :
+         :        :          :                  :              : credit hours in general science. :
+         | edu    | umath    | diversity        |            8 | In acknowledgement of the        |
+         :        :          :                  :              : importance of diversity in       :
+         :        :          :                  :              : education, all candidates for    :
+         :        :          :                  :              : education degrees must take at   :
+         :        :          :                  :              : least 8 credit hours in diverse  :
+         :        :          :                  :              : cultures and history.            :
+         | edu    | umath    | math             |           16 | Bachelor of Arts students in     |
+         :        :          :                  :              : Science Education must take at   :
+         :        :          :                  :              : least 16 hours of general math.  :
+         | edu    | umath    | teach-ed         |           20 | Bachelor of Arts students in     |
+         :        :          :                  :              : Math Education must take at      :
+         :        :          :                  :              : least 20 credit hours of general :
+         :        :          :                  :              : teacher education.               :
+         | edu    | usci     | diversity        |            8 | In acknowledgement of the        |
+         :        :          :                  :              : importance of diversity in       :
+         :        :          :                  :              : education, all candidates for    :
+         :        :          :                  :              : education degrees must take at   :
+         :        :          :                  :              : least 8 credit hours in diverse  :
+         :        :          :                  :              : cultures and history.            :
+         | edu    | usci     | science          |           14 | Bachelor of Arts students in     |
+         :        :          :                  :              : Science Education must take at   :
+         :        :          :                  :              : least 14 hours of general        :
+         :        :          :                  :              : science.                         :
+         | edu    | usci     | teach-ed         |           22 | Bachelor of Arts students in     |
+         :        :          :                  :              : Science Education must take at   :
+         :        :          :                  :              : least 22 credit hours of general :
+         :        :          :                  :              : science education.               :
+         | egn    | gbe      | ee               |           38 | Candidates for the Master of     |
+         :        :          :                  :              : Science in Electrical            :
+         :        :          :                  :              : Engineering must take at least   :
+         :        :          :                  :              : 38 credit hours in graduate      :
+         :        :          :                  :              : electrical engineering.          :
+         | egn    | gbuseng  | business         |           16 | Candidates for the Master of     |
+         :        :          :                  :              : Science in Business and          :
+         :        :          :                  :              : Engineering are required to take :
+         :        :          :                  :              : at least 16 credit hours in      :
+         :        :          :                  :              : general business.                :
+         | egn    | gbuseng  | engineering      |           22 | Candidates for the Master of     |
+         :        :          :                  :              : Science in Business and          :
+         :        :          :                  :              : Engineering are required to take :
+         :        :          :                  :              : at least 22 credit hours in one  :
+         :        :          :                  :              : or more relevant engineering     :
+         :        :          :                  :              : disciplines.                     :
+         | egn    | gee      | ee               |           34 | Candidates for the Master of     |
+         :        :          :                  :              : Science in Electrical            :
+         :        :          :                  :              : Engineering must take at least   :
+         :        :          :                  :              : 34 credit hours in graduate      :
+         :        :          :                  :              : electrical engineering.          :
+         | egn    | gme      | ee               |           36 | Candidates for the Master of     |
+         :        :          :                  :              : Science in Electrical            :
+         :        :          :                  :              : Engineering must take at least   :
+         :        :          :                  :              : 36 credit hours in graduate      :
+         :        :          :                  :              : electrical engineering.          :
+         | egn    | ubio     | be               |           24 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates in Bioengineering are :
+         :        :          :                  :              : expected to take at least 24     :
+         :        :          :                  :              : hours of credit in their area of :
+         :        :          :                  :              : concentration--clinical,         :
+         :        :          :                  :              : nanotech, orbiomaterials         :
+         | egn    | ubio     | comp-sci         |           12 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates are expected to take  :
+         :        :          :                  :              : at least 12 hours of credit in   :
+         :        :          :                  :              : computer science and/or          :
+         :        :          :                  :              : programming related to their     :
+         :        :          :                  :              : major.                           :
+         | egn    | ubio     | humanities       |           12 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates are expected to take  :
+         :        :          :                  :              : at least 12 hours of credit in   :
+         :        :          :                  :              : general humanities.              :
+         | egn    | ubio     | me-systems       |           10 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates in Bioengineering are :
+         :        :          :                  :              : expected to take at least 9      :
+         :        :          :                  :              : hours of credit in biomaterials, :
+         :        :          :                  :              : regardless of their area of      :
+         :        :          :                  :              : concentration.                   :
+         | egn    | uelec    | comp-sci         |           12 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates are expected to take  :
+         :        :          :                  :              : at least 12 hours of credit in   :
+         :        :          :                  :              : computer science and/or          :
+         :        :          :                  :              : programming related to their     :
+         :        :          :                  :              : major.                           :
+         | egn    | uelec    | ee-concentration |           22 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates in Electrical         :
+         :        :          :                  :              : Engineering are expected to take :
+         :        :          :                  :              : at least 22 hours of credit in   :
+         :        :          :                  :              : their area of concentration.     :
+         | egn    | uelec    | ee-theory        |           18 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates in Electrical         :
+         :        :          :                  :              : Engineering are expected to take :
+         :        :          :                  :              : at least 18 hours of credit in   :
+         :        :          :                  :              : EE theory.                       :
+         | egn    | umech    | comp-sci         |           12 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates are expected to take  :
+         :        :          :                  :              : at least 12 hours of credit in   :
+         :        :          :                  :              : computer science and/or          :
+         :        :          :                  :              : programming related to their     :
+         :        :          :                  :              : major.                           :
+         | egn    | umech    | humanities       |           12 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates are expected to take  :
+         :        :          :                  :              : at least 12 hours of credit in   :
+         :        :          :                  :              : general humanities.              :
+         | egn    | umech    | me               |           22 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates in Mechanical         :
+         :        :          :                  :              : Engineering are expected to take :
+         :        :          :                  :              : at least 22 hours of credit in   :
+         :        :          :                  :              : their area of                    :
+         :        :          :                  :              : concentration--mechanics, de     :
+         :        :          :                  :              : sign, or systems.                :
+         | egn    | umech    | me-systems       |            9 | Bachelor of Engineering          |
+         :        :          :                  :              : candidates in Mechanical         :
+         :        :          :                  :              : Engineering are expected to take :
+         :        :          :                  :              : at least 9 hours of credit in    :
+         :        :          :                  :              : systems, regardless of their     :
+         :        :          :                  :              : area of concentration.           :
+         | la     | gengl    | literature       |           36 | Candidates for the M.A. in       |
+         :        :          :                  :              : English will take a minimum of   :
+         :        :          :                  :              : 36 credit hours of literature    :
+         :        :          :                  :              : courses.                         :
+         | la     | glang    | language         |           22 | Candidates for the Master of     |
+         :        :          :                  :              : Arts in Modern Languages must    :
+         :        :          :                  :              : take a minimum of 22 credit      :
+         :        :          :                  :              : hours in the modern language of  :
+         :        :          :                  :              : their concentration.             :
+         | la     | gscitch  | early-ed         |           12 | M.S. candidates will take a      |
+         :        :          :                  :              : minimum of 12 hours of early     :
+         :        :          :                  :              : childhood education instruction. :
+         | la     | gscitch  | methods          |           18 | M.S. candidates should complete  |
+         :        :          :                  :              : a minimum of 18 credit hours     :
+         :        :          :                  :              : focused on teaching methods.     :
+         | la     | gscitch  | science          |           18 | M.S. candidates for the science  |
+         :        :          :                  :              : teaching degree who do not have  :
+         :        :          :                  :              : undergraduate degrees in science :
+         :        :          :                  :              : must take a minimum of 18 credit :
+         :        :          :                  :              : hours in one scientific          :
+         :        :          :                  :              : discipline.                      :
+         | la     | psciwri  | journalism       |           12 | Candidates will take four        |
+         :        :          :                  :              : three-hour classes in writing    :
+         :        :          :                  :              : focused on scientific journalism :
+         | la     | psciwri  | science          |           12 | Candidates for the Certificate   |
+         :        :          :                  :              : in Science Writing will take     :
+         :        :          :                  :              : four three-hour classes in       :
+         :        :          :                  :              : general science.                 :
+         | la     | uengl    | euro-lit         |           12 | B.A. candidates in English are   |
+         :        :          :                  :              : expected to take three courses   :
+         :        :          :                  :              : in European literature.          :
+         | la     | uengl    | humanities       |           16 | B.A. candidates in the           |
+         :        :          :                  :              : humanities will take a minimum   :
+         :        :          :                  :              : of 16 credit hours in general    :
+         :        :          :                  :              : humanities outside their major.  :
+         | la     | uengl    | literature       |           30 | B.A. candidates in English are   |
+         :        :          :                  :              : expected to take 30 credit hours :
+         :        :          :                  :              : in general literature.           :
+         | la     | uengl    | mod-language     |           16 | B.A. candidates in the           |
+         :        :          :                  :              : humanities will take a minimum   :
+         :        :          :                  :              : of two years of a modern         :
+         :        :          :                  :              : language of their choice.        :
+         | la     | uengl    | reasoning        |            6 | B.A. candidates in the           |
+         :        :          :                  :              : humanities will take a minimum   :
+         :        :          :                  :              : of two courses emphasizing       :
+         :        :          :                  :              : reasoning.                       :
+         | la     | uhist    | diversity        |           16 | In recognition of the importance |
+         :        :          :                  :              : of diversity in modern society,  :
+         :        :          :                  :              : undergraduate humanities majors  :
+         :        :          :                  :              : must take a minimum of 16        :
+         :        :          :                  :              : credits hours of course          :
+         :        :          :                  :              : emphasizing cultural diversity.  :
+         | la     | upolisci | diversity        |           16 | In recognition of the importance |
+         :        :          :                  :              : of diversity in modern society,  :
+         :        :          :                  :              : undergraduate humanities majors  :
+         :        :          :                  :              : must take a minimum of 16        :
+         :        :          :                  :              : credits hours of course          :
+         :        :          :                  :              : emphasizing cultural diversity.  :
+         | la     | upolisci | government       |           16 | Political Science majors will    |
+         :        :          :                  :              : take at least 16 credit hours of :
+         :        :          :                  :              : coursework in world government   :
+         | la     | upolisci | int-relations    |           12 | Political Science majors will    |
+         :        :          :                  :              : take at least 12 credit hours of :
+         :        :          :                  :              : coursework in international      :
+         :        :          :                  :              : relations.                       :
+         | la     | upolisci | poli-econ        |           12 | Political Science majors will    |
+         :        :          :                  :              : take at least 12 credit hours of :
+         :        :          :                  :              : coursework in political economy. :
+         | la     | upolisci | reasoning        |            6 | B.A. candidates in the           |
+         :        :          :                  :              : humanities will take a minimum   :
+         :        :          :                  :              : of two courses emphasizing       :
+         :        :          :                  :              : reasoning.                       :
+         | la     | upolisci | writing          |           12 | Political science 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   | psychology       |           24 | Psychology majors must take the  |
+         :        :          :                  :              : minimum credit hours in one or   :
+         :        :          :                  :              : more of the three major          :
+         :        :          :                  :              : psychology                       :
+         :        :          :                  :              : concentrations--cognitive,       :
+         :        :          :                  :              : behavioral, or child.            :
+         | la     | upsych   | reasoning        |            6 | B.A. candidates in the           |
+         :        :          :                  :              : humanities will take a minimum   :
+         :        :          :                  :              : of two courses emphasizing       :
+         :        :          :                  :              : reasoning.                       :
+         | la     | upsych   | writing          |           12 | Psychology majors must take a    |
+         :        :          :                  :              : minimum of 12 credit hours in    :
+         :        :          :                  :              : writing.                         :
+         | la     | uspan    | diversity        |           16 | In recognition of the importance |
+         :        :          :                  :              : of diversity in modern society,  :
+         :        :          :                  :              : undergraduate humanities majors  :
+         :        :          :                  :              : must take a minimum of 16        :
+         :        :          :                  :              : credits hours of course          :
+         :        :          :                  :              : emphasizing cultural diversity.  :
+         | la     | uspan    | humanities       |           16 | B.A. candidates in the           |
+         :        :          :                  :              : humanities will take a minimum   :
+         :        :          :                  :              : of 16 credit hours in general    :
+         :        :          :                  :              : humanities outside their major.  :
+         | la     | uspan    | mod-language     |           16 | B.A. candidates in the           |
+         :        :          :                  :              : humanities will take a minimum   :
+         :        :          :                  :              : of two years of a modern         :
+         :        :          :                  :              : language of their choice.        :
+         | la     | uspan    | reasoning        |            6 | B.A. candidates in the           |
+         :        :          :                  :              : humanities will take a minimum   :
+         :        :          :                  :              : of two courses emphasizing       :
+         :        :          :                  :              : reasoning.                       :
+         | la     | uspan    | spanish          |           24 | Spanish majors will take a       |
+         :        :          :                  :              : minimum of 24 credit hours in    :
+         :        :          :                  :              : the Spanish majors.              :
+         | mart   | bmart    | art-history      |           10 | Students in the undergraduate    |
+         :        :          :                  :              : Modern Art program are required  :
+         :        :          :                  :              : to take 10 credit hours of       :
+         :        :          :                  :              : elective classes in art history. :
+         | mart   | bmart    | classical        |            9 | Students in the undergraduate    |
+         :        :          :                  :              : Modern Art program are required  :
+         :        :          :                  :              : to take 9 credit hours of study  :
+         :        :          :                  :              : of classical art.                :
+         | mart   | bmart    | modern           |           24 | Students in the undergraduate    |
+         :        :          :                  :              : Modern Art program are required  :
+         :        :          :                  :              : to take 24 credit hours of study :
+         :        :          :                  :              : of modern art.                   :
+         | ns     | uastro   | astro-lab        |            8 | Astronomy students are expected  |
+         :        :          :                  :              : to take a minimum of 8 credit    :
+         :        :          :                  :              : hours in the astronomy           :
+         :        :          :                  :              : laboratory.                      :
+         | ns     | uastro   | astro-theory     |           24 | Undergraduate astronomy students |
+         :        :          :                  :              : will take a minimum of 12 credit :
+         :        :          :                  :              : hours of coursework on astronomy :
+         :        :          :                  :              : theory.                          :
+         | ns     | uastro   | humanities       |           16 | B.S. candidates in the sciences  |
+         :        :          :                  :              : will take a minimum of 16 credit :
+         :        :          :                  :              : hours in the humanities.         :
+         | ns     | uastro   | observation      |           12 | Undergraduate astronomy students |
+         :        :          :                  :              : will take a minimum of 12 credit :
+         :        :          :                  :              : hours of observational           :
+         :        :          :                  :              : astronomy.                       :
+         | ns     | uastro   | physics          |            9 | Undergraduate astronomy students |
+         :        :          :                  :              : will take a minimum of 9 credit  :
+         :        :          :                  :              : hours in physics.                :
+         | 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     | uchem    | chem-lab         |           16 | Undergraduate chemistry students |
+         :        :          :                  :              : must satisfy a minimum           :
+         :        :          :                  :              : requirement for chemistry        :
+         :        :          :                  :              : labwork.                         :
+         | ns     | uchem    | chem-theory      |           18 | Undergraduate chemistry students |
+         :        :          :                  :              : must satisfy a minimum           :
+         :        :          :                  :              : requirement for chemistry        :
+         :        :          :                  :              : theory.                          :
+         | ns     | uchem    | humanities       |           16 | B.S. candidates in the sciences  |
+         :        :          :                  :              : will take a minimum of 16 credit :
+         :        :          :                  :              : hours in the humanities.         :
+         | ns     | uchem    | reasoning        |           12 | Undergraduate science students   |
+         :        :          :                  :              : will take a minimum of 12 credit :
+         :        :          :                  :              : hours in general reasoning.      :
+         | ns     | uchem    | research         |           12 | B.S. candidates in the sciences  |
+         :        :          :                  :              : will take a minimum of 12 credit :
+         :        :          :                  :              : hours in research techniques.    :
+         | ns     | uphys    | humanities       |           16 | B.S. candidates in the sciences  |
+         :        :          :                  :              : will take a minimum of 12 credit :
+         :        :          :                  :              : hours in the humanities.         :
+         | ns     | uphys    | phys-lab         |           12 | Candidates for the B.S. in       |
+         :        :          :                  :              : physics must take a minimum of   :
+         :        :          :                  :              : 12 hours of physics labwork.     :
+         | ns     | uphys    | phys-theory      |           26 | Candidates for the B.S. in       |
+         :        :          :                  :              : physics must take a minimum of   :
+         :        :          :                  :              : 26 hours of physics theory.      :
+         | ns     | uphys    | science          |           12 | Physics majors are expected to   |
+         :        :          :                  :              : take a minimum of 12 credit      :
+         :        :          :                  :              : hours in other scientific        :
+         :        :          :                  :              : disciplines.                     :
+                                                                                          (97 rows)
+
+         ----
+         /program_requirement
<