CSC375 Database Management Systems

[3–0, 3 cr.]

This course is an introduction to the fundamental concepts and relational and NoSQL database systems. Topics include database architecture, row and columnar databases, data independence, data modeling, physical and relational database design, functional dependency, normal forms, query languages, query optimization, database security, and transactions at the SQL level.  The course also covers NoSQL databases and their core concepts (key-value, column family, document, and graph) in addition to an exploration of how MongoDB implements these core concepts. 

Prerequisite: CSC245 Objects and Data Abstraction and MTH 207 Discrete Structures I