CS353 DATABASE SYSTEMS

FALL 2013 

ANNOUNCEMENTS

CLASSES

bullet Section 1: Monday 10:40, 11:40; Thursday 9:40         (EB204)
bullet Section 2: Monday 10:40, 11:40; Thursday 9:40         (BZ04)

 

INSTRUCTORS

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

Office hours: Wednesday 15:40 -- 17:30  (EA402)

bullet Section 2: Hakan Ferhatosmanoğlu (hakan@cs.bilkent.edu.tr)

Office hours: Thursday 10:40 -- 12:00  (EA412)  

 TEACHING ASSISTANTS

bullet Arif Usta, Kaan Bingöl, Ayça Işıksal

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)
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 1: 20% (November 5, 2013)
bullet Midterm 2: 20% (December 4, 2013)
bullet Term project: 20%
bullet Homeworks & Attendance: 10%
bullet Final: 30%

Minimum Requirements to Qualify for the Final Exam

 In order to qualify for the Final Exam, the average of two Midterm Exams must be at least 40 out of 100.

Course Attendance Policy

  Regular attendance at classes is required for successful completion of the course. Attendance will be taken by circulating a class roll during class. Signing the class roll for a student who is not present will be considered a case of academic dishonesty and will lead to punishment through disciplinary procedures.

 

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

You can download lecture slides from: 

http://www.db-book.com/

 

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.