Moed B Grades | |
Dear Students, Exam grades are online, exam scans will be available soon. There was a factor of 6 points for the exam grade ( for exam grades >=49) Your final grade is calculated based on the following formula: if ExamB>54 FinalB = HW1*0.045+HW2*0.065+HW3*0.045+HW4*0.045+ExamB*0.8 (ExamB is the grade after the 6 points factor) else FinalB = ExamB The exam form and the solution were uploaded to the previous exams folder on website. Regarding appeals: - Appeals may be submitted until 15/10, at 23:55. No appeals will be accepted after this date. - For submitting an appeal, read the instructions & fill the Appeal Form (on the course website, under the Material\Additional Material tab). Read all the instructions carefully and follow all of them. In particular, when you submit an appeal it should not include the first page of the appeal form. Email your appeal, together with your exam scan, to Shoval. The subject of the mail should be: Moed B Appeal. - You should appeal *only* in cases you think a correct answer was marked as a mistake. - Do not appeal on the amount of points decreased! Best, The Course Staff |
פורסם ב-1/10/2017, 17:17:34 Created on 1/10/2017, 17:17:34 Создано1/10/2017, 17:17:34 تم النشر ب-1/10/2017, 17:17:34 |
Reception Hours Before Exam B | |
Dear Students, Shoval's reception hour will be held on Tuesday 26.9 at 17:30 in Taub 201. Dvir's reception hour will be held on Wednesday 27.9 at 10:30 in Taub 8. Good Luck! |
פורסם ב-24/9/2017, 09:50:43 Created on 24/9/2017, 09:50:43 Создано24/9/2017, 09:50:43 تم النشر ب-24/9/2017, 09:50:43 |
Moed A Grades | |
Dear Students, Exam grades are online, exam scans will be available soon. There was a factor of 6 points for the exam grade ( for exam grades >=49) Your final grade is calculated based on the following formula: if ExamA>54 FinalA = HW1*0.045+HW2*0.065+HW3*0.045+HW4*0.045+ExamA*0.8 (ExamA is the grade after the 6 points factor) else FinalA = ExamA The exam form and the solution were uploaded to the previous exams folder on website. Regarding appeals: - Appeals may be submitted until 10/8, at 23:55. No appeals will be accepted after this date. - For submitting an appeal, read the instructions & fill the Appeal Form (on the course website, under the Material\Additional Material tab). Read all the instructions carefully and follow all of them. In particular, when you submit an appeal it should not include the first page of the appeal form. Email your appeal, together with your exam scan, to Shoval. The subject of the mail should be: Moed A Appeal. - You should appeal *only* in cases you think a correct answer was marked as a mistake. - Do not appeal on the amount of points decreased! Best, The Course Staff |
עדכון אחרון ב-23/7/2017, 23:57:21 Last updated on 23/7/2017, 23:57:21 Последняя модификация23/7/2017, 23:57:21 تمت الحتلنة الأخيرة ب-23/7/2017, 23:57:21 |
Clarification | |
XPath2.0 is not in the material required for the exam as it is not studied in lectures or tutorials. That is, what is required of the tutorial presentation on this subject(XML and XPath) are slides 1 to 31. (Xpath1.0, that is the version studied in class is in the material for the exam) Good Luck, The Course Staff. |
עדכון אחרון ב-17/7/2017, 16:24:49 Last updated on 17/7/2017, 16:24:49 Последняя модификация17/7/2017, 16:24:49 تمت الحتلنة الأخيرة ب-17/7/2017, 16:24:49 |
HW4 grades | |
HW4 grades were uploaded and returned to secretaries. |
פורסם ב-13/7/2017, 13:45:11 Created on 13/7/2017, 13:45:11 Создано13/7/2017, 13:45:11 تم النشر ب-13/7/2017, 13:45:11 |
HW2 feedbacks and unit tests | |
The feedbacks and unit tests were uploaded in the same time as your grades How to get it? Feedback - in the HW2 submission section you'll find a black arrow, you'll download a called id1-id.returend.zip with the excel & pdf feedback. Unit tests - unzip the solved solution we uploaded, you'll find the tests there. Please download and check yourselves before sending any confused emails. |
פורסם ב-5/7/2017, 15:29:11 Created on 5/7/2017, 15:29:11 Создано5/7/2017, 15:29:11 تم النشر ب-5/7/2017, 15:29:11 |
Reception Hours Before The Exam | |
Dear Students, Shoval's reception hour will be held on Sunday 16.7 at 17:00 in Taub 7. Dvir's reception hour will be held on Monday 17.7 at 16:00 in Taub 7. Shoval's Reception hour next week is cancelled. Good Luck! |
עדכון אחרון ב-5/7/2017, 13:56:26 Last updated on 5/7/2017, 13:56:26 Последняя модификация5/7/2017, 13:56:26 تمت الحتلنة الأخيرة ب-5/7/2017, 13:56:26 |
HW2 grades are given | |
Dear Students HW2 is checked. Please check the HW2 notes and appealing policy document in the HW2 section. A full solution option and the unit tests are available to you under the solution zip file. Feedbacks will be upload soon. In your feedback you can see your grading components and the testing remarks on your PDF. Good luck |
פורסם ב-5/7/2017, 00:52:35 Created on 5/7/2017, 00:52:35 Создано5/7/2017, 00:52:35 تم النشر ب-5/7/2017, 00:52:35 |
Exam Moed A - Information and Structure | |
Dear Students, The material you should know for the exam is all the lectures, tutorials, and homework. The exam will be with open material. There will be three parts in the exam: 1. Database Design – ERD, Functional Dependencies and normal forms. 2 Questions 2. Relational Queries – 2 Questions 3. noSQL – XML,RDF, neo4j, mongoDB –4 questions in this part, and you have a selection between neo4j and mongoDB, so in total you answer 3 questions in this part. Wish You All Good Luck ! The Course Staff. |
עדכון אחרון ב-4/7/2017, 23:49:44 Last updated on 4/7/2017, 23:49:44 Последняя модификация4/7/2017, 23:49:44 تمت الحتلنة الأخيرة ب-4/7/2017, 23:49:44 |
Reminder: No Tutorials this week | |
Dear Students, Please pay attention that Dvir's tutorials this week are cancelled (due to the complementary tutorials during the semester). Best, Course Staff. |
עדכון אחרון ב-2/7/2017, 22:57:19 Last updated on 2/7/2017, 22:57:19 Последняя модификация2/7/2017, 22:57:19 تمت الحتلنة الأخيرة ب-2/7/2017, 22:57:19 |
Dvir's office hour is cancelled for this week |
פורסם ב-2/7/2017, 22:54:05 Created on 2/7/2017, 22:54:05 Создано2/7/2017, 22:54:05 تم النشر ب-2/7/2017, 22:54:05 |
HW1 Grades are Online | |
Dear Students, HW1 were checked and will be returned on Sunday. Best, The Course Staff. |
פורסם ב-29/6/2017, 22:46:45 Created on 29/6/2017, 22:46:45 Создано29/6/2017, 22:46:45 تم النشر ب-29/6/2017, 22:46:45 |
HW3 Grades are Online | |
Dear Students, HW3 were checked and returned to secretaries. Best, The Course Staff. |
פורסם ב-25/6/2017, 12:51:51 Created on 25/6/2017, 12:51:51 Создано25/6/2017, 12:51:51 تم النشر ب-25/6/2017, 12:51:51 |
Clarification for HW4 | |
Dear Students You must submit your homework in the template you received them and answer your answers in the assigned places, otherwise your question will not be examined. Also please pay attention to answer only what you are requested, and use the syntax we learned in class. Best, The Course Staff. |
עדכון אחרון ב-19/6/2017, 23:37:54 Last updated on 19/6/2017, 23:37:54 Последняя модификация19/6/2017, 23:37:54 تمت الحتلنة الأخيرة ب-19/6/2017, 23:37:54 |
HW4 is online | |
Due date is 3.7 It is very recommended to check you answers by using neo4j and mongoDB on your computer. You can find links for downloads in the tutorials. For the xml and xpath part you can use an online xpath tester. (Google it) Contact Shoval for any questions. Good luck! |
עדכון אחרון ב-17/6/2017, 18:09:55 Last updated on 17/6/2017, 18:09:55 Последняя модификация17/6/2017, 18:09:55 تمت الحتلنة الأخيرة ب-17/6/2017, 18:09:55 |
HW3 FAQ was updated | |
Please review |
פורסם ב-14/6/2017, 13:21:29 Created on 14/6/2017, 13:21:29 Создано14/6/2017, 13:21:29 تم النشر ب-14/6/2017, 13:21:29 |
Changes in office hours + tutrial presentation update | |
Dear students 1. Dvir's office hour has changed to Monday 15:30, until the end of the semester. 2. The MongoDB tutorial presentations received an updated in the MapReduce part. please use the updated one The course staff |
פורסם ב-12/6/2017, 13:47:12 Created on 12/6/2017, 13:47:12 Создано12/6/2017, 13:47:12 تم النشر ب-12/6/2017, 13:47:12 |
HW3 is online | |
due date is 18.6 contact Shoval for any questions |
פורסם ב-30/5/2017, 13:09:34 Created on 30/5/2017, 13:09:34 Создано30/5/2017, 13:09:34 تم النشر ب-30/5/2017, 13:09:34 |
HW2 FAQ has updated | |
please review please check the BAD_PARAMS\NOT_EXISTS question since it has been updated. also, for those of you with malfunctioned computer, or unable to set up the envirmonet, IT has allocated a pool of virtual machines with the environment installed. Usage instruction in the FAQ |
עדכון אחרון ב-28/5/2017, 23:29:40 Last updated on 28/5/2017, 23:29:40 Последняя модификация28/5/2017, 23:29:40 تمت الحتلنة الأخيرة ب-28/5/2017, 23:29:40 |
HW2 due date is postponed to 5.6 | |
Please note that HW3 release date will not be change and it is still 29.5 |
עדכון אחרון ב-25/5/2017, 16:17:20 Last updated on 25/5/2017, 16:17:20 Последняя модификация25/5/2017, 16:17:20 تمت الحتلنة الأخيرة ب-25/5/2017, 16:17:20 |
Complementary Tutorial | |
Tuesday's 30.5 tutorial is canceled (Due to Shavuot). A complementary tutorial will be given on Sunday 28.5, 16:30 in Taub 8. Since Monday's 29.5 tutorial will be on the same subject (Neo4j), Tuesday's group students are welcome in both tutorials (Sunday & Monday). |
פורסם ב-24/5/2017, 23:32:18 Created on 24/5/2017, 23:32:18 Создано24/5/2017, 23:32:18 تم النشر ب-24/5/2017, 23:32:18 |
HW2 FAQ updated | |
please review |
עדכון אחרון ב-24/5/2017, 23:32:33 Last updated on 24/5/2017, 23:32:33 Последняя модификация24/5/2017, 23:32:33 تمت الحتلنة الأخيرة ب-24/5/2017, 23:32:33 |
HW2 FAQ updated | |
Some good and important questions were asked. please review the FAQ. Good luck |
פורסם ב-22/5/2017, 22:48:53 Created on 22/5/2017, 22:48:53 Создано22/5/2017, 22:48:53 تم النشر ب-22/5/2017, 22:48:53 |
HW2 updates | |
Dear Students 1. There was a minor bug in the function "printResults" in DBConnector.java. The function was printing the results of the left hand side of a Cartesian product of a table with itself, without aliasing (A X A), instead of the right hand side data. The bug is fixed and the updated file is now in the HW zip file. Thanks to the student who mentioned it. This should not affect what so ever on your work done so far, nor the validity of the questions. 2. FAQ is updated 3. Dvir will give another office hour on Monday 22/5 in 15:30, for those who can't make it to 16:30, so office hours are 15:30-17:30. The office hours location is currently in Taub 645 (TDK lab) but might change to Taub 642. Please check in both places (both of them in the 6th floor). Good luck |
עדכון אחרון ב-22/5/2017, 09:04:02 Last updated on 22/5/2017, 09:04:02 Последняя модификация22/5/2017, 09:04:02 تمت الحتلنة الأخيرة ب-22/5/2017, 09:04:02 |
Teaching Assistant in Charge | |
Dear Students, From now on, Shoval will be the Teaching assistant in charge. The Course Staff. |
עדכון אחרון ב-18/5/2017, 00:23:41 Last updated on 18/5/2017, 00:23:41 Последняя модификация18/5/2017, 00:23:41 تمت الحتلنة الأخيرة ب-18/5/2017, 00:23:41 |
Cancelled Lecture 16/05 (Today) | |
This is a reminder that today's lecture (16/05) is cancelled. The compensation lecture has been given on Sunday, 30/04. - Benny |
פורסם ב-16/5/2017, 05:30:29 Created on 16/5/2017, 05:30:29 Создано16/5/2017, 05:30:29 تم النشر ب-16/5/2017, 05:30:29 |
Complementary Tutorial for Monday's group on 21.5 (Sunday next week) | |
Dear Students, The complementary tutorial for Monday's group will be held on Sunday 21.5 at 16:30 in Taub 6. Best, The Course Staff |
עדכון אחרון ב-14/5/2017, 12:01:55 Last updated on 14/5/2017, 12:01:55 Последняя модификация14/5/2017, 12:01:55 تمت الحتلنة الأخيرة ب-14/5/2017, 12:01:55 |
HW2 FAQ is available under FAQ |
פורסם ב-13/5/2017, 18:21:03 Created on 13/5/2017, 18:21:03 Создано13/5/2017, 18:21:03 تم النشر ب-13/5/2017, 18:21:03 |
Dvir's office hour is cancelled for this week |
פורסם ב-11/5/2017, 10:42:47 Created on 11/5/2017, 10:42:47 Создано11/5/2017, 10:42:47 تم النشر ب-11/5/2017, 10:42:47 |
The tutorial on Monady 15/5 is cancelled. A complementary tutorial will be announced soon. |
פורסם ב-11/5/2017, 10:38:17 Created on 11/5/2017, 10:38:17 Создано11/5/2017, 10:38:17 تم النشر ب-11/5/2017, 10:38:17 |
HW2 is Online | |
Submission in pairs. For any questions contact Dvir Good luck! |
פורסם ב-9/5/2017, 09:54:17 Created on 9/5/2017, 09:54:17 Создано9/5/2017, 09:54:17 تم النشر ب-9/5/2017, 09:54:17 |
HW1 submission deadline is postponed | |
You may submit it until Sunday 14/5, 23:59. |
פורסם ב-8/5/2017, 21:37:46 Created on 8/5/2017, 21:37:46 Создано8/5/2017, 21:37:46 تم النشر ب-8/5/2017, 21:37:46 |
Shoval's office hour this week will be on Wednesday at 10:30 |
פורסם ב-7/5/2017, 18:53:03 Created on 7/5/2017, 18:53:03 Создано7/5/2017, 18:53:03 تم النشر ب-7/5/2017, 18:53:03 |
Reminder : complementary lecture | |
Dear Students, The complementary lecture will be held in 30.4 at 16:30-18:30, in Taub 2. Tutorial 5 slides (SQL queries) are available online, please contact the teaching assistants for any questions. The Course Staff |
פורסם ב-28/4/2017, 15:41:05 Created on 28/4/2017, 15:41:05 Создано28/4/2017, 15:41:05 تم النشر ب-28/4/2017, 15:41:05 |
Changes in complementary tutorial time | |
Dear Students, Due to memorial day, the complementary SQL tutorial (tutorial 5) will be held in 27/5 at 15:30 in Taub 5 The Course Staff |
עדכון אחרון ב-25/4/2017, 16:37:25 Last updated on 25/4/2017, 16:37:25 Последняя модификация25/4/2017, 16:37:25 تمت الحتلنة الأخيرة ب-25/4/2017, 16:37:25 |
An updated version to HW1 was uploaded | |
Changes are marked in yellow. Please make sure you submit the right version! |
עדכון אחרון ב-25/4/2017, 13:17:22 Last updated on 25/4/2017, 13:17:22 Последняя модификация25/4/2017, 13:17:22 تمت الحتلنة الأخيرة ب-25/4/2017, 13:17:22 |
Changes is complementary lecture and tutorial times | |
Dear Students, The complementary lecture will be held in 30.4 at 16:30-18:30 followed by the complementary tutorial. Both in Taub 2 The Course Staff |
פורסם ב-18/4/2017, 16:58:07 Created on 18/4/2017, 16:58:07 Создано18/4/2017, 16:58:07 تم النشر ب-18/4/2017, 16:58:07 |
HW1 is online | |
Submission is May 9th in the course cell. If you have any questions please contact Liat. Happy Passover and enjoy your vacation! |
פורסם ב-7/4/2017, 14:43:46 Created on 7/4/2017, 14:43:46 Создано7/4/2017, 14:43:46 تم النشر ب-7/4/2017, 14:43:46 |
Shoval's office hour is canceled for this week |
פורסם ב-3/4/2017, 16:23:30 Created on 3/4/2017, 16:23:30 Создано3/4/2017, 16:23:30 تم النشر ب-3/4/2017, 16:23:30 |
PostgreSQL installation | |
Dear Students A guide for local PostgreSQL installation can be found under course materials->additional files. We will use it on HW2, and you are encouraged to use it on HW1, to verify your answers. The course staff |
פורסם ב-30/3/2017, 15:38:06 Created on 30/3/2017, 15:38:06 Создано30/3/2017, 15:38:06 تم النشر ب-30/3/2017, 15:38:06 |
Complementary Tutorial (3) for Monday's group on Thursday (6/4) | |
A complementary tutorial (3) will be held on Thursday (6/4) on Taub 8, 11:30-12:30. |
עדכון אחרון ב-29/3/2017, 09:49:25 Last updated on 29/3/2017, 09:49:25 Последняя модификация29/3/2017, 09:49:25 تمت الحتلنة الأخيرة ب-29/3/2017, 09:49:25 |
Complementary Lecture on Sunday (2/4) | |
A complementary lecture will be held on Sunday April 2nd on Taub 4. The lecture will start at 16:30 and will end approximately on 18:00 (without a break). |
פורסם ב-29/3/2017, 09:45:24 Created on 29/3/2017, 09:45:24 Создано29/3/2017, 09:45:24 تم النشر ب-29/3/2017, 09:45:24 |
Some answers and clarifications from tutorial 1 | |
Dear Students here are some corrections and answers to questions I was been asked in tut.1 and I gave a perhaps misleading or unclear answer, or I said I'll clarify those questions in an announcement : 1. can One just insert or delete rows from view? - if you have the right permissions (e.g. superuser or admin), actually, yes. while the view might filter out what you have inserted or deleted. The manipulation is done on the underlying table. 2. duplicate a table with inserting it to itself - you cannot duplicate a table with a PK, while a table without PK you can ( you can create a table without PK). 3. DECIMAL(precision, scale) - p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the decimal point 4. insertion fields order - if I understood the question right (if not, the student who asked is more then welcome to email me about that) the question is about If one can insert a value to a field which is not in the order of the appearance of fields in the schema - the answer is yes. the 2 lists you are providing to the INSERT should be in the same length, and the first one (lets call it FieldsList) should have the names of the fields you are giving a specific data for, in the value list (ValuesList). for an iterator 0<=I<=lists size , when inserting new data the value in ValuesList[I] is validated against the field definition of FieldsList[I]. if every value is ok and you are ok with table constrains (NULLS, Unique, Keys, etc..) , the new values will be inserted to their fields. there is no (need to have) enforcement about the order of the fields names in FeildsList compared to the order they are appearing in the schema. for example (lets assume that the Books table from tut1 is allowing NULL values except its PK) this INSERT command is fine : INSERT INTO Books (Year, Book_id) VALUES ( 5, 6) this will create a book with id=6 and year=5, while all other fields are NULL. as you can see, this is done without the consideration of the appearance of the fields in the schema itself (where Book_id is "before" Year). 5. can I call a column "SELECT" - yes, you should you SELECT "SELECT" FROM TableName in order to query 6. can one delete a referenced primary key column - no. Dvir |
פורסם ב-28/3/2017, 11:23:41 Created on 28/3/2017, 11:23:41 Создано28/3/2017, 11:23:41 تم النشر ب-28/3/2017, 11:23:41 |
Changes during the semester | |
All of the changes in lectures/tutorials appear under events. Please make sure you are updated with all of them. |
פורסם ב-21/3/2017, 12:46:54 Created on 21/3/2017, 12:46:54 Создано21/3/2017, 12:46:54 تم النشر ب-21/3/2017, 12:46:54 |
The tutorial on Monday 27/3 is cancelled. |
פורסם ב-21/3/2017, 12:43:32 Created on 21/3/2017, 12:43:32 Создано21/3/2017, 12:43:32 تم النشر ب-21/3/2017, 12:43:32 |
Tuesday 15:30 recitation's location update | |
Dear Students, The recitation has changed to Fishbach 505. The Course staff |
פורסם ב-20/3/2017, 10:47:20 Created on 20/3/2017, 10:47:20 Создано20/3/2017, 10:47:20 تم النشر ب-20/3/2017, 10:47:20 |
Welcome to Database Systems Course, Cancelled Lecture | |
Dear Students, Welcome to Database Systems Course! The lecture on Tuesday next week (21/03) is cancelled, but recitations will be given normally. Good Luck, The Course staff |
עדכון אחרון ב-15/3/2017, 18:36:17 Last updated on 15/3/2017, 18:36:17 Последняя модификация15/3/2017, 18:36:17 تمت الحتلنة الأخيرة ب-15/3/2017, 18:36:17 |