 |
|
|
|
|
|
| Moed Bet Appeals were checked | | Answers are with the secretaries. |
|
| Created on 8/5/2012, 12:19:26 |
|
|
|
|
|
|
|
|
|
|
|
|
| Moed Bet Appeals can be submitted until May 6th at 12:00 | |
| Created on 22/4/2012, 18:13:36 |
|
|
|
|
|
|
|
|
|
|
|
|
| Moed Bet solution has been published | |
| Created on 19/4/2012, 11:57:12 |
|
|
|
|
|
|
|
|
|
|
|
|
| Moed Bet was checked and final grades were given | 3 points were added to the exam grade.
Appeals can be submitted by April 29th at 12:00 in a cell of your favorite course staff member. Please do not submit a copy of your exam. |
|
| Created on 15/4/2012, 11:41:07 |
|
|
|
|
|
|
|
|
|
|
|
|
| No reception hours of Eldar on Wednesday | | He will be available on Tuesday only. |
|
| Created on 26/3/2012, 17:37:13 |
|
|
|
|
|
|
|
|
|
|
|
|
| Reception hours before Moed Bet exam | Will be given by:
Eldar - on Tuesday, 27.3 at 14:00
Evgeny - on Wednesday, 28.3 at 14:00
Dima - on Thursday, 29.3 at 8:30
You may, and it's recommended, to send your questions in advance.
Good luck,
The course staff.
|
|
| Last updated on 26/3/2012, 20:21:06 |
|
|
|
|
|
|
|
|
|
|
|
|
| Moed Aleph and its solution was published | | Detailed checking policy of questions 1B and 2A is present in the solution file. |
|
| Created on 9/3/2012, 12:58:08 |
|
|
|
|
|
|
|
|
|
|
|
|
| Moed Aleph | The average exam grade was 72.6.
Appeals can be submitted by March 25th at 12:00 in a cell of your favorite course staff member. Please do not submit a copy of your exam. We also recommend you to send an email before submitting a formal appeal.
Purim Sameach,
The course staff.
|
|
| Created on 7/3/2012, 09:42:22 |
|
|
|
|
|
|
|
|
|
|
|
|
| Final grades are published | Dear Students,
The grades of HW2, exam Aleph and the final grade are published. No factor was applied.
You should have recently received details with grades about the tests over your HW2 projects. You should contact Dima if you wish to appeal HW2 results. You can do so during the whole month of March.
The policy about appeals of the exam will be announced later.
Regards,
the Course Staff |
|
| Last updated on 6/3/2012, 22:15:48 |
|
|
|
|
|
|
|
|
|
|
|
|
| A mistake in solution of XPath question in HW4 | | Please use the updated version on the site. |
|
| Created on 27/2/2012, 09:09:26 |
|
|
|
|
|
|
|
|
|
|
|
|
| Reception hours before the exam | Will be given by:
Dima - on Thursday, 23.2 at 17:30
Eldar - on Sunday, 26.2 at 14:00
Evgeny - on Monday, 27.2 at 09:30
You may, and it's recommended, to send your questions in advance.
Good luck,
The course staff. |
|
| Last updated on 22/2/2012, 17:07:39 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW4 is checked and returned | |
| Created on 22/2/2012, 11:01:34 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW#2 testing result | Dear students,
You can find the list of tests, DB and main.c over which we have tested your implementations in tests.zip, which is available under the Assignments section. In addition, you should have recently received an e-mail to your t2/tx accounts with a reference to the location where your personal test failures are detailed. Grades will be assigned later.
Regards,
Dima |
|
| Last updated on 20/2/2012, 17:02:55 |
|
|
|
|
|
|
|
|
|
|
|
| Last updated on 19/2/2012, 23:02:12 |
|
|
|
|
|
|
|
|
|
|
|
| Created on 10/2/2012, 16:23:54 |
|
|
|
|
|
|
|
|
|
|
|
|
| Neither ODL nor OQL will appear in the exams. | | Neither MOED A nor MOED B will contain these topics. |
|
| Created on 5/2/2012, 15:48:58 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW3 is checked and returned | |
| Created on 1/2/2012, 15:01:30 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW4 - clarification is added to question 2-BET. | |
| Created on 23/1/2012, 16:57:16 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW4 is out | | Due date is Monday, January 30th at 14:30 |
|
| Created on 18/1/2012, 10:26:30 |
|
|
|
|
|
|
|
|
|
|
|
|
| Wednesday group only: this week from 13:30 till 15:20 | Dear Students of the Wednesday group,
As I agreed with you, this week we meet on Wed 13:30 and study until 15:20.
Dima |
|
| Created on 17/1/2012, 00:06:32 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW3 - slight update in Datalog question | | The predicate is now personIndirectOwns(Pid,C), and not as appeared. |
|
| Last updated on 6/1/2012, 12:58:38 |
|
|
|
|
|
|
|
|
|
|
|
|
| No tutorial on this Wed (28/12/still 2011) | |
| Created on 27/12/2011, 16:16:21 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW3 is out | Due date is Sunday, 15.1.2012 at 14:30
Hag Sameach! |
|
| Created on 22/12/2011, 11:25:22 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW#1 is checked | | Your checked works (HW#1) are waiting for you in the returned-works boxes. You can appeal to Dima during his reception hours. |
|
| Last updated on 20/12/2011, 13:57:20 |
|
|
|
|
|
|
|
|
|
|
|
|
| Change in FD tutorial slides & Bug with passing float values into parametric queries | 1. Solutions to the examples at the end of the presentation were fixed.
2. A bug in passing float values into parametric values through PQexecParams()/PQexecPrepared() has been discovered. Please, read more details in the latest note of HW2 FAQ. |
|
| Last updated on 20/12/2011, 03:02:45 |
|
|
|
|
|
|
|
|
|
|
|
|
| Updates | 1. The exampe in slide 15 of the tutorial slides for Functional Dependencies has been slightly updated:
2. On Dec 14 validateResultWithQuery() in main.c of HW#2 has been updated. Make sure your implementation is well integrated with the most up-to-date version of main.c .
3. Periodically FAQ HW#2 is updated. Please, keep tracking after new answers there. |
|
| Last updated on 16/12/2011, 16:16:06 |
|
|
|
|
|
|
|
|
|
|
|
|
| Update of the example for task#7 (getIdsWithLowIncome) | The example for task#7 (getIdsWithLowIncome) has been updated. The output array should be as following:
{22222, 11111, 27183, 31415, 66666} (a person with a higher income should appear earlier). |
|
| Last updated on 13/12/2011, 16:38:05 |
|
|
|
|
|
|
|
|
|
|
|
|
| Change in Datalog tutorial slides | Slide #9 has been changed, please update your versions.
We apologize for the inconvenience. |
|
| Last updated on 12/12/2011, 16:06:39 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW#2: floating point values | As a few of you have noticed there is inconsistency between the textual description of the function prototypes and how they are declared in proto.h and impl.c . Some float parameters were declared double.
I have updated impl.c and proto.h so that now they match the textual description. Please, update your local files. Bear in mind that your implementation will be compiled with the current version of proto.h (unless further notes follow). If you have already inserted changes into impl.c, you can merely replace all occurrences of double with float.
Some of you asked how they could pass floating point values into parametric queries. Please, read FAQ about it. |
|
| Last updated on 11/12/2011, 21:49:35 |
|
|
|
|
|
|
|
|
|
|
|
| Last updated on 8/12/2011, 12:06:38 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW#2 tables | Initial content of the tables of HW#2 must have been added to your accounts.
Those who wish to install PostgreSQL and work offline can copy the tables from file Tables_hw2.zip, which is available in the Assignments section.
Good luck! |
|
| Last updated on 7/12/2011, 19:37:29 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW2 - due date is 28.12 (at 12:30) | |
| Created on 4/12/2011, 17:04:52 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW#2 is published | | under Assignment section |
|
| Created on 4/12/2011, 01:41:02 |
|
|
|
|
|
|
|
|
|
|
|
| Created on 30/11/2011, 23:52:15 |
|
|
|
|
|
|
|
|
|
|
|
|
| CSL1 passwords - update | Password reset - the mentioned form should be working now.
Please use it if you don't know the password. |
|
| Created on 16/11/2011, 14:05:35 |
|
|
|
|
|
|
|
|
|
|
|
|
| Complementary Tutorial on Wednesday, 30.11 | | Will be held at Taub 7. |
|
| Created on 15/11/2011, 15:36:22 |
|
|
|
|
|
|
|
|
|
|
|
|
| Additional Complementary Tutorial | Will be held at Taub 5 on Monday, 28.11 (notice the date) 18:30.
It will cover the same material as the other complementary tutorial. |
|
| Last updated on 15/11/2011, 15:42:07 |
|
|
|
|
|
|
|
|
|
|
|
| Last updated on 15/11/2011, 12:21:51 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW1 was postponed | | New due date is Sunday, 4.12 at 12:30 |
|
| Created on 15/11/2011, 09:50:16 |
|
|
|
|
|
|
|
|
|
|
|
|
| Complementary Tutorial on Wednesday, 30.11 | There will be a complementary 2-hour tutorial for all the tutorial groups on Wednesday, 30.11 at 12:30.
The classroom will be announced later. |
|
| Last updated on 14/11/2011, 14:33:59 |
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts | - Please, make sure you have and can access your
csl1 account. - Please, register your PostgreSQL account with command
register while you are logged onto csl1. - More details about the accounts are given at SQL accounts, which is found under FAQ. Please, read it thoroughly!
|
|
| Last updated on 14/11/2011, 13:39:07 |
|
|
|
|
|
|
|
|
|
|
|
|
| Q4 was updated again | | The subquery of question #4 in HW#1 was updated again on 13/11/11 at 13:50. |
|
| Created on 14/11/2011, 05:55:27 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW#1 updated | On 10-Nov-11 at 22:40 and earlier the following updates were made (see footnotes):
Question #4: the sub-query was corrected
Question #10: a remark was added
Question #11: an easement was given
Please, update the document if you downloaded it before the changes.
We published the assignment also in pdf and rich-text formats for your convenience. |
|
| Created on 10/11/2011, 22:44:24 |
|
|
|
|
|
|
|
|
|
|
|
|
| The lectures will take place at Taub 7 | | The change is permanent. |
|
| Created on 9/11/2011, 11:07:33 |
|
|
|
|
|
|
|
|
|
|
|
|
| HW#1 is published | | and is available under the Assignments section. Due date: Nov 28 at 12:30PM. |
|
| Last updated on 9/11/2011, 01:59:43 |
|
|
|
|
|
|
|
|
|
|
|
|
| Tutorials on Wednesday @ Taub 6 | | Good news! The tutorial lessons on Wednesday 14:30 will take place at Taub 6. |
|
| Created on 8/11/2011, 13:08:01 |
|
|
|
|
|
|
|
|
|
|
|
|
| Tutorials start next week | | The first tutorial will be about SQL (as it supposed to be). |
|
| Created on 2/11/2011, 20:17:43 |
|
|
|
|
|
|
|
|
|
|
|
|
| Late welcome to Database Systems Course | As you know, the tutorials will NOT have been held until further notice,
the lectures are held as usual.
We apologize for the silence on the website,
and wish you good luck,
Course staff. |
|
| Created on 27/10/2011, 18:48:41 |
|
|
|
|
|
|
Technion - Israel Institute of Technology 
