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.
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 (sgulec@bilkent.edu.tr)
Office hours: Tuesday 14:40, Friday 13:40 (Zoon Only)
Section 3: Uğur Güdükbay (gudukbay@cs.bilkent.edu.tr)
Office hours: Monday 13:40, Thursday 13:40 (EA403)
Classes
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):
Lectures:
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):
Lectures:
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 (sinan.sonlu@bilkent.edu.tr),
Office Hours:
Monday 13:40, 14:40 (EA-405) Mohamad Alhajar (mohamad.alhajar@bilkent.edu.tr ),
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 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% (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. 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.
Textbook
In the exams, homeworks, and projects in this course,
occurrences of plagiarism will be seriously dealt with, leading to punishment
through disciplinary procedures.