Database System Concepts
Seventh Edition
- Avi Silberschatz
- Henry F. Korth
- S. Sudarshan
Suggested Syllabus for a One Semester Systems Oriented Course
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
- Chapter 1: Introduction
- Chapter 2: Introduction to Relational Languages
- Chapter 3: Introduction to SQL
- Chapter 4: Intermediate SQL
- Chapter 5: Advanced SQL
- Sections 5.4 onwards may be omitted.
- Chapter 6: Entity-Relationship Model
- Chapter 7: Relational Database Design
- Chapter 8: Complex Data Types
- Chapter 9: Application Design
- Chapter 10: Big Data
- Chapter 11: Data Analytics
- Chapter 12: Physical Storage Systems
- Chapter 13: Storage and File Structure
- Chapter 14: Indexing
- Chapter 15: Query Processing
- Chapter 16: Query Optimization
- Chapter 17: Transactions
- Chapter 18: Concurrency Control
- Section 18.8 (Snapshot Isolation), Section 18.9 (Weak Levels of Consistency)
may be omitted.
- Chapter 19: Recovery System
- Section 19.8 (ARIES) may be omitted.
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.
Last updated Feb 2019.
