Eskisehir Technical University Info Package Eskisehir Technical University Info Package
  • Info on the Institution
  • Info on Degree Programmes
  • Info for Students
  • Türkçe
About the Program Educational Objectives Key Learning Outcomes Course Structure Diagram with Credits Field Qualifications Matrix of Course& Program Qualifications Matrix of Program Outcomes&Field Qualifications
  • Faculty Of Computer And Information Technologies
  • Information Systems And Technologies (English)
  • Course Structure Diagram with Credits
  • Database Management Systems
  • Description
  • Description
  • Learning Outcomes
  • Course's Contribution to Prog.
  • Learning Outcomes & Program Qualifications
  • ECTS Credit Load

Course Introduction Information
Code - Course Title BBB2007 - Database Management Systems
Course Type Required Courses
Language of Instruction İngilizce
Laboratory + Practice 3+0
ECTS 4.0
Course Instructor(s) DOKTOR ÖĞRETİM ÜYESİ ÖZGÜR GÜLTEKİN
Mode of Delivery The mode of delivery of this course is Face to face.
Prerequisites There is no prerequisite or co-requisite for this course.
Courses Recomended There is no recommended optional programme component for this course.
Required or Recommended Resources Coronel, C., & Morris, S. (2023). Database systems: Design, implementation, and management (14th ed.). Cengage Learning.
Elmasri, R., & Navathe, S. B. (2015). Fundamentals of database systems (7th ed.). Pearson.
Recommended Reading List Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database system concepts (7th ed.). McGraw-Hill Education.
Assessment methods and criteria 1 Midterm Exam, 1 Project, 1 Final Exam
Work Placement N/A
Sustainability Development Goals Quality Education , Decent Work and Economic Growth , Industry, Innovation and Infrastructure

Content

Weeks Topics
Week - 1 Introduction to Database Systems: Basic Concepts and Architectures
Week - 2 Entity-Relationship (ER/EER) Modeling and Schema Design
Week - 3 Relational Data Model and Transition to Database Design
Week - 4 Database Design: Normalization Rules and Constraints
Week - 5 Relational Database Queries: Data Definition (DDL) and Manipulation (DML) Languages
Week - 6 Relational Database Queries: Data Definition (DDL) and Manipulation (DML) Languages
Week - 7 Advanced Queries 1: Table Join (JOIN) Operations
Week - 8 Advanced Queries 2: Subqueries and Grouping Functions
Week - 9 Database Objects 1: Views and Indexing Architecture
Week - 10 Database Objects 2: Stored Procedures and Functions
Week - 11 Database Objects 3: Triggers and Active Database Rules
Week - 12 Transaction Management (ACID Properties) and Concurrency Control
Week - 13 Database Security: Access Control, SQL Vulnerabilities and Security Principles
Week - 14 Modern Database Approaches: Non-Relational (NoSQL) and Graph Database Models

Learning Activities and Teaching Methods

  • Teaching Methods
  • Lecture
  • Discussion
  • Question & Answer
  • Demonstration
  • Case Study
  • Problem Solving
  • Brain Storming
  • Report Preparation and/or Presentation
  • Competences
  • Productive
  • Rational
  • Questoning
  • Creative
  • Effective use of a foreign language
  • Eleştirel düşünebilme
  • Abstract analysis and synthesis
  • Problem solving
  • Applying theoretical knowledge into practice
  • Information Management
  • To work autonomously
  • Organization and planning
  • Decision making

Assessment Methods

Assessment Method and Passing Requirements
Quamtity Percentage (%)
1.Midterm Exam 1 30
Project 1 30
Final Exam 1 40
Toplam (%) 100
  • Info on the Institution
  • Name and Adress
  • Academic Calendar
  • Academic Authorities
  • General Description
  • List of Programmes Offered
  • General Admission Requirements
  • Recognition of Prior Learning
  • Registration Procedures
  • ECTS Credit Allocation
  • Academic Guidance
  • Info on Degree Programmes
  • PhD / Proficiency in Art
  • Master's Degree
  • Bachelor's Degree
  • Associate Degree
  • Info for Students
  • Cost of living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Special Needs Students ı
  • Insurance
  • Financial Support for Students
  • Student Affairs Office
  • Info for Students
  • Learning Facilities
  • International Programmes r
  • Practical Information for Mobile Students
  • Language courses
  • Internships
  • Sports and Leisure Facilities
  • Student Associations