CTE304 - Database Management Systems
2012 - 2013 Fall

Department of Computer and Instructional Technology Teacher Education
(Last updated: 09/09/2008)   (CWPS ver: 2.0.2)
Füsun YürütenCeylan Okuyucu
Instructors: Füsun Yürüten
Ceylan Okuyucu
Assistant: Engin Kıraçbedel
E-mail: fusun@ctp.bilkent.edu.tr
Lecture: Mon 13:40-15:30, GZ06. Tue 13:40-15:30, GZ52
Lab: Wed 10:40-12:30 GB15 (Lab2)
Grading:    
    Quiz 1: 5%
    Quiz 2: 5%
    Midterm 1: 20%
    Lab Exam 1: 25%
    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
    NOLAB  
    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
     
    3 27/09/2012
    01/10/2012
    BAYRAM Bayram  
    4 04/10/2012
    08/10/2012
    SQL as Data Definition Language 1. Using SQL Commands
    1. Creating tables by using SQL Plus Worksheet.
    2. Using SQL Commands.
    3. Date Types
     
    5 11/10/2012
    15/10/2012
    SQL as Data Manipulation Language
    1. Study on SQL  
    6 18/10/2012
    22/10/2012
    Relational Algebra
    Quiz 1
    1. Fundamentals of the PL/SQL programming language
    2. Write and Execute PL/SQL programs in SQLPlus Worksheet  
    7 25/10/2012
    29/10/2012
    Complex solutions int R.A.
    Normalization
    Quiz 2
    1. Oracle Forms  
    8 01/11/2012
    05/11/2012
    MIDTERM MIDTERM  
    9 08/11/2012
    12/11/2012
    Normalization
    E-R diagrams basics
    1. Oracle Forms.
    2. Master-Detail Relationships  
    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 Management
    Transaction Properties
    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  
    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
    LABEXAM  

  • Lab Guides  
    End of CTE304 main page.