## 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_courses

Terminal:

    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_courses

Terminal 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)