Database Management System (CSC265) — Notes, Syllabus & Past Questions

Relational database design, SQL querying, and transaction integrity.

Core Course10 Chapters
Chapter 18 Pages

Database and Database Users

Introduction; Characteristics of the Database Approach; Actors on the Scene; Workers behind the Scene; Advantages of Using the DBMS Approach.

Read Notes
Chapter 212 Pages

Database System – Concepts and Architecture

Data Models, Schemas, and Instances, Three-Schema Architecture and Data Independence, Database Languages and Interfaces, the Database System Environment.

Read Notes
Chapter 313 Pages

Data Modeling Using the Entity-Relational Model

Using High-Level Conceptual Data Models for Database Design, Entity Types, Entity Sets, Attributes, and Keys, Relationship Types, Relationship Sets, Roles, and Structural Constraints.

Read Notes
Chapter 46 Pages

The Relational Data Model and Relational Database Constraints

Relational Model Concepts; Relational Model Constraints and Relational Database Schemas; Update Operations, Transactions, and Dealing with Constraint Violations.

Read Notes
Chapter 513 Pages

The Relational Algebra and Relational Calculus

Unary Relational Operations: SELECT and PROJECT, Relational Algebra Operations from Set Theory, Binary Relational Operations: JOIN and DIVISION, Additional Relational Operations.

Read Notes
Chapter 612 Pages

SQL

Data Definition and Data Types; Specifying Constraints; Basic Retrieval Queries; Complex Retrieval Queries; INSERT, DELETE, and UPDATE Statements; Views.

Read Notes
Chapter 718 Pages

Relational Database Design

Relational Database Design Using ER-to-Relational Mapping, Informal Design Guidelines for Relational Schemas, Functional Dependencies, Normal Forms Based on Primary Keys.

Read Notes
Chapter 810 Pages

Introduction to Transaction Processing Concepts and Theory

Introduction to Transaction Processing, Transaction and System Concepts, Desirable Properties of Transactions, Characterizing Schedules Based on Recoverability.

Read Notes
Chapter 99 Pages

Concurrency Control Techniques

Two-Phase Locking Technique; Timestamp Ordering; Multiversion Concurrency Control; Validation (Optimistic) Techniques and Snapshot Isolation Concurrency Control.

Read Notes
Chapter 106 Pages

Database Recovery Techniques

Recovery Concepts; NO-UNDO/REDO Recovery Based on Deferred Update; Recovery Technique Based on Immediate Update; Shadow Paging; Database Backup and Recovery from Catastrophic Failures.

Read Notes

Related Study Resources for Database Management System (CSC265)

Subject HubDatabase Management System (CSC265)Official CurriculumDatabase Management System SyllabusTU Board PapersDatabase Management System Past QuestionsSemester Directory4th Sem Subjects