Department of Computer Engineering

Bilkent University

CS353 DATABASE SYSTEMS

Spring 2024-2025

horizontal rule

 

Instructor: Prof. Dr. Özgur Ulusoy

TA:

bullet Hasan Alp Caferoğlu
bullet Office Hour: by appointment
bullet Office: EA-405
bullet E-mail: alp dot caferoglu at bilkent dot edu dot tr
bullet Ekrem Polat
bullet Office Hour: by appointment
bullet Office: EA-405
bullet E-mail: ekrem dot polat at bilkent dot edu dot tr

ANNOUNCEMENTS
bullet Ann #25: 28/03/2025 The deadline for Homework 4 has been extended to Thursday, April 10 at 23:59.
bullet Ann #24: 25/03/2025 Announcement about Homework-4: Homework 4, there is a rule that a student can apply to a maximum of 3 companies. If a student tries to apply to more than 3, your program should show an appropriate error message. This rule is important and must be followed in your implementation. However, this rule does not apply when creating your initial database. So, in your schema.sql file, you can insert sample data where a student has applied to more than 3 companies. In other words, the apply table in the starting database can have more than 3 entries for the same student.
bullet Ann #23: 25/03/2025 If you want to see your midterm paper, you need to book a time slot through the Midterm Paper Review Activity on Moodle. Please note that only 5 students can sign up for each time slot. The review session will take place on Thursday, March 27, between 13:00 and 17:00 in EA-502.
bullet Ann #22: 25/03/2025 Midterm grades are now available on STARS. Grade Avg = 62.9
bullet Ann #21: 22/03/2025 This is a reminder for the project design report. The due date for the design report is March 27 Thursday, at 23:59.
bullet Ann #20: 17/03/2025 MIDTERM EXAM CLASSROOM LIST is as follows according to student surnames:
bulletB-Z01: Ahani - Çalışkan
bulletB-Z02: Çaycı - İr
bulletB-Z04: İşçi - Sara
bulletB-Z08: Sarıdoğan - Zor
bullet Ann #19: 13/03/2025 The Midterm Exam will be on 18th of March starting at 17:40 in classrooms B-Z01, B-Z02, B-Z04, B-Z08. The exam will be CLOSED BOOK/NOTES and cover the following subjects: Relational Model & Relational Algebra, Entity/Relationship Model, and SQL. Please ensure that your answers in the exam use only the notations and operators taught in class. Any other notations or operators will not be accepted.
bullet Ann #18: 13/02/2025 Solutions for homework 1, 2 and 3 are now available on Moodle under Homework Solutions folder.
bullet Ann #17: 12/03/2025 Homework 1 grades are now available on STARS. Grade Avg = 92.26
bullet Ann #16: 12/03/2025 Homework 4 is now available on Moodle. The due date for the homework is April 3 , Thursday at 23:59. You must submit your homework via the "Homework 4" activity on Moodle.
bullet Ann #15: 10/03/2025 There will be an online tutorial on web-based database applications on 12 March, Wednesday at 18:00 via Zoom. You will have a programming assignment (HW-4) related to this tutorial. Zoom link will be announced later.
bullet Ann #14: 03/03/2025 Project Design Report: Due Date: March 27 Thursday, at 23:59. Please pay attention while doing this report since its grade will correspond to %30-%40 (tentatively) of your overall project grade. Please read the Project Functionalities document and the corresponding part in Project Specifications document in Moodle under Project Documents folder for the details of the design report. Notice that you may need to alter your E/R diagram to capture all the given functionalities. Do not forget to introduce your additional functionality. You need to include the following information:
bullet Revised E/R
bullet Table schemas
 bullet User interface design and corresponding SQL statements
bullet Ann #13: 03/03/2025 The feedback sessions for Project proposals will be held. You can (and are encouraged to) get feedback by reserving an appropriate time slot in the Google Sheet for an appointment.
bulletGroups 1-10 should fill the first page of the Google Sheet
bulletGroups 11-22 should fill the second page of the Google Sheet
bullet Ann #12: 03/03/2025 Project proposal report grades are now available on STARS. Grade Avg = 82.66. There will be an announcement about the feedback sessions.
bullet Ann #11: 28/02/2025 Homework 3 is now available on Moodle. The due date for the homework is March 6, Thursday at 23:59. You must submit your homework via the "Homework 3" activity on Moodle. Your submission file must be named as "surname_name_hw3.pdf"
bullet Ann #10: 13/02/2025 The due date for the project proposal is February 24, Monday at 23:59. Your project proposal should include description of your application, its requirements (functional and non-functional) and limitations in detail. Most importantly, it should include the conceptual design of your database using the E/R model. Note that, you MUST draw your ER diagram with the notation you learned in the class. Please read the corresponding part in Project Specifications Document for the details of the project proposal. You should upload your proposal to Moodle. One of the group member's submission is enough.
bullet Ann #9: 13/02/2025 Project groups are listed. You can find Project Groups and Project Topics documents in Moodle under Project Documents folder. Please check the lists carefully and email to Hasan Alp Caferoğlu immediately if there is a mistake in your project group.
bullet Ann #8: 13/02/2025 Homework 2 is now available on Moodle. The due date for the homework is February 20, Thursday at 23:59. You must submit your homework via the "Homework 2" activity on Moodle. Your submission file must be named as "surname_name_hw2.pdf".
bullet Ann #7: 06/02/2025 Homework 1 is now available on Moodle. The due date for the homework is February 13, Thursday at 23:59. You must submit your homework via the "Homework 1" activity on Moodle. Your submission file must be named as "surname_name_hw1.pdf".
bullet Ann #6: 29/01/2025 The students, who are retaking CS-353 to improve their grade or due to failure, and who previously completed the term project successfully, can be exempted from the project of the course. If you are repeating the course and want to be exempted from the project, please send an e-mail with the subject line CS-353: Project Exemption to Hasan Alp Caferoğlu by February 7, Friday midnight, clearly indicating the year and the semester when you took the course. For students requesting exemption from the project, your previous project grade will be mapped to this semester's project grade based on the average grade of this semester’s projects.
bullet Ann #5: 29/01/2025 Please start forming project groups of 5 students. You can use the forum in Moodle if you are looking for a group or a team member. Please read Project Specification Document in Moodle for further details.
bullet Students that do not belong to any group will be assigned randomly.
bullet Project groups may include students from different sections.
bullet You must form your group and send an e-mail with the subject line CS-353: Group Members to Hasan Alp Caferoğlu until February 7, Friday midnight. One group member's e-mail is enough.
bullet The email should include a list of group members with full name, sections and IDs.
bullet Ann #4: 28/01/2025 Course syllabus, Project Document and Course slides are uploaded on Moodle.
bullet Ann #3: 28/01/2025 Minimum Requirements 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.
bullet Ann #2: 28/01/2025 CS353 MOODLE PAGE: We will use Moodle service in our course in this semester. You must log into the moodle through STARS system first. You can use forums in this page to communicate with other students in this course.
bullet Ann #1: 28/01/2025 Welcome to CS-353! Please visit this page very frequently to learn about latest announcements, regular assignments, office hour changes, exam information and other relevant stuff.

...