Department of Computer Engineering

Bilkent University


Fall 2020


Assistant Web Page for Project Information and Labs. Please visit regularly for updates.

You can download MS Access freely for your personal computers using Microsoft Azure. Please check the following documentation from CTIS department to download software from Microsoft Azure for educational purposes.

Microsoft Azure for Education: How to Download Developer Tools and Learning Resources From Microsoft Azure


Please note that if you join the Zoom lectures using your school email accounts, the attendance will be automatically recorded on STARS. I strongly suggest you log in to Zoom lectures using your school email accounts.


Sections 1, 2: Semra Gülec (

  Office hours: Tuesday 14:40, Friday 13:40 (Zoon Only)

Section 3: Uğur Güdükbay (

Office hours: Monday 13:40, Thursday 13:40  (EA403)


All lecture and lab slots are 50 minutes with 10 minutes break between slots.

Labs start on Week 3 (28 September 2020, and they will be online).

Online (Until 30 September 2020, Monday (including):


Section 1: Tuesday 15:30, 16:30 (Online); Friday 08:00 (Spare Hour), 09:00 (Online) (EA-Z01)

Section 2: Tuesday 17:30, 18:30 (Online); Friday 10:00, 11:00 (Spare Hour) (Online) (EA-Z01)

Section 3: Monday 17:30, 18:30 (Online); Thursday 10:00, 11:00 (Spare Hour) (Online) (B-Z05)

Lab Hours:

Section 1: Wednesday 08:00, 09:00, 10:00 (Fixed Spare Hour) (EE-211)

Section 2: Wednesday 12:30, 13:30, 14:30 (Fixed Spare Hour) (EE-211)

Section 3: Tuesday 12:30, 13:30, 14:30 (Fixed Spare Hour) (EE-211)

Hybrid (Starting 1 October 2020, Thursday):


Section 1: Tuesday 17:30, 18:30 (Online); Friday 08:30 (Spare Hour), 09:30 (Hybrid) (EA-Z01)

Section 2: Tuesday 20:00, 21:00 (Online); Friday 10:30, 11:30 (Spare Hour) (Hybrid) (EA-Z01)

Section 3: Monday 20:00, 21:00 (Online); Thursday 10:30, 11:30 (Spare Hour) (Hybrid) (B-Z05)

Lab Hours

Section 1: Wednesday 08:30, 09:30, 10:30 (Fixed Spare Hour) (EE-211)

Section 2: Wednesday 13:30, 14:30, 15:30 (Fixed Spare Hour) (EE-211)

Section 3: Tuesday 13:30, 14:30, 15:30 (Fixed Spare Hour) (EE-211)


Teaching Assistants

Sinan Sonlu    (, Office Hours:  Monday  13:40, 14:40 (EA-405)

Mohamad Alhajar ( ), Office Hours:  Wednesday  10:40, 11:40 (EA-505)


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


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%  (Between 7-15 November 2020)

Final: 35%

Project: 25%

Homeworks & Quiz & Lab Quiz: 10%

The Midterm and final exams will be held during the Midterm and Final Exam Weeks, respectively. The midterm and final exams will be scheduled by the university. The midterm and final exams will be in-class exams and you must be at the university during the midterm and final exam weeks. The midterm and final exams will be closed-book exams.




Database Management Systems, 3rd Edition

R. Ramakrishnan, J. Gehrke

McGraw-Hill, 2003



Database System Concepts, 6th edition

A. Silberschatz; H. Korth; S. Sudarshan

McGraw-Hill, 2011



An Introduction to Database Systems, 8th Edition

C.J. Date

Addison-Wesley, 2004



Fundamentals of Database Systems, 5th Edition

Ramez Elmasri, Shamkant B. Navathe

Addison-Wesley, 2006


You can download lecture slides from:


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.



    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.