CTP206 - Database Management Systems
2012 - 2013 Fall

Department of Computer Technology and Programming
(Last updated: 10/09/2008)   (CWPS ver: 2.0.2)
Füsun YürütenCeylan Okuyucu
Instructors: Füsun Yürüten
Ceylan Okuyucu
Assistant: Ceylan Okuyucu
E-mail: fusun@ctp.bilkent.edu.tr
Lecture: Tue 10:40-12:30 GZ54. Fri 10:40-12:30 GZ55
Lab: Mon 8:40-10:30 GB53
Grading:    
    Quiz 1: 5%
    Quiz 2: 5%
    Lab Exam 1: 25%
    Midterm 1: 20%
    Homework 1: 5%
    Final: 40%

Textbooks and Other Materials:
  • Required: "LECTURE NOTES", Füsun Yürüten, 2006
  • Recommended: "Fundamentals of Database Systems", ELMASRI / NAVATHE, 2004, ISBN: 0-321-20448-4
    Detailed Weekly Course Outline:
    Week Date Subjects Lab Topics
    1 13/09/2012
    17/09/2012
    Introduction
    Advantages of DBMS
    NO LAB  
    2 20/09/2012
    24/09/2012
    Relational databases, data models
    Referential Integrity
    1. Getting familiar with ORACLE.
    2. Security Manager.
    3. Creating tables by using Schema Manager and SQL Commands
    4. Foreign Key
     
    3 27/09/2012
    01/10/2012
    BAYRAM BAYRAM  
    4 04/10/2012
    08/10/2012
    SQL as Data Definition Language 1. Creating tables by using SQL Plus Worksheet.
    2. Using SQL Commands.
    3. Date Types
    4. Sequence Numbers
    5. Creating View.
    6. Cascade on Delete  
    5 11/10/2012
    15/10/2012
    SQL as Data Manipulation Language
    1. Study on SQL
    2. Fundamentals of the PL/SQL programming language  
    6 18/10/2012
    22/10/2012
    Relational Algebra
    Quiz 1
    1. Write and Execute PL/SQL programs in SQLPlus Worksheet  
    7 25/10/2012
    29/10/2012
    Complex solutions int R.A.
    Quiz 2
    1. Oracle Forms  
    8 01/11/2012
    05/11/2012
    Normalization
    E-R Diagram Basics
    1. Oracle Forms.
    2. Master-Detail Relationships  
    9 08/11/2012
    12/11/2012
    MIDTERM MIDTERM WEEK  
    10 15/11/2012
    19/11/2012
    E-R Diagrams 1. Creating a List Of Values (LOV)
    2. Representing Data values Using Other Item Types
    (Check Box, List Item, Radio Button)
     
    11 22/11/2012
    26/11/2012
    Transaction Properties
    Transaction Management
    1. Form Triggers  
    12 29/11/2012
    03/12/2012
    Why do we need Concurrency Control?
    Concurrency Control Mechanisms
    Deadlocks
    1. Form Triggers with Master - Detail Relationship  
    13 06/12/2012
    10/12/2012
    BAYRAM BAYRAM  
    14 13/12/2012
    17/12/2012
    Crash Recovery Management
    Recovery Operations
    1. Review  
    15 20/12/2012
    24/12/2012
    Current trends, Distributed Databases
    Hierarchical Db, OODB
    LABEXAM
    LAB EXAM  

    Lab Guides and Solutions
  • Lab Guides  
    End of CTP206 main page.