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%
|
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.