Sep 18, 2019  
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]