book cover
Database System Concepts
Seventh Edition
Avi Silberschatz
Henry F. Korth
S. Sudarshan


line separator

Suggested Syllabus for a One Semester Systems Oriented Course

line separator

The following syllabus is designed for a course where the goal is to teach students the fundamental concepts underlying database system design, including not only the design of applications using databases, but also covering the fundamental implementation techniques used in database systems. The amount of material that needs to be covered will make such a course a rather intensive one to cover in one semester, and students must be prepared for the course load.

  • Chapters
  • Assignments/Project

    The course should be supplemented by assignments and a project. The assignments can involve the design of
    a schema for a realistic application, and coding and executing SQL queries on a relational database system.

    The project could involve implementing one or more component(s) or a database system, as an index structure,
    or lock manager, or relation manager (providing an iterator interface), or a simple relational algebra evaluation
    engine based on the iterator model.

    More ambitious courses may wish to have projects based on adding functionality to the PostgreSQL open-source
    database system.

  • line separator

    Last updated Feb 2019.