CS353 DATABASE SYSTEMS

SPRING 2018 

ANNOUNCEMENTS

CLASSES

§  Section 1: Wednesday 9:40; Friday 10:40, 11:40         (EAZ03)

§  Section 2: Tuesday 9:40; Thursday 10:40, 11:40         (EAZ03)   

§  Section 3: Tuesday 10:40, 11:40; Friday 9:40             (EAZ03)   

INSTRUCTOR

§  Section 1: Ercüment Çiçek (cicek@cs.bilkent.edu.tr)  

o   Office hours: … (EA531)  

§  Section 2: Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr)   

o   Office hours: Wednesday 13:40 -- 15:30 (G17)     

§  Section 3: Çağrı Toraman (ctoraman@cs.bilkent.edu.tr)  

o   Office hours: …  (EA…)

 

TEACHING ASSISTANTS

§  Arif Usta, Mustafa Can Çavdar, Fuat Basık

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 (Chapters 1, 2)

§  Entity/Relationship Model  (Chapter 7)

§  Relational Algebra  (Chapter 6)

§  Structured Query Language, SQL (Chapters 3, 4, 5)

§  Database Application Development (Chapter 9)

§  Relational Database Design (Chapter 8)

§  File Organization (Chapter 10)

§  Tree-Structured Indexing (Chapter 11)

§  Hash-Based Indexing (Chapter 11)

§  Query Processing  (Chapter 12)

§  Query Optimization  (Chapter 13)

§  Overview of Transaction Management  (Chapters 14, 15)

TYPICAL GRADING

§  Midterm: 30%

§  Final: 35%

§  Project: 20%

§  Homeworks & Attendance: 15%     

 

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, 6th edition

A. Silberschatz; H. Korth; S. Sudarshan

McGraw- Hill

2011

Recommended

Textbook

Database Management Systems, 3rd Edition

R. Ramakrishnan, J. Gehrke

McGraw- Hill

2003

Recommended

Textbook

Database Systems, The Complete Book

Hector Garcia-Molina,Jeffrey D. Ullman, Jennifer Widom

Prentice Hall

2002

Recommended

Textbook

An Introduction to Database Systems, 8th Edition

C.J. Date

Addison-Wesley

2004

Recommended

Textbook

Fundamentals of Database Systems, 3rd Edition

Ramez Elmasri, Shamkant B. Navathe

Addison- Wesley

2000

 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.