Skip Navigation Links.

BIM312 - Database Management Systems

Instructor: Res.Asst.Dr.Burcu YÜREKLİ YILMAZEL
Teaching Assistants:
Course Book: "Database Systems: The Complete Book" by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, 2nd Edition.
Grading: 1st Midterm %20, 2nd Midterm %20, Assignments %20, Final %40
Other Resources: - "Fundamentals of Database Systems" by Ramez Elmasri, and Shamkant B. Navathe, Sith Edition
- "Database Management Systems" by Raghu Ramakrishnan, and Johannes Gehrke
Course Outline:
1. Week

Introduction to Databases and DBMSs

2. Week

The Relational Model of Data & Database Design Process

3. Week

The Entity-Relationship (E/R) Model

Advanced E/R Concepts

4. Week

From E/R Diagrams to Relational Schema

5. Week

Schema Refinement - Functional Dependencies

6. Week

Midterm I

7. Week

Schema Refinement - Normal Forms


8. Week

Relational Algebra & Relational Calculus


9. Week

SQL: Basics - Part1


10. Week

SQL - Part2

11. Week

Midterm II

12. Week

SQL: Trigger, View, Index


13. Week

Physical Schema: Storage & File Organization

Authorization & Security Design


Home | Department | Undergraduate | Graduate | Research | Continual Improvement

© 1993-2017 CENG. All rights reserved.