CS353
DATABASE SYSTEMS
FALL
2021
CLASSES
§ Tuesday 9:30;
Thursday 13:30, 14:30 (EE-05)
INSTRUCTOR
§ Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr)
o
Office
hours: Wednesday 13:30 -- 15:30 (Zoom by appointment)
TEACHING
ASSISTANTS
§
Mustafa
Can Çavdar
§
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 must wear a mask appropriately
(i.e., covering both your mouth and nose) while attending the class.
·
You are not permitted to consume
food or drink in the classroom.
·
You are required to sit in the same
seat each lecture. Once your seating plans are finalized, you will be asked to
use an SRS service to enter the Bilkent ID numbers of your colleagues seated
immediately around you.
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.