COURSE DESCRIPTION
CMPE 321 INTRODUCTION TO DATABASE SYSTEMS
Spring 2006

Course Description:

Most of the important issues related to databases and database management systems are covered at an introductory level. The approach taken is practical and intuitive understanding of the material is emphasized. Through out the course the relational model is stressed. Other important data models are also explained briefly. SQL, a standard query language for relational model is also emphasized. The assignments cover both the design and also the use of a database management system.

Prerequisites by topic: Data Structures and their related algorithms
                                       Knowledge of C/C++ or Java programming language

Recommended Books:

                         Fundamentals of Database Systems, Elmasri and Navathe, Addison Wesley

                         Database Management Systems, Ramakrishnan and Gehrke, McGraw Hill

                         Database Systems (The Complete Book), Garcia-Molina, Ullman, Widom, 

                         Prentice Hall     

Instructor:  Taflan I. Gundem

                      telephone:6605
                      e-mail: gundemboun.edu.tr
                      office hours: Monday 17:15-18:30; Wednesday 17:15-18:30; Friday 17:00-18:00

Teaching Assistant:  Arzucan Özgur

                                      telephone: 7095
                                      e-mail: ozgurarcmpe.boun.edu.tr

                                      office hours: Monday 15:00-17:00                           

Topics Covered:

1.      Introduction to and basic concepts of database and database management systems

2.      The physical level of databases

3.      An overview of relational databases

4.      Relational algebra and relational calculus

5.      SQL data definition and manipulation language

6.      Logical design of relational databases

7.      Views

8.      Relational integrity rules

9.      Query optimization

10.   Recovery and concurrency in database

11.  Introduction to XML

12.   Introduction to deductive and object-oriented databases

Projects:

1. Design of a simple storage manager
2. Implementation of the simple storage manager
3. Design and implementation of a web based relational database using a commercial database management system

Basis for Evaluation:

First Midterm         20%
Second Midterm    20%
Projects                   26%
Final Exam               34%