CS 352 DATABASE MANAGEMENT SYSTEMS

SPRING 2008 

ANNOUNCEMENTS

CLASSES
bullet Section 1: Monday 10:40, 11:40; Thursday 8:40, 9:40           (EB204)
bullet Section 2: Monday 15:40, 16:40; Thursday 13:40, 14:40        (EB204)
bullet Section 3: Tuesday 8:40, 9:40; Thursday 10:40, 11:40           (EB204)

HOMEWORK SESSIONS

bullet

All Sections: Thursday 17:30, 18:30    (BZ01, BZ02, BZ03, BZ04, BZ05)

INSTRUCTORS
bullet

Sections 1, 2: Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr)

 Office hours: Tuesday 8:40, 9:40  (EA412)

bullet

Section 3: Cengiz Çelik (ccelik@cs.bilkent.edu.tr)

Office hours: Wednesday 15:40, 16.40  (EA421)

 TEACHING ASSISTANTS

bullet Ismail Sengör Altıngövde, Engin Demir, Rıfat Özcan

OBJECTIVES

bullet Understand the concepts underlying the design and implementation of database systems.
bullet Establish a solid background in data management, with a focus on relational database management systems.
bullet Learn a relational query language (SQL) in detail for database programming.
bullet Practice actual database design, implementation, and query formulation through a term project.
bullet Develop teamwork and communication skills through the course project, which is implemented by a group of several students.

COURSE OUTLINE

bullet An Overview of Relational Algebra (Chap.4)
bullet The Data Manipulation Language SQL (Chap.5)
bullet Advanced Features of SQL (Chap.5)
bullet Query By Example: QBE (Online Chapter)
bullet Database Application Development (Chap.6)
bullet Internet Applications (Chap.7)
bullet Relational Database Design (Chap.19)
bullet Functional Dependency Theory (Chap. 19)
bullet Normalization of Relations (Chap.19)
bullet Query Processing (Chap 12, 14)
bullet Query Optimization (Chap.14-15)
bullet Transactions, Transaction Processing (Chap.16)
bullet Concurrency Control, Serializability (Chap.17)
bullet Locking, Time-Stamping, Optimistic Method (Chap.17)
bullet Crash Recovery (Chap.18)

TYPICAL GRADING

bullet Midterm: 25% (April 9, 2008)
bullet Term project: 20%
bullet Homeworks: 20%
bullet Attendance: 5%
bullet Final: 30%

TEXTBOOK & REFERENCES

Required Textbook Database Management Systems , 3rd Edition R. Ramakrishnan,J. Gehrke Mc Graw Hill 2003
Recommended Textbook Database Systems, The Complete Book Hector Garcia-Molina,Jeffrey D. Ullman, Jennifer Widom Prentice Hall 2002
Recommended Textbook An Introduction to Database Systems, 8th Edition C.J. Date Addison-Wesley 2004
Recommended Textbook Fundamentals of Database Systems, 3rd Edition Ramez Elmasri, Shamkant B. Navathe Addison Wesley 2000
Recommended Textbook An Introduction to Database Systems Bipin C. Desai West Publishing Co. 1990

You can download lecture slides from: 

http://www.cs.wisc.edu/~dbbook/openAccess/thirdEdition/slides

WARNING :

    Plagiarism is defined as the action of using or copying someone else's idea or work and pretending that you thought of it, or created it. Bilkent University requires that you be aware of the concept and dangers of plagiarism. In order to conform to international academic standards, you must respect the individual thoughts, ideas, and expressions of other authors in sources.
    In the homeworks and projects in this course, occurrences of plagiarism will be seriously dealt with, leading to punishment through disciplinary procedures which call for a term or two terms of dispelling from the university.  (Ogrenci Disiplin Ilke ve Kurallari, Madde 8)
    You may discuss and exchange ideas related to homework problems and the various aspects of the term project among yourselves, you may consult to relevant books and other forms of written material, but the final work must be your own, with references to the sources utilized.