Database Management System Chapters

Introduction; Characteristics; Database users; Workers behind the scene; Advantages of DBMS.

Data models; Schemas; Three-schema architecture; Data independence; DB environment.

High-level conceptual models; Entity types; Attributes; Keys; Relationship types.

Relational concepts; Constraints; Schemas; Update operations; Transactions.

Select and project; Set theory operations; Join and division; Additional operations.

Data definition; Constraints; Retrieval queries; Insert, delete, update; Views.

ER to relational mapping; Design guidelines; Functional dependencies; Normal forms.

Transaction concepts; Properties; Schedules; Recoverability; Serializability.

Two-phase locking; Timestamp ordering; Multiversion CC; Validation; Snapshot isolation.

Recovery concepts; Deferred update; Immediate update; Shadow paging; Backup and recovery.