Midterm: Exam (Friday, April 12, 2013 Class Hour (13:40-15:30);
Classes: EB101 (AHIPASAOGLU-KORKMAZ) and EA302 (KUTLUAY-ZENGINOL)
Sections 1: Uğur Güdükbay (gudukbay@cs.bilkent.edu.tr)
Office hours: Tuesday 08:40, 09:40 (EA403)
Classes
Section 1: Tuesday 15:40, Friday 13:40, 14:40 (EB101)
Lab Hours
Section 1: Monday 08:40, 09:40 (EE211)
Teaching Assistants
Ates Akaydin (EA405, Office Tel: ????; email: akaydin@cs.bilkent.edu.tr)
Office hours: Tuesday
09:40, 10:40 (EA407)
Aytek Aman (EA405, Office Tel: ????; email: aytek.aman@bilkent.edu.tr)
Office hours: Thursday
09:40, 10:40 (EA407)
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% (Friday, April 12, 2013 Class Hour (13:40-15:30); Classes: EB101 (AHIPASAOGLU-KORKMAZ) and EA302 (KUTLUAY-ZENGINOL)
Final: 35%
Project: 20%
Homework: 10%
Attendance: 5%
1) Required Database Management Systems, 3rd Edition
R. Ramakrishnan, J. Gehrke
Mc Graw Hill, 2003 2) Recommended An Introduction to Database Systems, 8th
Edition C.J. Date Addison-Wesley, 2004 3) Recommended Fundamentals of Database Systems, 5th Edition
Ramez Elmasri,
Shamkant B. Navathe Addison Wesley, 2006 4) Recommended Database System Concepts, 6th edition
A. Silberschatz; H. Korth; S.
Sudarshan McGraw-Hill, 2009
You
can download lecture slides from:
http://www.cs.wisc.edu/~dbbook/openAccess/thirdEdition/slidesTextbook
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 which call for a term or two terms of dispelling
from the university (Ogrenci Disiplin Ilke ve
Kurallari, Madde 8).