CS353 DATABASE SYSTEMS
FALL 2013
CLASSES
|
|
Section 1: Monday 10:40, 11:40; Thursday 9:40 (EB204) |
|
|
Section 2: Monday 10:40, 11:40; Thursday 9:40 (BZ04) |
INSTRUCTORS
|
|
Section 1: Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr) |
Office hours: Wednesday 15:40 -- 17:30 (EA402)
|
|
Section 2: Hakan Ferhatosmanoğlu (hakan@cs.bilkent.edu.tr) |
Office hours: Thursday 10:40 -- 12:00 (EA412)
TEACHING ASSISTANTS
|
|
Arif Usta, Kaan Bingöl, Ayça Işıksal |
|
|
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. |
|
|
Practice actual database design, implementation, and query formulation through a term project. |
|
|
Relational Data Model (Chapters 1, 2) |
|
|
Entity/Relationship Model (Chapter 7) |
|
|
Relational Algebra (Chapter 6) |
|
|
Structured Query Language, SQL (Chapters 3, 4) |
|
|
Database Application Development (Chapter 9) |
|
|
Relational Database Design (Chapter 8) |
|
|
File Organization (Chapter 10) |
|
|
Tree-Structured Indexing (Chapter 11) |
|
|
Hash-Based Indexing (Chapter 11) |
|
|
Query Processing (Chapter 12) |
|
|
Query Optimization (Chapter 13) |
|
|
Overview of Transaction Management (Chapter 14) |
|
|
Midterm 1: 20% (November 5, 2013) |
|
|
Midterm 2: 20% (December 4, 2013) |
|
|
Term project: 20% |
|
|
Homeworks & Attendance: 10% |
|
|
Final: 30% |
Minimum Requirements to Qualify for the Final Exam
In order to qualify for the Final Exam, the average of two Midterm Exams must be at least 40 out of 100.
Regular attendance at classes is required for successful completion of 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 System Concepts, 6th edition | A. Silberschatz; H. Korth; S. Sudarshan | McGraw- Hill | 2011 |
| Recommended | Textbook | Database Management Systems, 3rd Edition | R. Ramakrishnan, J. Gehrke | McGraw- 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 |
You can download lecture slides from:
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.