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 Engineering
  • Department of Computer Engineering (English)
  • Course Structure Diagram with Credits
  • Database Management Systems
  • Description
  • Description
  • Learning Outcomes
  • Course's Contribution to Prog.
  • Learning Outcomes & Program Qualifications

Course Introduction Information

Code - Course Title BİM216 - Database Management Systems
Course Type Required Courses
Language of Instruction İngilizce
Laboratory + Practice 2+2
ECTS 5.0
Course Instructor(s) DOKTOR ÖĞRETİM ÜYESİ BURCU YILMAZEL
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 None.
Required or Recommended Resources \"Fundamentals of Database Systems\" by Ramez Elmasri, and Shamkant B. Navathe, Sixth Edition.\"Database Systems: The Complete Book\" by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, 2nd Edition.\"Database Management Systems\" by Raghu Ramakrishnan, and Johannes Gehrke
Recommended Reading List \"Fundamentals of Database Systems\" by Ramez Elmasri, and Shamkant B. Navathe, Sixth Edition.\"Database Systems: The Complete Book\" by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, 2nd Edition.\"Database Management Systems\" by Raghu Ramakrishnan, and Johannes Gehrke
Assessment methods and criteria There are 2 Midterms, 1 Final, and a Term-Project.
Work Placement Students as a group are expected to design and implement a database project that they can come across in many areas of daily life.
Sustainability Development Goals Quality Education , Industry, Innovation and Infrastructure

Content

Weeks Topics
Week - 1 Introduction to Databases and Database Management Systems
Week - 2 The Relational Model of Data & Database Design Process
Week - 3 The Entity-Relationship (E/R) Model
Week - 4 Advanced E/R Concepts
Week - 5 From E/R Diagrams to Relational Schema
Week - 6 Schema Refinement - Functional Dependencies
Week - 7 Schema Refinement - Normalization & Normal Forms
Week - 8 SQL Basics: Part I
Week - 9 SQL Basics: Part II
Week - 10 Relational Algebra & Query Optimization
Week - 11 More on SQL: View, Trigger, Index, Authorization & Security Design
Week - 12 Physical Schema: Storage & File Organization
Week - 13 Transactions
Week - 14 Term Project Presentations

Learning Activities and Teaching Methods

  • Teaching Methods
  • Lecture
  • Question & Answer
  • Team/Group Work
  • Drill - Practise
  • Problem Solving
  • Report Preparation and/or Presentation
  • Competences
  • Productive
  • Rational
  • Questoning
  • Creative
  • Follow ethical and moral rules
  • Effective use of a foreign language
  • Work in teams
  • Use time effectively
  • Eleştirel düşünebilme
  • Problem solving
  • Applying theoretical knowledge into practice
  • Information Management
  • To work autonomously
  • Organization and planning
  • Decision making
  • Project Design and Management

Assessment Methods

Assessment Method and Passing Requirements
Quamtity Percentage (%)
Toplam (%) 0
  • 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
  • Doctorate Degree / Proficieny in Arts
  • Master's Degree
  • Bachelor's Degree
  • Associate Degree
  • Open&Distance Education
  • 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