COURSE DESCRIPTION
CMPE 321 INTRODUCTION TO DATABASE SYSTEMS
Spring 2004

Course Description:

Most of the important issues related to databases and database management systems are covered at an introductory lavel. The approach taken is practical and intuitive understanding of the material is emphasized. Through out the course the relational model is stressed. the 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 programming language

Textbook: C. J. Date, An Introduction to Database Systems, vol. 1, 4th or higher edition, Adison Wesley

Instructor:  Taflan I. Gundem
                    e-mail: gundemboun.edu.tr
                    office hours: Monday 14:00-17:30; Wednesday 16:50-17:30; Friday 16:50-17:30

Teaching Assistant:  Arzucan Ozgur
                                   e-mail: ozgurarcmpe.boun.edu.tr
                                   office: ETA 203 (ext.2183)

Topics Covered:

1. Introduction to and basic concepts of databse and database management systems
2. The physical level of databases
3. An overview of relational databases and DB2
4. SQL data definition and manipulation language
5. Data dictionary
6. Views
7. Relational integrity rules
8. Relational algebra
9. Query optimization
10. Logical design of relational databases
11. Recovery and concurrency in databases
12. Introduction to deductive and object-oriented databases

Projects:

1. Design of a simple storage manager
2. Implementation of the simple storage manager in C
3. Design of a relational database using a commercial database management system

Basis For Evaluation: