Databases
Uploaded by
heliaghazizadehDatabases
Uploaded by
heliaghazizadehISTANBUL MEDIPOL UNIVERSITY
IMU- COE3149650 Database systems
Spring 2026
Office
Instructor : Prof. Reda Alhajj
Hours: on by appointment via email.
teams
E-mail : ralhajj@[Link]
TA’s: Sahar and Asmaa
Slides are mainly from the textbook by Elmasri & Navathe
ISTANBUL MEDIPOL UNIVERSITY
IMU- COE3149650 Database systems
Spring 2026
Course Objectives:
- To cover and emphasize on SQL databases, including data
models and query languages.
- To cover an introduction to database management systems, with
an emphasis on how to design, implement and utilize a database
system in practice by developing fully functional projects based
on state-of-the-art technology.
- To gain team working experience
- To cover how to improve a given database design
Slide 1- 2
2
ISTANBUL MEDIPOL UNIVERSITY
IMU- COE3149650 Database systems
Spring 2026
Learning Outcomes:
Upon successful completion of this course, students should be able to:
• Differentiate between files in programming languages and a database management
system
• Describe the fundamental data models, including Entity-relationship, and relational
• Explain the basic concepts of relational database design
• Design an extended ER-model to represent practical database application scenarios to be
realized as a working mobile friendly Web interface
• Code queries in relational algebra, Calculus, and SQL
• Convert the ER-model to relational tables, populate relational database and formulate
SQL queries on data.
• Improve an existing database design by normalization.
Slide 1- 3
3
ISTANBUL MEDIPOL UNIVERSITY
IMU- COE3149650 Database systems
Spring 2026
Week Material to be covered Chapters Quiz /
Assignment
W1 – 09 Feb Introduction & basic concepts 1&2
DBMS functionality & architecture
W2 – 16 Feb. Entity-Relationship model 3
W3 – 23 Feb. Extended Entity-Relationship model 4
W4 – 02 Mar. Relational data model & 5 - 9 – 8 HW#1 Due &
From EERM to Relational Model Qz#1
Introduction to Relational Algebra
W5 – 09 Mar. Relational Algebra 8
W6 – 16 Mar. Relational Algebra 8 HW#2 Due &
Qz#2
W7 – 23 Mar. SQL 6–7
28 Mar -04 Apr. Exams week to be scheduled by the university
Slide 1- 4
4
ISTANBUL MEDIPOL UNIVERSITY
IMU- COE3149650 Database systems
Spring 2026
W8 – 06 Apr. SQL
W9 – 13 Apr. SQL
W10– 20 Apr. Relational calculus 8 HW#3 Due &
Qz#3
W11 – 27 Apr. Functional Dependencies and Normalization for 14 – 15
Relational Databases
W12– 04 May Functional Dependencies and Normalization for 14 – 15 HW#4 Due &
Relational Databases Qz#4
W13– 11 May Relational Database design 14 – 15
W14 – 18 May Project Demos HW#5 Due &
Qz#5
Slide 1- 5
5
ISTANBUL MEDIPOL UNIVERSITY
IMU- COE3149650 Database systems
Spring 2026
Assessment: Quizzes (best 4 of 5; no makeup for quizzes, and short quizzes 15 %
end of lecture)
Assignments (must complete all 5 homeworks) 15 %
Project (Successful completion of the project is important) 30 %
Exam 35 %
Attendance if you miss 5 lectures you get ZERO 05 %
Final Exam – project substitutes midterm exam
Passing the exam is important and crucial to consider the marks received in quizzes and
homeworks, otherwise QZ & HWs have no value
Slide 1- 6
6