Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
DATABASE MANAGEMENT SYSTEMS ABY209 3. Semester 0 + 0 0 5.0

Prerequisites None

Language of Instruction Turkish
Course Level Associate's Degree
Course Type Compulsory
Mode of delivery Theory+Application
Course Coordinator
Instructors ANKUZEF ANKUZEF
Assistants
Goals The aim of this course is to enable students to understand the architecture of the current database management systems and the methods used in designing the database system solutions to real world problems.
Course Content Entries to the database. Database design. Relational and logical database models. Query processing and optimization. Distributed databases, data processing, recycling, and recovery and timing control. Security and validity limitations. Extended relational, object-oriented database systems and experts. Current research topics.
Learning Outcomes 1) Designs and implements database systems for different problems.
2) Makes queries and updates on the databases.
3) Makes data modeling.

Weekly Topics (Content)
Week Topics Teaching and Learning Methods and Techniques Study Materials
1. Week Veritabanları ve veritabanı kullanıcıları Databases and Database users Lecture

 Presentation (Including Preparation Time)
2. Week Database system concepts and architecture Lecture

 Presentation (Including Preparation Time)
3. Week Relational data model and relational database constraints Lecture

 Presentation (Including Preparation Time)
4. Week Basic SQL Lecture

 Presentation (Including Preparation Time)
5. Week Advanced SQL Lecture

 Presentation (Including Preparation Time)
6. Week Data modelling with ER model Lecture

 Presentation (Including Preparation Time)
7. Week Data modelling with EER models Lecture

 Presentation (Including Preparation Time)
8. Week Practical database design methodology and use of UML diagrams Lecture

 Presentation (Including Preparation Time)
9. Week Object and object-relational databases Lecture

 Presentation (Including Preparation Time)
10. Week Extended makup language Lecture

 Presentation (Including Preparation Time)
11. Week Information retrieval and web search Lecture

 Presentation (Including Preparation Time)
12. Week Data mining Lecture

 Presentation (Including Preparation Time)
13. Week Data warehouses and OLAP Lecture

 Presentation (Including Preparation Time)
14. Week Project Question Answer

Project Based Learning 		Project (Including Preparation and presentation Time)
15. Week Project Question Answer; Problem Solving
Brainstorming
 Project (Including Preparation and presentation Time)
16. Week Final Exam Question Answer; Problem Solving
Brainstorming
Problem Based Learning 		Presentation (Including Preparation Time)

Sources Used in This Course
Recommended Sources
Fundamentals of Database Systems 6th edition by Elmasri and Navathe

Relations with Education Attainment Program Course Competencies
Program RequirementsContribution LevelDK1DK2DK3
PY15555
PY25555
PY35555
PY45555

*DK = Course's Contrubution.
0 1 2 3 4 5
Level of contribution None Very Low Low Fair High Very High
.

ECTS credits and course workload
Event Quantity Duration (Hour) Total Workload (Hour)
Course Duration (Total weeks*Hours per week) 14 3
Project (Including Preparation and presentation Time) 2 20
Activity (Web Search, Library Work, Trip, Observation, Interview etc.) 10 16
Total Workload
Total Workload / 30 (s)
ECTS Credit of the Course
Quick Access Hızlı Erişim Genişlet
Course Information
  • Course Information
  • Weekly Topics (Content)
  • Sources Used in This Course
  • Relations with Education Attainment Program Course Competencies
  • ECTS credits and course workload