Fundamentals of Database Systems

Catalog description

A practical approach to analysis, design, and implementation of database systems. This course covers topics such as: conceptual, logical and physical data models; relational databases 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. Students with a semester level of Freshman 1, Freshman 2 or Sophomore 1 may not enroll.