COMP-4421 Details

COMP 4421 Database Organization and Management

Course Description

An introductory class in database management systems covering both relational and non-relational databases with an emphasis on relational. Topics include database design, ER modeling, relational algebra, SQL, scripting, and embedded SQL. Each student will design, load, query and update a nontrivial database using a relational database management system (RDBMS). In addition, an introduction to a NoSQL database will be included.

Course Outline

1. Introduction to Databases, SQL Language and Syntax
2. SQL (continued), Joins and Nested queries
3. Multiple tables, Joins and Nested queries (continued)
4. Programming with SQL (Java, Python MySQL access)
5. Creating tables, data types, Insert/Update/Delete; Transactions
6. Data Modeling
7. Advanced Data Modeling, Tables from Models
8. Database Normalization
9. Stored Procedures, Performance
10. NoSQL Databases

Prerequisites

COMP-4006

Course Syllabus