CS353 DATABASE SYSTEMS

FALL 2020 

ANNOUNCEMENTS

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

OBJECTIVES

§  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.

COURSE OUTLINE

§  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

TYPICAL GRADING

§  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.