CS353 DATABASE SYSTEMS
SPRING 2013
CLASSES
|
|
Section 1: Tuesday 13:40, 14:40; Thursday 15:40 (EB201) |
|
|
Section 2: Monday 9:40; Wednesday 10:40, 11:40 (EB101) |
|
|
Section 3: Monday 10:40, 11:40; Thursday 9:40 (EB101) |
HOMEWORK SESSIONS
|
|
All Sections: Thursdays 17:30 -- 19:30 (BZ01, 02, 04, 05) |
INSTRUCTORS
|
|
Section 1: Hakan Ferhatosmanoğlu (hakan@cs.bilkent.edu.tr) |
Office hours: Thursday 10:40 -- 12:00 (EA412)
|
|
Sections 2, 3: Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr) |
Office hours: Tuesday 13:40 -- 15:30 (EA402)
TEACHING ASSISTANTS
|
|
Fethi Burak Sazoğlu, Çağrı Toraman, Arif Usta |
|
|
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: 25% (March 26, 2013) |
|
|
Term project: 20% |
|
|
Homeworks: 25% |
|
|
Final: 30% |
Minimum Requirements to Qualify for the Final Exam
In order to qualify for the final exam, students must attend at least 60% of all the lectures AND the average of the Midterm Exam and Homework Assignments should be at least 35 out of 100, that is:
(Midterm grade + Overall average of homeworks) / 2 ≥ 35
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.