Feb 24, 2020  
2018-2020 Undergraduate Catalog 
    
2018-2020 Undergraduate Catalog
Add to Portfolio

CPSC 323 - Fundamentals of Database Systems


A practical approach to analysis, design, and implementation of database systems. This course covers topics such as: conceptual, logical and physical data models; relational database and relational algebra; building and mapping entity relationship diagrams (ERDs); normalization; basic and advanced Structured Query Language (SQL) for data retrieval and manipulation; functions, triggers, and procedures; transactions and concurrency control; security, backup, and recovery procedures.

Prerequisites & Notes
Prerequisites: CPSC 130 or CPSC 146

Credits: 3



Add to Portfolio