Section 1: Özgür Ulusoy (oulusoy@cs.bilkent.edu.tr)
Office hours: Wednesday 13:40, 14:40 (EA402)
Sections 2, 3: Fazlı Can (canf@cs.bilkent.edu.tr)
Office hours: Monday 14:40, Tuesday 14:40 (EA431)
Classes
Section 1: Monday 15:40, 11:40; Thursday 13:40, 14:40 (EB203)
Section 2: Tuesday 15:40; Friday 13:40, 14:40 (BZ08)
Section 3: Wednesday 13:40, 14:40; Friday 15:40 (BZ08)
Lab Hours
Section 1: Friday 13:40, 14:40 (EEE211)
Section 2: Friday 15:40, 16:40 (EEE211)
Section 3: Wednesday 15:40, 16:40 (EEE211)
Teaching Assistants
Erdem Sarıgil (esarigil@bilkent.edu.tr), Çağrı Toraman (ctoraman@bilkent.edu.tr), Hayrettin Erdem (hayrettin@bilkent.edu.tr), Fatih Çalışır (fatih.calisir@bilkent.edu.tr)
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 28, 2012 at 17:30)
Final: 35%
Project: 20%
Homework: 10%
Attendance: 5%
|
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
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.