CS353 DATABASE SYSTEMS
SPRING 2018
CLASSES
§ Section 1:
Wednesday 9:40; Friday 10:40, 11:40
(EAZ03)
§
Section
2: Tuesday 9:40; Thursday 10:40, 11:40
(EAZ03)
§
Section
3: Tuesday 10:40, 11:40; Friday 9:40
(EAZ03)
INSTRUCTOR
§ Section 1:
Ercüment Çiçek (cicek@cs.bilkent.edu.tr)
o
Office
hours: By appointment (EA531)
§ Section 2:
Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr)
o
Office
hours: Wednesday 13:40 -- 15:30 (G17)
§ Section 3:
Çağrı Toraman (ctoraman@cs.bilkent.edu.tr)
o
Office
hours: Tuesday 12:40 -- 14:30
TEACHING
ASSISTANTS
§
Arif
Usta, Mustafa Can Çavdar, Fuat Basık
§
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, 5)
§
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 (Chapters 14, 15)
§
Midterm:
30%
§
Final:
35%
§
Project:
20%
§
Homeworks
& Attendance: 15%
Minimum
Requirements to Qualify for the Final Exam
In order to
qualify for the Final Exam, the Midterm
Exam grade must be at least 30 out of 100.
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 |
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.