Data Table in a Relational Database
RDBMS = Relational Database Management System
- Postgres
- MySQL
- Oracle
- Microsoft SQL Server
Course Data in RDBMS Table
Course data for Faculty of Arts & Sciences is in a mysql database on cscie12students (username: class; database name: coursecatalog)
SQL:
describe ext_coursesTerminal:
cscie12students$ mysql -u class coursecatalog
Welcome to the MySQL monitor. Commands end with ; or \g.
mysql> describe ext_courses;
+----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| academic_year | year | YES | | NULL | |
| term | varchar(32) | YES | | NULL | |
| term_code | int | YES | | NULL | |
| course_code | int | YES | | NULL | |
| course_number | int | YES | | NULL | |
| short_title | text | YES | | NULL | |
| title | text | YES | | NULL | |
| faculty_description | text | YES | | NULL | |
| department_code | varchar(15) | YES | | NULL | |
| department | varchar(200) | YES | | NULL | |
| course_type | varchar(100) | YES | | NULL | |
| credits | varchar(50) | YES | | NULL | |
| credit_undergraduate | int | YES | | NULL | |
| credit_graduate | int | YES | | NULL | |
| url | varchar(300) | YES | | NULL | |
| days_of_week | varchar(100) | YES | | NULL | |
| start_time | varchar(15) | YES | | NULL | |
| end_time | varchar(15) | YES | | NULL | |
| location | varchar(64) | YES | | NULL | |
| notes | text | YES | | NULL | |
| description | text | YES | | NULL | |
+----------------------+--------------+------+-----+---------+-------+
21 rows in set (0.00 sec)Selecting List of Departments
SQL Input:
select DISTINCT department_code, department from ext_coursesTerminal Output:
mysql> SELECT DISTINCT department_code, department FROM ext_courses ORDER BY department;
+-----------------+--------------------------------------+
| department_code | department |
+-----------------+--------------------------------------+
| AAAS | African and African American Studies |
| ANTH | Anthropology and Archaeology |
| APMA | Applied Mathematics |
| ARAB | Arabic |
| ASTR | Astronomy |
| BIOS | Biological Sciences |
| BIOT | Biotechnology |
| CELT | Celtic Languages and Literatures |
| CHEM | Chemistry |
| CLAS | Classics |
| CSCI | Computer Science |
| CREA | Creative Writing |
| DEVP | Development Practice |
| DGMD | Digital Media |
| DRAM | Dramatic Arts |
| ECON | Economics |
| EDUC | Education |
| ENSC | Engineering Sciences |
| ENGL | English |
| ENVR | Environmental Studies |
| EXPO | Expository Writing |
| FREN | French Language and Literature |
| GERM | German |
| GOVT | Government |
| CGRK | Greek |
| HIST | History |
| HARC | History of Art and Architecture |
| HUMA | Humanities |
| IORP | Industrial-Organizational Psychology |
| ISMT | Information Systems Management |
| ITAL | Italian |
| JAPA | Japanese |
| JOUR | Journalism |
| LATI | Latin |
| LSTU | Legal Studies |
| MGMT | Management |
| MATH | Mathematics |
| MUSE | Museum Studies |
| MUSI | Music |
| NUTR | Nutrition |
| PHIL | Philosophy |
| PHYS | Physics |
| PSYC | Psychology |
| RELI | Religion |
| SSCI | Social Sciences |
| SOCI | Sociology |
| SPAN | Spanish Language and Literature |
| SPCH | Speech |
| STAT | Statistics |
| STAR | Studio Arts and Film |
+-----------------+--------------------------------------+
50 rows in set (0.01 sec)