CS353 DATABASE SYSTEMS

FALL 2017 

ANNOUNCEMENTS

CLASSES

bullet

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

bullet

Section 2: Wednesday 13:40, 14:40; Friday 15:40    (B206)

 

INSTRUCTOR

 bullet

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

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

 bullet

Section 2: Hamdi Dibeklioğlu (dibeklioglu@cs.bilkent.edu.tr)

Office hours: Thursday 13:40 -- 15:30  (EA512)

TEACHING ASSISTANTS

bullet

Arif Usta, Mustafa Can Çavdar

OBJECTIVES

bullet

Understand the concepts underlying the design and implementation of database systems.

bullet

Establish a solid background in data management, with a focus on relational database management systems.

bullet

Practice actual database design, implementation, and query formulation through a term project.

COURSE OUTLINE

bullet

Relational Data Model (Chapters 1, 2)

bullet

Entity/Relationship Model  (Chapter 7)

bullet

Relational Algebra  (Chapter 6)

bullet

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

bullet

Database Application Development (Chapter 9)

bullet

Relational Database Design (Chapter 8)

bullet

File Organization (Chapter 10)

bullet

Tree-Structured Indexing (Chapter 11)

bullet

Hash-Based Indexing (Chapter 11)

bullet

Query Processing  (Chapter 12)

bullet

Query Optimization  (Chapter 13)

bullet

Overview of Transaction Management  (Chapter 14)

TYPICAL GRADING

bullet

Midterm: 30%  (31 October, at 17:30)

bullet

Term project: 20%

bullet

Homeworks & Attendance: 15%

bullet

Final: 35%

 

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.