Deniz Çelikel — Middle East Technical University

STAT 311 — Modern Database Systems

Wed 12:40–15:30 (P4) · Thu 15:40–16:30 (YP‑B201)

Term

Lecture Notes

• Lecture 1 Chapter 1 – Database and Database Users
• Lecture 1 Chapter 2 – Database System Concepts and Architecture
• Lecture 2 Chapter 3 – Data Modeling Using the Entity–Relationship (ER) Model
• Lecture 2 – Activity Coffee Shop
• Lecture 3 Chapter 4 – The Enhanced Entity–Relationship (EER) Model
• Lecture 3 Chapter 5 – The Relational Data Model and Relational Database Constraints
• Lecture 3 – Activity UNIVERSITY
• Lecture 4 Chapter 6 – Basic SQL
• Lecture 4 – Activity Stat311 Queries
• Lecture 5 Chapter 7 – More SQL
• Lecture 6 Chapter 8 – The Relational Algebra and Relational Calculus
• Lecture 7 Chapter 9 – Relational Database Design & Relational Mapping
• Lecture 8 Chapter 10 – Introduction to SQL Programming Techniques
• Lecture 8 Chapter 11 – Web Database Programming Using PHP
• Lecture 9 – PHP Example Simple PHP Script: Displaying a Student Record
• Lecture 9 – HTML Simulation Recreating the PHP Example Using JavaScript
• Lecture 9 – HTML Simulation 2 Edit Mode + CSV/XML Loading
• Lecture 9 – CSV Database Simulation Next/Previous Navigation + Database Logic
• Lecture 9 – Objects Object-Oriented Student Representation
• Lecture 9 – Inheritance Student vs. GraduateStudent Example
• Lecture 9 – Composite Types Nested Objects: Address + Contact
• Lecture 9 – Collections Course Lists, Maps & Derived Data
• Lecture 9 – XML Example XML Representation & Parsing of Student Records
• Lecture 10 Chapter 14-30 & Normalization, Big Data, Data Mining

2025-2026 Fall