CS 352 DATABASE MANAGEMENT SYSTEMS
SPRING 2008
CLASSES
|
|
Section 1: Monday 10:40, 11:40; Thursday 8:40, 9:40 (EB204) |
|
|
Section 2: Monday 15:40, 16:40; Thursday 13:40, 14:40 (EB204) |
|
|
Section 3: Tuesday 8:40, 9:40; Thursday 10:40, 11:40 (EB204) |
HOMEWORK SESSIONS
|
|
All Sections: Thursday 17:30, 18:30 (BZ01, BZ02, BZ03, BZ04, BZ05) |
INSTRUCTORS
|
|
Sections 1, 2: Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr) Office hours: Tuesday 8:40, 9:40 (EA412) |
|
|
Section 3: Cengiz Çelik (ccelik@cs.bilkent.edu.tr) |
Office hours: Wednesday 15:40, 16.40 (EA421)
TEACHING ASSISTANTS
|
|
Ismail Sengör Altıngövde, Engin Demir, Rıfat Özcan |
|
|
Understand the concepts underlying the design and implementation of database systems. |
|
|
Establish a solid background in data management, with a focus on relational database management systems. |
|
|
Learn a relational query language (SQL) in detail for database programming. |
|
|
Practice actual database design, implementation, and query formulation through a term project. |
|
|
Develop teamwork and communication skills through the course project, which is implemented by a group of several students. |
|
|
An Overview of Relational Algebra (Chap.4) |
|
|
The Data Manipulation Language SQL (Chap.5) |
|
|
Advanced Features of SQL (Chap.5) |
|
|
Query By Example: QBE (Online Chapter) |
|
|
Database Application Development (Chap.6) |
|
|
Internet Applications (Chap.7) |
|
|
Relational Database Design (Chap.19) |
|
|
Functional Dependency Theory (Chap. 19) |
|
|
Normalization of Relations (Chap.19) |
|
|
Query Processing (Chap 12, 14) |
|
|
Query Optimization (Chap.14-15) |
|
|
Transactions, Transaction Processing (Chap.16) |
|
|
Concurrency Control, Serializability (Chap.17) |
|
|
Locking, Time-Stamping, Optimistic Method (Chap.17) |
|
|
Crash Recovery (Chap.18) |
|
|
Midterm: 25% (April 9, 2008) |
|
|
Term project: 20% |
|
|
Homeworks: 20% |
|
|
Attendance: 5% |
|
|
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.