CS353 DATABASE SYSTEMS

FALL 2021 

ANNOUNCEMENTS

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

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