CPSC 224

This course focuses on core concepts of database systems, the relational database model, data modeling, and querying. Topics include the purpose and components of database systems, core DBMS functionalities, relational models and algebra, SQL, database design, and the entity-relationship model. Also discussed are best practices, such as the use of logical schema and normalization. An applied project using business requirements to answer complex business questions is provided. A relational DBMS is used to gain high competency with using SQL and other database-related tasks.