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
- http://www.w3schools.com/sql/default.asp
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

Transactions


13. Week

Physical Schema: Storage & File Organization

Authorization & Security Design

 


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

© 1993-2017 CENG. All rights reserved.