CS353
DATABASE SYSTEMS
SPRING
2024
CLASSES
§ Section 1: Wednesday 9:30; Friday 13:30,
14:30 (EE-05)
§
Section 2: Wednesday 10:30, 11:30; Friday
15:30 (EE-05)
INSTRUCTOR
§ Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr)
o
Office
hours: by appointment
TEACHING
ASSISTANTS
§
Hasan
Alp Caferoğlu, Mousa Farshkar
Azari
§
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
§
Relational Algebra
§
Entity/Relationship Model
§
Structured Query Language, SQL
§
Relational Database Design - Normalization
§
File Organization
§
Tree-Structured Indexing
§
Hash-Based Indexing
§
Query Processing
§
Midterm:
30%
§
Final:
40%
§
Project:
20%
§
Homeworks:
10%
All
assignments must be uploaded to Moodle as a single PDF.
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, 7th edition |
A. Silberschatz; H. Korth; S.
Sudarshan |
McGraw- Hill |
2019 |
|
Recommended |
Textbook |
Database Management
Systems, 3rd Edition |
R. Ramakrishnan, J. Gehrke |
McGraw- Hill |
2003 |
|
Recommended |
Textbook |
Database Systems,
The Complete Book, 2nd edition |
Hector Garcia-Molina,Jeffrey D. Ullman, Jennifer Widom |
Prentice Hall |
2009 |
|
Recommended |
Textbook |
An Introduction to
Database Systems, 8th Edition |
C.J. Date |
Addison-Wesley |
2004 |
|
Recommended |
Textbook |
Fundamentals of
Database Systems, 6th Edition |
Ramez Elmasri, Shamkant
B. Navathe |
Addison- Wesley |
2011 |
WARNING
:
Cheating in exams, homeworks, and projects in this course will be seriously dealt with, leading to punishment through
disciplinary procedures.