Deniz Çelikel — Middle East Technical University

STAT 311 — Modern Database Systems
Wed 12:40–15:30 (P4) · Thu 15:40–16:30 (YP‑B201)

Assessment

• Quiz/Homework 10%
• Project 30% + Presentation 20%
• Final Exam 40%

Syllabus (PDF)

Term

Lecture Notes

• Lecture 9 – Chapter 11 – Sample PHP - Demonstrates how a simple PHP script retrieves and displays a single student record using server-side execution.
• Lecture 9 – Chapter 11 – HTML Simulation of the PHP Example - Recreates the PHP student-record view purely in JavaScript, including form display, edit mode, and local (in-browser) updates.
• Lecture 9 – Chapter 11 – Edit Mode and Local Update Simulation (HTML Version) - Extends the HTML/JS simulation by loading student data from CSV/XML, mimicking a server-side database retrieval process.
• Lecture 9 – Chapter 11 – Database Version (CSV-based Simulation of Database Retrieval) - Shows a full “database navigation” simulation with previous/next record browsing, replicating classic server-driven page logic in JavaScript.
• Lecture 9 – Chapter 12 – Object Example - Introduces an object-oriented model for student records, using JavaScript classes to mirror PHP/Java object structures.
• Lecture 9 – Chapter 12 – Inheritance Example - Demonstrates inheritance by defining Student and GraduateStudent classes and showing how subclass objects behave differently in the UI.
• Lecture 9 – Chapter 12 – Composite (Nested) Types Example - Illustrates composite (nested) types by representing each student as a composition of Address and Contact sub-objects.
• Lecture 9 – Chapter 12 – Collections Example - Demonstrates collection types by modeling each student's courses and grades as sets, lists, and maps, and computing derived information.
• Lecture 9 – Chapter 13 – XML Example - Shows how student records can be represented, parsed, and displayed using XML — bridging structured data and UI display.

2025-2026 Fall