Instructor: Prof. Dr. Özgur Ulusoy
TA:
|
|
ANNOUNCEMENTS
Ann #34: 30/04/2024 Homework 5 grades are now available on STARS. Grade Avg = 78.1 | |
Ann #33: 25/04/2024 Homework 6 is now available on Moodle. The due date for the homework is May 2 , Thursday at 23:59. You must submit your homework via the "Homework 6" activity on Moodle. | |
Ann #32: 19/04/2024 Just a reminder about the project implementation. Possible DBM systems like MySQL, PostgreSQL, MSSQL Server or Oracle are allowed. MS Access is not allowed for this project. Note that, the DBMS you will use must support all modern features like views, triggers, constraints, etc. Another important point is that in your project while interacting with the database you must write raw SQL queries. ORMs are forbidden for this project. Please remember that you are going to be asked to show your SQL queries during project demo. | |
Ann #31: 17/04/2024 There were some missing pages in lecture slides previously shared with you. Updated versions are available in Moodle under the Course Slides folder. | |
Ann #30: 17/04/2024 The grades for Project Design Report and Homework 1 are now available on STARS. Average grade for Project Design Report is 81.78, and for Homework 1 is 74.8. | |
Ann #29: 05/04/2024 Homework 5 is now available on Moodle. The due date for the homework is April 16 , Tuesday at 23:59. You must submit your homework via the "Homework 5" activity on Moodle. | |
Ann #28: 28/03/2024
Clarification regarding Homework-4: You can edit the part related to registration that has been provided to you. The Homework-4 document does not specify the requirement for users to create an account upon registration in the system. In other words, you don't need to create an account for a user who has newly registered. Furthermore, there is no expectation to include a "create account" option for users who are already registered. For the homework, a simple UI would be sufficient. It is not expected to have a complex UI. | |
Ann #27: 22/03/2024 The due date for the Project Design Report is March 25, Monday, at 23:59. Late submissions with a deduction of 10 points per day are accepted until March 28, Thursday, at 23:59. | |
Ann #26: 18/03/2024 You can see your midterm exam papers on 19 March, Tuesday between 14:00-17:00 in EA-502. | |
Ann #25: 18/03/2024 Midterm grades are now available on STARS. Grade Avg = 66.9 | |
Ann #24: 15/03/2024 Just a reminder about the upcoming deadline: The due date for the project's second phase (Design Report) is March 25, Monday, at 23:59. You will submit your report via Moodle. | |
Ann #23: 15/03/2024
Project Design Report:
Due Date:
March 25 Monday, at 23:59.
Please pay attention while doing this report since its grade will correspond to %30-%35 (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. You need to include the following information:
Revised E/R Table schemas User interface design and corresponding SQL statements | |
Ann #22: 14/03/2024 Homework 4 is now available on Moodle. The due date for the homework is April 4 , Thursday at 23:59. You must submit your homework via the "Homework 4" activity on Moodle. | |
Ann #21: 13/03/2024 There will be an online tutorial on web-based database applications tomorrow (March 14) at 19:45 via Zoom. You will have a programming assignment (HW-4) related to this tutorial. | |
Ann #20: 11/03/2024
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. Groups 1-15 should fill the first page of the Google Sheet Groups 15-29 should fill the second page of the Google Sheet | |
Ann #19: 11/03/2024 Proposal report grades are now available on STARS. Grade Avg = 81 | |
Ann #18: 11/03/2024 Homework 2 grades are now available on STARS. Grade Avg = 89.2 | |
Ann #17: 10/03/2024 The Midterm Exam on 11 March, Monday will start at 17:40. | |
Ann #16: 10/03/2024
MIDTERM EXAM CLASSROOM LIST is as follows according to student surnames: EB-101: Aamir - Bal EB-102: Balbal - Eren EB-103: Eroğlu - Kılınç EB-104: Koçak - Şahin (Emir Kerem Şahin) EB-203: Şahin (Kemal Sarper Şahin) - Tuncar EB-204: Tuncer - Zeynalov | |
Ann #15: 07/03/2024 Solutions for homework 1, 2, and 3 are now available on Moodle under Homework Solutions folder. | |
Ann #14: 05/03/2024 Project Functionalities Document, which explains expected fundamental functionalities in the project, is uploaded in Moodle under Project Documents folder. | |
Ann #13: 05/03/2024 The Midterm Exam will be on 11th of March starting at 17:40 in classrooms EB-101, 102, 103, 104, 203, 204. The exam will be CLOSED BOOK/NOTES and cover the following subjects: Relational Model & Relational Algebra (Chapter 2), Entity/Relationship Model (Chapter 6), SQL (till the end of Chapter 3). | |
Ann #12: 28/02/2024 Homework 3 is now available on Moodle. The due date for the homework is March 6, Wednesday at 23:59. You must submit your homework via the "Homework 3" activity on Moodle. Your submission file must be named "surname_name.pdf". | |
Ann #11: 20/02/2024 There is a correction in Homework 2 Question 1. Updated version is now available on Moodle. In Question 1, statement "a vehicle can be involved in one or more accidents" is changed to "a vehicle can be involved in zero or more accidents". | |
Ann #10: 15/02/2024 Homework 2 is now available on Moodle. The due date for the homework is February 22, Thursday at 23:59. You must submit your homework via the "Homework 2" activity on Moodle. Your submission file must be named "surname_name.pdf". | |
Ann #9: 15/02/2024 The tentative due date for the project proposal is February 26, 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. | |
Ann #8: 15/02/2024 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. | |
Ann #7: 08/02/2024 Homework 1 is now available on Moodle. The due date for the homework is February 15, 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". | |
Ann #6: 01/02/2024 The students, who are retaking CS-353 and 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 to Hasan Alp Caferoğlu by February 9, clearly indicating the year and the semester when you took the course. | |
Ann #5: 01/02/2024
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. Project groups may include students from different sections. 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 9, Friday midnight. One group member's e-mail is enough. | |
Ann #4: 30/01/2024 Course syllabus, Project Document and Course slides are uploaded on Moodle. | |
Ann #3: 30/01/2024 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. | |
Ann #2: 30/01/2024 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. | |
Ann #1: 30/01/2024 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. |
...