CMPU 381 - Relational Databases and SQL

Semester Offered: Fall
0.5 unit(s)

Database Management Systems (DBMSs) emerged in the 1960s with the development of mainframe computers. In a sense, DBMSs could be considered one of the first killer apps. In 1970 a new DBMS model was introduced that endures today: the relational database model. One of the strengths of the relational model was that it provided a declarative Structured Query Language (SQL), including a Data Definition Language (DDL) for creating, modifying, and updating databases. This Intensive focuses on relational database design, database normalization techniques and normal forms, entity-relationship diagrams, and querying databases using SQL. Students work individually or in pairs on projects throughout the semester involving the design, creation, and querying of databases. Marc Smith.

Prerequisite(s): CMPU 145, CMPU 203.

Course Format: INT