StudyPath

CSC 472 Database Systems

400 levelComputing & ICT10 topics

CSC 472 covers 10 topics. StudyPath paces them into daily study sessions that finish before your exam date, with practice questions and worked answers for each one.

Study CSC 472 on StudyPath

Free for every student. No card.

Course outline

The topics this course covers, in teaching order.

  1. Database system architecture and data models
  2. The relational model
  3. Relational algebra and calculus
  4. Structured Query Language (SQL)
  5. Entity-relationship modelling
  6. Functional dependencies and normalisation
  7. Transaction management and ACID properties
  8. Concurrency control
  9. Database recovery
  10. Indexing, hashing and query optimisation

A sample from this course

One topic, as StudyPath teaches it.

Database system architecture and data models

This topic covers how a database system is organised internally and how data is represented through different data models. For exam success, you must clearly distinguish levels of architecture, understand the roles of DBMS components, and compare major data models such as hierarchical, network, relational, and object-based models.

What you get for CSC 472