Information Package / Course Catalogue
Database Management Systems
Course Code: CSE202
Course Type: Required
Couse Group: First Cycle (Bachelor's Degree)
Education Language: English
Work Placement: N/A
Theory: 2
Prt.: 2
Credit: 3
Lab: 0
ECTS: 5
Objectives of the Course

To provide the basis for data handling and management To make students able to apply data management and storage optimization techniques to a given problem Write queries to manipulate data

Course Content

General information about databases and database users Database system concepts and architecture SQL and SQL programming techniques Relational algebra, relational calculus and entity-relationship (ER) model Object and object-relational databases UML and XML Functional dependencies and normalization for relational databases Relational database design algorithms Disk storage, file structures, hashing and indexing structures for files Query processing and optimization Database security & database recovery techniques Distributed databases

Name of Lecturer(s)
Lec. Denizhan DEMİRKOL
Learning Outcomes
1.Gaining the ability to design entity relationship diagrams
2.Learn relational database design in 3rd normal form
3.Learning the basic principles of the SQL programming language
4.Learn how to write efficient queries in the SQL programming language
5.Understanding basic components such as stored procedure, trigger, view, database functions
Recommended or Required Reading
1.Ramez Elmasri, Shamkant Navathe; “Fundamentals of Database Systems”, 6th Ed., Pearson, 2014.
2.Mark L. Gillenson; “Fundamentals of Database Management Systems”, 2nd Ed., John Wiley, 2012.
3.Lecture notes
Weekly Detailed Course Contents
Week 1 - Theoretical
Introduction; Data, database systems and concepts
Week 2 - Theoretical
Data modeling, relational data model, relational database model, relational calculus & algebra
Week 3 - Theoretical
Data modeling, relational data model, relational database model, relational calculus & algebra(cont.)
Week 4 - Theoretical
ER model
Week 5 - Theoretical
ER model (cont.)
Week 6 - Theoretical
Database design methodology & UML
Week 7 - Theoretical
Object & object-relational databases
Week 8 - Theoretical
XML, introduction to SQL programming
Week 9 - Theoretical
Dependencies, normalization for relational databases & relational database design
Week 10 - Theoretical
Disk storage, file structures, hashing and indexing
Week 11 - Theoretical
Query processing & optimization
Week 12 - Theoretical
Database administration, recovery, security, backup & concurrency
Week 13 - Theoretical
Database administration, recovery, security, backup & concurrency (cont.)
Week 14 - Theoretical
Distributed databases
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%20
Final Examination1%40
Quiz5%20
Assignment4%20
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory142256
Lecture - Practice140228
Assignment43012
Quiz5002
Midterm Examination110212
Final Examination113215
TOTAL WORKLOAD (hours)125
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
PÇ-8
PÇ-9
PÇ-10
PÇ-11
OÇ-1
4
4
4
5
3
2
2
3
2
3
3
OÇ-2
4
4
5
5
3
2
2
3
2
3
2
OÇ-3
4
4
3
5
2
2
2
3
2
2
2
OÇ-4
4
4
3
5
2
2
2
3
2
2
2
OÇ-5
4
4
3
5
2
2
2
3
2
3
2
Adnan Menderes University - Information Package / Course Catalogue
2026