Moed B Grades and Solution
|Moed B final grades are online. There was a 5% factor on the exam grade.|
Appeals can be submitted to Saib Box, at Taub floor 5, till 12.11, 12:00.
Moed B exam and solution are online and can be found at Course Material/Additional files/Previous Exams
Two students who didn't give an approval for having time extension, are required to submit those forms to Saib's box, so that their grade will be forwarded to the UG.
|עדכון אחרון ב- 5/11/2007, 00:17:44 Last updated on 5/11/2007, 00:17:44 Последняя модификация 5/11/2007, 00:17:44 تمت الحتلنة الأخيرة ب- 5/11/2007, 00:17:44|
Moed B Exam
Moed B exam will take place next Wednesday, 24.10, 17:30-20:30, Taub 6,7,8.
Reception time will be held as follows:
Irina – Sunday 21.10, 14:00-15:00, Taub 415
Saib – Monday 22.10, 16:30-17:30, Taub 2
|עדכון אחרון ב- 17/10/2007, 18:24:05 Last updated on 17/10/2007, 18:24:05 Последняя модификация 17/10/2007, 18:24:05 تمت الحتلنة الأخيرة ب- 17/10/2007, 18:24:05|
Moed A Grades and Solution
|Moed A final grades are online. The final grade was calculated according to the following formula:|
FinalA=min(100, round( 0.2*HW_AVG + 0.8*(1.14* ExamA -1)))
Appeals can be submitted to Saib Box, at Taub floor 5, till 24.10, 12:00. If you want an answer before Moed B, you'll have to submit your appeal until 14.10, 12:00.
Moed A exam and solution are online and can be found at Course Material/Additional files/Previous Exams
|פורסם ב- 10/10/2007, 18:14:13 Created on 10/10/2007, 18:14:13 Создано 10/10/2007, 18:14:13 تم النشر ب- 10/10/2007, 18:14:13|
Slides of summarizing tutorial was published
|Slides of summarizing tutorial was published at|
All the best in exam!
|עדכון אחרון ב- 1/10/2007, 12:58:51 Last updated on 1/10/2007, 12:58:51 Последняя модификация 1/10/2007, 12:58:51 تمت الحتلنة الأخيرة ب- 1/10/2007, 12:58:51|
Moed A Exam
|Moed A exam will be held on Friday, 5.10.07, from 09:00 to 12:00, at Ulman, 303, 304, 305, 306.|
The exam will be with open material.
Reception time will be held as follows:
Amir – Sunday 30.9, 15:00-16:00, Taub 9
Irina – Monday 1.10, 11:00-12:00, Taub 9
Saib – Tuesday 2.10, 10:00-11:00, Taub 8
|עדכון אחרון ב- 25/9/2007, 10:10:34 Last updated on 25/9/2007, 10:10:34 Последняя модификация 25/9/2007, 10:10:34 تمت الحتلنة الأخيرة ب- 25/9/2007, 10:10:34|
HW average and HW transfer
|A new column HW_AVG was added.|
The column was calculated according to the following formula:
We also transferred HW grades from previous semesters for students who requested this option. If there is any problem please contact saib@cs.
|עדכון אחרון ב- 11/9/2007, 13:56:36 Last updated on 11/9/2007, 13:56:36 Последняя модификация 11/9/2007, 13:56:36 تمت الحتلنة الأخيرة ب- 11/9/2007, 13:56:36|
Date of exam in DBMS - important!!!
|The date of the exam Moed A is 5.10 |
( and not as we published before on our site!!)
the time and rooms published on:
We deeply apologize for our inconsistency.
|עדכון אחרון ב- 28/8/2007, 10:57:39 Last updated on 28/8/2007, 10:57:39 Последняя модификация 28/8/2007, 10:57:39 تمت الحتلنة الأخيرة ب- 28/8/2007, 10:57:39|
HW4 are checked
|HW4 grades are online. |
Appeals can be submitted to Irina's box at Taub 5th floor till 3.9.07.
|פורסם ב- 19/8/2007, 12:56:52 Created on 19/8/2007, 12:56:52 Создано 19/8/2007, 12:56:52 تم النشر ب- 19/8/2007, 12:56:52|
HW3 are checked
|HW3 grades are online. |
The solution can be found in the assignments section.
Appeals can be submitted to Irina's box at Taub 5th floor till 20.8.07, 12:00.
|עדכון אחרון ב- 9/8/2007, 11:40:25 Last updated on 9/8/2007, 11:40:25 Последняя модификация 9/8/2007, 11:40:25 تمت الحتلنة الأخيرة ب- 9/8/2007, 11:40:25|
Saib will be in his office tomorrow (Tuesday, 31.7) from 15:00-19:00 to check your appeals on the HW. We wanted to remind you that the HW was checked on csl1, so when you check your appeal verify that it's working on csl1, We won't handle cases where it works on t2 but not on csl1. Please also notice that in test 4, students who outputted only EMPTY without the title line passed this test.
|עדכון אחרון ב- 30/7/2007, 13:16:23 Last updated on 30/7/2007, 13:16:23 Последняя модификация 30/7/2007, 13:16:23 تمت الحتلنة الأخيرة ب- 30/7/2007, 13:16:23|
HW4 was published
|Dear students, |
HW4 is online and can be found at the Assignments section.
The submission is in pairs until 2.8.07 12:00, to the course cell.
Any questions concerning the exercise should be sent by e-mail to
lavva@cs only, with the subject HW4.
|פורסם ב- 20/7/2007, 09:24:47 Created on 20/7/2007, 09:24:47 Создано 20/7/2007, 09:24:47 تم النشر ب- 20/7/2007, 09:24:47|
New teaching schedule
As Amir finished the lectures material, there will be no lectures anymore, his reception time is also canceled as he is abroad, he is still available by email for your requests.
Saib won't have the faculty complementary class on Thursday, instead, he'll have the normal class time next Monday 23.7, 9:30-10:30, and we'll do an additional class from 14:30-16:30 Taub 2 (lecture time and place). In these two hours we'll study XQUERY and DATALOG. Irina's students are required to attend these two hours (she won't have tutorials anymore).
Those will be the last tutorials of this semester. We are intending to give a refreshing class and reception time before the Moed A.
|עדכון אחרון ב- 17/7/2007, 15:11:59 Last updated on 17/7/2007, 15:11:59 Последняя модификация 17/7/2007, 15:11:59 تمت الحتلنة الأخيرة ب- 17/7/2007, 15:11:59|
|The wet grades are online. 20 points were given for passing compilation. The weights of the tests (1..11) are (5, 10, 5, 5, 10, 5, 10, 5, 10, 5, 10) correspondingly. You can find the final tests at the assignments page. |
Your DB accounts were updated with the content that was used for the tests.
Appeals must be discussed with Saib directly till 31.7, to do that set a meeting by email, or preferably, come to Saib reception time, Monday 10:30-11:30. Only simple appeals will be discussed (for example not printing Empty when it should be printed…).
|עדכון אחרון ב- 17/7/2007, 14:25:25 Last updated on 17/7/2007, 14:25:25 Последняя модификация 17/7/2007, 14:25:25 تمت الحتلنة الأخيرة ب- 17/7/2007, 14:25:25|
New slides for Part 4 - Design
|New slides are published at Part 4 - Design|
|פורסם ב- 3/7/2007, 08:52:49 Created on 3/7/2007, 08:52:49 Создано 3/7/2007, 08:52:49 تم النشر ب- 3/7/2007, 08:52:49|
|Please note that on Wednesday 4.7, 12:30 Taub 7 there will be a complementary lecture. |
|פורסם ב- 27/6/2007, 12:36:23 Created on 27/6/2007, 12:36:23 Создано 27/6/2007, 12:36:23 تم النشر ب- 27/6/2007, 12:36:23|
Saib Reception Time
|Tomorrow, Monday 25.6, Saib will not be at the Technion, therefore his reception time is canceled and Irina will tutor in his place.|
|פורסם ב- 24/6/2007, 16:19:20 Created on 24/6/2007, 16:19:20 Создано 24/6/2007, 16:19:20 تم النشر ب- 24/6/2007, 16:19:20|
Irina's Reception Time
|Irina will not be present in the Technion tomorrow, Tuesday 19.6, therefore she won't have reception time, and Saib will tutor instead of her.|
|עדכון אחרון ב- 18/6/2007, 19:59:03 Last updated on 18/6/2007, 19:59:03 Последняя модификация 18/6/2007, 19:59:03 تمت الحتلنة الأخيرة ب- 18/6/2007, 19:59:03|
HW3 was published
HW3 is online and can be found at the Assignments section.
The submission is in pairs until 3.7.07 12:00, to the course cell.
Any questions concerning the exercise should be sent by e-mail to
lavva@cs only, with the subject HW3.
|פורסם ב- 18/6/2007, 13:29:15 Created on 18/6/2007, 13:29:15 Создано 18/6/2007, 13:29:15 تم النشر ب- 18/6/2007, 13:29:15|
Moed A Exam Date
|The Moed A exam was set to 11.10.07. A different date was mistakenly published in the UG course site, which is now removed. We need to make sure all the students agree to the correct date. If you have a serious problem with it please send saib@cs email ASAP as we want to finalize this issue next week.|
|פורסם ב- 13/6/2007, 14:26:16 Created on 13/6/2007, 14:26:16 Создано 13/6/2007, 14:26:16 تم النشر ب- 13/6/2007, 14:26:16|
Change of complementary lecture
|There will be a complementary lecture on Wednesday, 6.6 at 12:30 in Taub 7. The complementary lecture on Sunday 3.6 is Canceled. |
|פורסם ב- 1/6/2007, 00:07:56 Created on 1/6/2007, 00:07:56 Создано 1/6/2007, 00:07:56 تم النشر ب- 1/6/2007, 00:07:56|
|Please notice that on 3.6, Sunday, 16:30 Taub 7 there will be a complementary lecture. The lecture on 11.6 (Monday) is canceled.|
|עדכון אחרון ב- 28/5/2007, 13:52:56 Last updated on 28/5/2007, 13:52:56 Последняя модификация 28/5/2007, 13:52:56 تمت الحتلنة الأخيرة ب- 28/5/2007, 13:52:56|
|Due to technical problems with the web-based interface, the submission of the wet assignment is postponed till Tuesday, 29.5, 12:00. Please notice that you can still work, check your queries and code (and expected to do so) using csl1 server (instructions can be found in Postgres tutorial), or using visual studio (Course Material/Additional Files/Wet Assignment-working with Visual). The web-based interface will be back on Sunday, but it's unnecessary as you can still use other available methods. No further extensions will be given.|
|עדכון אחרון ב- 26/5/2007, 14:37:08 Last updated on 26/5/2007, 14:37:08 Последняя модификация 26/5/2007, 14:37:08 تمت الحتلنة الأخيرة ب- 26/5/2007, 14:37:08|
|Today, 22.5, from 10:00-12:00 Saib will hold special reception time for the WET exercise. You are all invited.|
|עדכון אחרון ב- 22/5/2007, 00:59:31 Last updated on 22/5/2007, 00:59:31 Последняя модификация 22/5/2007, 00:59:31 تمت الحتلنة الأخيرة ب- 22/5/2007, 00:59:31|
HW2-WET FAQ and postponement
|A FAQ section was opened for the HW2 assignment. The FAQ includes a summary of the updates that were made to the assignment after receiving your corrections. The document of the assignment and the test.zip files were updated.|
The HW submission is postponed till Sunday, 27.5, 12:00 due to SHAVOOT holiday at the previous submission date (23.5).
|פורסם ב- 9/5/2007, 16:08:29 Created on 9/5/2007, 16:08:29 Создано 9/5/2007, 16:08:29 تم النشر ب- 9/5/2007, 16:08:29|
|HW1 grades are online. The solution can be found in the assignments section. Appeals can be submitted to Saib box at Taub 5 till 22.5.07, 12:00. |
|עדכון אחרון ב- 9/5/2007, 12:17:38 Last updated on 9/5/2007, 12:17:38 Последняя модификация 9/5/2007, 12:17:38 تمت الحتلنة الأخيرة ب- 9/5/2007, 12:17:38|
Test case and bonus
|A basic test case was added to the assignments section (test.zip). Your database accounts were updated with sample tables corresponding to the test case.|
We decided to give a bonus of 1-2 points to students correcting a major error in the assignment. Of course, only the first students to correct a certain error will get the bonus. When you send a correction, add your ids to the email.
Please send your questions/corrections to saib@cs with the subject WET.
|פורסם ב- 2/5/2007, 16:05:34 Created on 2/5/2007, 16:05:34 Создано 2/5/2007, 16:05:34 تم النشر ب- 2/5/2007, 16:05:34|
|The submission is until 23/5/07.|
In this HW you'll write a C program that incorporates SQL commands using the LIBPQ library of the PostgreSQL interface. The PostgreSQL slides found in the Course Material section contains all the information you need to work with the system.
You can edit and debug your program in MS Visual Studio; details can be found in Course Material -> Additional Files -> Wet Assignment - working with Visual.
Your program will be compiled and run on csl1, so you need to check it on this server.
Your DB accounts will be updated with the initial content soon. Sample test cases will be published later.
Please notice that all the material that is required to this exercise was already taught in the tutorials.
Please send your questions to saib@cs.
|עדכון אחרון ב- 2/5/2007, 02:46:36 Last updated on 2/5/2007, 02:46:36 Последняя модификация 2/5/2007, 02:46:36 تمت الحتلنة الأخيرة ب- 2/5/2007, 02:46:36|
|There was a small correction in question 2 part a, the HW document was updated and the change is marked with red.|
In question 2 part c, you are required to create a view. As Saib's tutorial group didn't learn the subject yet, you can submit a SELECT query which returns the required information, and in the remaining parts (wherever it's mentioned that you can use the view Rating) you can assume that a table Rating[Name,Date,Num] was created with the appropriate content.
FAQ section was opened for HW1, please check the FAQ before sending further questions.
|פורסם ב- 19/4/2007, 11:18:03 Created on 19/4/2007, 11:18:03 Создано 19/4/2007, 11:18:03 تم النشر ب- 19/4/2007, 11:18:03|
Complementary Class on 11.4 is canceled.
|The lecture on 16.4 is still canceled.|
Next class is on 25.4
|פורסם ב- 8/4/2007, 11:42:35 Created on 8/4/2007, 11:42:35 Создано 8/4/2007, 11:42:35 تم النشر ب- 8/4/2007, 11:42:35|
HW1 and postgres accounts
|HW1 is online and can be found at the Assignments section. The submission is in pairs until 22.4.07, 12:00, to the course cell. Any questions concerning the exercise should be sent by e-mail to saib@cs only, with the subject HW1. There will be no extensions (except special cases like Miluim), so plan your time accordingly.|
The accounts of the postgres system for the registered students were opened. If you have trouble using your account, send an email to saib@cs (unfortunately, this will be handled only after the holiday), meanwhile you can use the guest account.
|עדכון אחרון ב- 2/4/2007, 01:36:57 Last updated on 2/4/2007, 01:36:57 Последняя модификация 2/4/2007, 01:36:57 تمت الحتلنة الأخيرة ب- 2/4/2007, 01:36:57|
New Slides online
|There is a new presentation online. Its name is "Examples: ERD and RA".|
It will be used for the class today (26.3).
|פורסם ב- 26/3/2007, 13:35:56 Created on 26/3/2007, 13:35:56 Создано 26/3/2007, 13:35:56 تم النشر ب- 26/3/2007, 13:35:56|
|Irina's tutorial (Tuesday, 10:30-11:30) will move permanently to Ulman 302 due to technical problems in the previous room.|
|פורסם ב- 21/3/2007, 00:33:14 Created on 21/3/2007, 00:33:14 Создано 21/3/2007, 00:33:14 تم النشر ب- 21/3/2007, 00:33:14|
Complementary Lectures – Correction
|The first complementary lecture will take place on Wednesday, 21.3, 12:30 at Taub 7 (25.3 lecture is canceled). The second complementary lecture will take place on Wednesday, 11.4, 12:30, the room will be announced later (29.4 lecture is canceled). The lecture on 16.4 is still canceled.|
|פורסם ב- 19/3/2007, 15:49:07 Created on 19/3/2007, 15:49:07 Создано 19/3/2007, 15:49:07 تم النشر ب- 19/3/2007, 15:49:07|
|Please notice that on 16.4 there will be no lecture, instead we'll have a complementary lecture on 25.3, Sunday 16:30-18:30, Taub 9. Also, due to strong link between the lectures and tutorials, we'll have another complementary lecture on 29.4, Sunday 16:30-18:30, Taub 7. |
|עדכון אחרון ב- 17/3/2007, 13:40:20 Last updated on 17/3/2007, 13:40:20 Последняя модификация 17/3/2007, 13:40:20 تمت الحتلنة الأخيرة ب- 17/3/2007, 13:40:20|
Welcome to Database Systems Course - 236363
|Dear Students, |
Welcome to Database Systems 236363, Spring 2007.
You are kindly required to read the syllabus and the F.A.Q. sections regarding SQL accounts and Administration carefully. Please notice that the logics prerequisite will be enforced, and students who didn't pass the logics course will be removed from the course during the semester.
The submission of the HWs in the course is in pairs only. You can use the "Find a Partner" tool in the course site for this purpose.
For the first tutorial, please bring the slides of Admin, and DBMStut_sql(intro+Queries).
We wish you good luck
|עדכון אחרון ב- 11/3/2007, 22:45:03 Last updated on 11/3/2007, 22:45:03 Последняя модификация 11/3/2007, 22:45:03 تمت الحتلنة الأخيرة ب- 11/3/2007, 22:45:03|