Database System Concepts
Seventh Edition
- Avi Silberschatz
- Henry F. Korth
- S. Sudarshan
Suggested Syllabus for a One Semester Applications Oriented Course
The following syllabus is designed for a course where the goal is to
teach students how to use databases to construct applications.
Details of database internals are kept to the minimum.
Chapters
- Chapter 1: Introduction
- Chapter 2: Introducation to Relational Languages
- Chapter 3: Intoduction to SQL
- Chapter 4: Intermediate SQL
- Chapter 5: Advanced SQL
- Sections 5.4 onwards can be deferred or 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
-
Sections 12.5 (RAID) may be omitted if desired.
- Chapter 13: Storage and File Structure
- Chapter 14: Indexing and Hashing
- Chapter 15: Query Processing
- Section 15.1 (Overview) should be covered.
We suggest you cover Section 15.2 (Measures of Query Cost)
as well as Section 15.5 (Join Operation) as far as time permits.
- Chapter 17: Transactions
Assignments/Project
The course should be supplemented by assignments and a project.
The assignments are to get students familiar with
using databases, running queries and using application development
tools.
The project could involve the design of a schema for a realistic
application, and the implementation of the entire application
using SQL and language/APIs such as Java servlets/JSP,
C# ASP, or PHP. See Chapter 9 for some suggestions
on project topics.
Last updated Feb 2019.
