Department of Computer Engineering

Bilkent University

CS281. COMPUTERS AND DATA ORGANIZATION

Fall 2016

ANNOUNCEMENTS

 

Instructors

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

  Office hours: Thursday 13:40, 14:40  (EA402)

Section 3: Uğur Güdükbay (gudukbay@cs.bilkent.edu.tr)

  Office hours: Monday 8:40, 9:40 (EA403)

Classes

Section 1: Wednesday  13:40, 14:40; Friday 15:40           (EB201)  

Section 2: Wednesday  9:40; Friday 10:40, 11:40             (EB201)

Section 3: Monday  15:40; Thursday 13:40, 14:40            (EB204)

 

Lab Hours

Section 1: Tuesday 15:40, 16:40                   (EEE211)

Section 2: Wednesday  10:40, 11:40             (EEE211)

Section 3: Wednesday  15:40, 16:40             (EEE211)

 

Teaching Assistants

Arif Usta (arif.usta@bilkent.edu.tr) Office Hours:  Monday  13:40, 14:40

Çağrı Toraman (ctoraman@bilkent.edu.tr) Office Hours:  Monday  13:40, 14:40

Mustafa Can Çavdar (mustafa.cavdar@bilkent.edu.tr) Office Hours:  Thursday  15:40, 16:40

 

Course Objective

To provide the students with a  practical knowledge of  data modeling, database systems, and database design. Emphasis will be put on the relational data model and its query languages.

 

Course Outline

Introduction to Database Design - Entity-Relationship (ER) Model

Relational Data Model

Relational Algebra

Query-by-Example

SQL Query Language

Database Application Development

Schema Refinement and Normal Forms

Overview of Storage and Indexing

Tree-Structured Indexing

Hash-Based Indexing

Overview of Transaction Management

Concurrency Control

  

Typical Grading

     Midterm: 30%  (November 15, 2016)

Final: 35%

Project: 20%

Homeworks & Attendance: 15%

 

Textbook

1)

Required

Database Management Systems, 3rd Edition

R. Ramakrishnan, J. Gehrke

McGraw-Hill, 2003

2)

Recommended

Database System Concepts, 6th edition

A. Silberschatz; H. Korth; S. Sudarshan

McGraw-Hill, 2011

3)

Recommended

An Introduction to Database Systems, 8th Edition

C.J. Date

Addison-Wesley, 2004

4)

Recommended

Fundamentals of Database Systems, 5th Edition

Ramez Elmasri, Shamkant B. Navathe

Addison-Wesley, 2006

 

You can download lecture slides from: 

http://www.cs.wisc.edu/~dbbook/openAccess/thirdEdition/slides

 

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

 

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.

 

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.