CTE204 - Introduction to Database Management Systems
2012 - 2013 Fall

Department of Computer and Instructional Technology Teacher Education
(Last updated: 16/04/2007)   (CWPS ver: 2.0.2)
CTEP 204 Project Presentation Schedule

Instructor:
E-mail: russell@ctp.bilkent.edu.tr
Lecture: [Monday 13:40 - 15:30, GZ07] / [Thursday 13:40 - 15:30, GZ55]
Lab: N/A
Grading:    
    Quiz 1: 10%
    Quiz 2: 10%
    Project: 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.
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
  • Review Questions
2 20/09/2012
24/09/2012
  • File Organizations - Ordered Files, Unordered Files
  • File Operations - Inserting and Deleting
  • Hashing - Internal Hashing
  • External Hashing - Static and Dynamic Hashing
3 27/09/2012
01/10/2012
  • Linear Hashing, Extendible Hashing Example
  • Indexes - Primary, Secondary, Clustering
4 04/10/2012
08/10/2012
5 11/10/2012
15/10/2012
  • Index Review
  • Relational Database Model- Terminology and Concepts
6 18/10/2012
22/10/2012
  • Characteristics of Database Approach
  • Databases and Database users
  • Database Management Systems (DBMS) Advantages
  • UNIVERSITY Database
7 25/10/2012
29/10/2012
  • DBMS Concepts and Architecture -
  • Data Models, Schemas and Instances
  • Three Schema Architecture
  • Database Languages and Interfaces
  • DBMS Environment
  • Two-Tier/Three-Tier Architecture
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
  • Database Design - Conceptual Design to Implementation
14 13/12/2012
17/12/2012
  • Object-Oriented Databases
  • Project Presentations
15 20/12/2012
24/12/2012
  • Presentations Continued
  • End of Semester Review

  • Chapter 1 Notes  
  • 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  
  • Project Description  
    End of CTE204 main page.