CS353 DATABASE SYSTEMS
FALL 2020
CLASSES
§ Online-Only: Tuesday
9:00 (Zoom); Thursday 15:30, 16:30 (Zoom)
§
Hybrid: Tuesday
9:30 (EE-214); Thursday 17:30,
18:30 (Zoom) Starting from October 1st
INSTRUCTOR
§ Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr)
o
Office
hours: Wednesday 13:40 14:30 (Zoom)
TEACHING
ASSISTANTS
§
Mustafa
Can Çavdar, 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
§
Relational Algebra
§
Entity/Relationship Model
§
Structured Query Language, SQL
§
Database Application Development
§
Relational Database Design
§
File Organization
§
Tree-Structured Indexing
§
Hash-Based Indexing
§
Query Processing
§
Query Optimization
§
Transactions & Concurrency
Control
§
Big Data
§
Midterm:
30%
§
Final:
35%
§
Project:
20%
§
Homeworks:
15%
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 |
Covid-19
·
You are required to have a stable internet
connection and webcam to attend the Zoom classes.
·
You must wear a mask appropriately
(i.e., covering both your mouth and nose) if you are attending the class in
person.
·
You are required to maintain social
distancing in the classroom.
·
You are not permitted to consume
food or drink in the classroom.
·
Attendance will be taken for record
keeping purposes.
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.