Course data for Faculty of Arts & Sciences is in a mysql database on cscie12students (username: class; database name: coursecatalog)
SQL:
describe coursesTerminal:
cscie12students$ mysql -u class coursecatalog
Welcome to the MySQL monitor. Commands end with ; or \g.
mysql> describe courses;
+------------------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+--------------+------+-----+---------+-------+
| acad_year | year(4) | YES | | NULL | |
| cat_num | int(9) | YES | | NULL | |
| offered | char(1) | YES | | NULL | |
| department_code | varchar(15) | YES | | NULL | |
| department_short | varchar(80) | YES | | NULL | |
| department_long | varchar(200) | YES | | NULL | |
| course_group_code | varchar(10) | YES | | NULL | |
| course_group_long | varchar(200) | YES | | NULL | |
| num_int | int(9) | YES | | NULL | |
| num_char | varchar(15) | YES | | NULL | |
| term_pattern_code | int(5) | YES | | NULL | |
| fall_term | char(1) | YES | | NULL | |
| spring_term | char(1) | YES | | NULL | |
| term | varchar(100) | YES | | NULL | |
| title | text | YES | | NULL | |
| course_type | varchar(100) | YES | | NULL | |
| course_level_code | char(1) | YES | | NULL | |
| course_level | varchar(200) | YES | | NULL | |
| credit_code | int(5) | YES | | NULL | |
| credit | varchar(50) | YES | | NULL | |
| instructor_approval_required | char(1) | YES | | NULL | |
| meeting_time | text | YES | | NULL | |
| faculty_text | text | YES | | NULL | |
| description | text | YES | | NULL | |
| prerequisites | text | YES | | NULL | |
| notes | text | YES | | NULL | |
+------------------------------+--------------+------+-----+---------+-------+
26 rows in set (0.00 sec)
SQL:
select distinct department_short from coursesTerminal:
mysql> select distinct department_short from courses;
+----------------------------------------------------------+
| department_short |
+----------------------------------------------------------+
| African and African American Studies |
| American Studies |
| Anthropology |
| Architecture, Landscape Architecture, and Urban Planning |
| Asian Studies Programs |
| Astronomy |
| Biological Sciences in Dental Medicine |
| Biological Sciences in Public Health |
| Biophysics |
| Biostatistics |
| Celtic Languages and Literatures |
| Chemical Biology |
| Chemical and Physical Biology |
| Chemistry and Chemical Biology |
| Comparative Literature |
| Dramatic Arts |
| Earth and Planetary Sciences |
| East Asian Languages and Civilizations |
| Economics |
| Engineering and Applied Sciences |
| English |
| Environmental Science and Public Policy |
| Expository Writing |
| Folklore and Mythology |
| Freshman Seminars |
| General Education |
| Germanic Languages and Literatures |
| Global Health and Health Policy |
| Government |
| Health Policy |
| History |
| History and Literature |
| History of Art and Architecture |
| History of Science |
| House Seminars |
| Human Evolutionary Biology |
| Humanities |
| Life Sciences |
| Linguistics |
| Mathematics |
| Medical Sciences |
| Medieval Studies |
| Middle Eastern Studies |
| Mind, Brain, and Behavior |
| Molecular and Cellular Biology |
| Music |
| Near Eastern Languages and Civilizations |
| Neurobiology |
| No Department |
| Organismic and Evolutionary Biology |
| Philosophy |
| Physical Sciences |
| Physics |
| Psychology |
| Regional Studies - East Asia |
| Romance Languages and Literatures |
| Russia, Eastern Europe, and Central Asia |
| Slavic Languages and Literatures |
| Social Policy |
| Social Studies |
| Sociology |
| South Asian Studies |
| Special Concentrations |
| Statistics |
| Stem Cell and Regenerative Biology |
| Studies of Women, Gender, and Sexuality |
| Systems Biology |
| The Classics |
| The Study of Religion |
| Ukrainian Studies |
| Visual and Environmental Studies |
+----------------------------------------------------------+
71 rows in set (0.01 sec)Copyright © David Heitmeyer