Deney Föyü 3
Database Management Systems - Student Workbook 1
Deney Föyü
1.09.2025
This workbook contains 20 applied SQL scenarios designed for in-class practice and self-study. Each section presents a realistic business or database scenario, provides detailed explanations, and leaves space for you to write the SQL statement. All scenarios are based on the W3Schools Sample Database.
Database Management Systems - Student Workbook 2
Deney Föyü
1.09.2025
In this lab, you will build a complete course registration system using SQLite. You will:
- Create tables with primary and foreign keys,
- Model many-to-many relationships,
- Insert and query data,
- Modify a schema using ALTER TABLE,
- Add a new related table and update existing ones.
Database Management Systems- Transaction and Concurrency Control
Deney Föyü
1.09.2025
The objective of this laboratory session is to examine Transaction management, ACID principles, and Locking mechanisms on PostgreSQL. Students will observe how the database handles concurrent access, conflicts, and isolation anomalies through practical scenarios.
Sunum 1
KPDS - Student Guidance
Sunum
2.09.2024