CTP225 - Introduction to DBMS
2012 - 2013 Fall

Department of Computer Technology and Programming
(Last updated: 30/03/2007)   (CWPS ver: 2.0.2)
Instructor:
E-mail: russell@ctp.bilkent.edu.tr
Lecture: [Thursday 8:40 - 10:30, GZ54] / [Friday 10:40 - 12:30, GZ54]
Lab: N/A
Grading:    
    Quiz 1: 10%
    Quiz 2: 10%
    Homeworks: 15%
    Midterm 1: 25%
    Final: 40%

COURSE DESCRIPTION:
This course is designed as an introduction to relational database concepts. Topics include: record storage and primary file organization, index structure for files, databases and database users, database system concepts and architecture, Entity-Relationship(ER) and Enhanced E-R(EER) models.
Textbooks and Other Materials:
  • Required: "Fundamentals of Database Systems, Fourth Edition", Ramez Elmasri and Shamkant B. Navathe, 2003, ISBN: 0-321-20448-4
    Detailed Weekly Course Outline:
    Week Date
    1 13/09/2012
    17/09/2012
    • Secondary Storage Devices, Buffering, and Operations on Files
    • Placing Records on Disks, Operations on Files, Exercises
    • Review Questions
    2 20/09/2012
    24/09/2012
    • File Organizations and Hashing Techniques
    3 27/09/2012
    01/10/2012
    4 04/10/2012
    08/10/2012
    • Multilevel Indexing of Files - Examples
    • B-Trees
    • B+ Trees
    5 11/10/2012
    15/10/2012
    • Database Concepts
    6 18/10/2012
    22/10/2012
    7 25/10/2012
    29/10/2012
    • Database Design Process
    8 01/11/2012
    05/11/2012
    Midterm Week - Midterm 1
    9 08/11/2012
    12/11/2012
    10 15/11/2012
    19/11/2012
    11 22/11/2012
    26/11/2012
    MID SEMESTER BREAK
    12 29/11/2012
    03/12/2012
    13 06/12/2012
    10/12/2012
    • Monday - Holiday, No Class
    • Database Design - Conceptual Design to Implementation
    14 13/12/2012
    17/12/2012
    • Project Example and In Class Exercises
    15 20/12/2012
    24/12/2012
    • Final Exam Review/End of Semester

  • Chapter 2 Notes  
  • Chapter 3 Notes: Part 1  
  • Chapter 3 Notes: Part 2  
  • Chapter 4 Part 1  
  • Chapter 4 Notes Part 2  
  • Chapter 7 Notes  
  • Chapter 7 Mapping Text Notes  
  • Chapter 13 Notes  
  • Chapter 14 - Single Level Indexing  
  • Chapter 14 - MultiLevel Indexes  
  • Chapter 14 - B Trees  
  • Chapter 14 - B+ Trees  
  • Homework 3 Question  
    End of CTP225 main page.