CS 352 DATABASE MANAGEMENT SYSTEMS
SPRING 2010
CLASSES
|
|
Section 1: Monday 10:40, 11:40; Thursday 8:40, 9:40 (EB204) |
|
|
Section 2: Tuesday 8:40, 9:40; Thursday 10:40, 11:40 (EB204) |
|
|
Section 3: Monday 8:40, 9:40; Wednesday 10:40, 11:40 (EB204) |
|
|
Section 4: Tuesday 8:40, 9:40; Thursday 10:40, 11:40 (EB101) |
HOMEWORK SESSIONS
|
|
All Sections: Tuesdays 17:30, 18:30 (BZ01, BZ02, BZ04, BZ05, BZ08, B204) |
INSTRUCTORS
|
|
Section 1: Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr) |
Office hours: Thursday 13:40, 14:40 (EA412)
|
|
Sections 2, 3: Aybar Acar (aacar@cs.bilkent.edu.tr) |
Office hours: Monday 10:40; Tuesday 10:40; Thursday 15:40, 16:40 (EA 522)
|
|
Section 4: Erol Arkun (arkun@bilkent.edu.tr) |
Office hours: Tuesday 11:00-12:00; Thursday 14:00-15:00 (EG10)
TEACHING ASSISTANTS
|
|
Rıfat Özcan, Duygu Atılgan, Muhammet Baştan, Şadiye Kaptanoğlu |
|
|
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. |
|
|
Relational Calculus (Chap.4) |
|
|
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% (March 29, 2010) |
|
|
Term project: 25% |
|
|
Homeworks: 20% |
|
|
Final: 30% |
Regular attendance at classes is required for successful completion of the course. Students who are not able to achieve 70% attendance will automatically fail the course.
Attendance will be taken by circulating a class roll during class. Signing the class roll for a student who is not present will be considered a case of academic dishonesty and will lead to punishment through disciplinary procedures.
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 exams, 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)