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