Technion - Israel Institute of Technology  
236363 - Database Systems
  Spring 2011 EnglishRussianHebrewArabic  
Announcements

Moed B appeals
Appeals can be made until 30/10
Created on 9/10/2011, 06:58:27  
Reception hours before moed B

The following reception hours will be given:

Thursday 15/9 10:00 - Naama
Sunday 18/9 9:00 - Evgeny
Created on 11/9/2011, 08:26:08  
HW4 Grades
The grades were taken into account for final grade, they just weren't visible (sent) to you.
They became visible now, and it shouldn't change your final grade.

If you still have questions, please email Evgeny again.
Last updated on 19/7/2011, 15:09:36  
Exam A grades were published


Appeals can be made until 24/7
Created on 10/7/2011, 20:15:02  
Material NOT for exam
The following topics won't appear neither in Moed A nor in Moed B:

XQuery

ODL+OQL

Multivalued Dependencies
Created on 28/6/2011, 16:04:50  
Reception hours before the exam
The following reception hours will be given:

Tuesday 14:00 - Evgeny
Wednesday 9:00 - Naama
Last updated on 26/6/2011, 22:01:09  
HW4 was postponed
New due date is Monday, 27.6 at 9:00
Created on 21/6/2011, 16:45:16  
hw2
under the "Assignments" section you can find:
1. cases.rar - the tests that were run
2. tables.rar - the tables that were used
3. submit.rar - students submissions
Created on 21/6/2011, 11:43:47  
HW2 was graded
Appeals can be submitted to Naama until the exam.

If you did not receive a grade yet, you most probably did not submit a printout of your code.
To receive your grade contact Naama with you ID.
Last updated on 20/6/2011, 11:54:15  
No tutorial on Thursday

The tutorial on Thursday, 16.6 is canceled.
Created on 16/6/2011, 09:09:26  
HW3 checking mistake
In question 1-VAV (Datalog), the query:

badPurchase (C,V,W,D,T) <- purchase(C,V,W,D,T), not(client(C,_,_)), not(vegetable(V,_,_))

is correct. submit an appeal if points were reduced for it.
Last updated on 15/6/2011, 15:41:05  
No tutorial on Wednesday
The tutorial on Wednesday, 15.6 is canceled.
Created on 14/6/2011, 16:33:58  
No tutorial today


The tutorial today the 14th of june is cancelled
Created on 14/6/2011, 11:09:15  
HW3 was graded
Appeals can be submitted to Evgeny until the exam.
Created on 13/6/2011, 08:24:37  
HW4 was updated
Question 1 GIMEL was modified. Please use the new version. Sorry for the inconvenience.
Created on 12/6/2011, 12:28:40  
HW4 is published
Due date is Wednesday, 22.6.

Chag Sameach!
Created on 7/6/2011, 13:08:40  
F.A.Q for HW3 was opened
Check it out.
Created on 25/5/2011, 09:58:23  
complementary tutorial


A complementary tutorial will be given on Sunday 29/5, 16:30 at taub 5 for Naama's groups:
16:30 - Tuesday group
17:30 - Tuesday and Thursday groups
Created on 22/5/2011, 10:55:16  
new presentation slides
Two sets of slides were added:
1. Safety.pdf
Safe (Safe range) formulas (Exam relevant)
2. nf-course.pdf
Characterizing BCNF (definitions exam relevant)

They can be found under course material:
http://webcourse.cs.technion.ac.il/236363/Spring2011/ho/WCFiles/safety.pdf
http://webcourse.cs.technion.ac.il/236363/Spring2011/ho/WCFiles/nf-course.pdf
Last updated on 12/6/2011, 09:16:43  
No tutorial today


The tutorial today the 17th of may is cancelled
Created on 17/5/2011, 12:20:22  
FAQ for hw2 was opened
Created on 11/5/2011, 16:18:51  
HW2
Notice that you also need to submit a printout of your code
Last updated on 11/5/2011, 15:58:44  
hw2 extention

1.out was updated
Due to the many chenges the assignment can be submitted until Sunday 15.5 at 12:00

Happy independence day
Created on 10/5/2011, 10:51:04  
HW3 was published
Due date is Tuesday, 31.5.
Created on 8/5/2011, 14:26:24  
hw2 another update
1.out was updated again

sorry for the inconvenience
Created on 8/5/2011, 10:48:45  
HW2 update
The returned value in linksChain should be distinct.
Also, 1.out was updated at 21:30
Last updated on 7/5/2011, 21:19:44  
HW1 was graded
Appeals can be made until 15/5
Created on 29/4/2011, 11:48:18  
No tutorial on Thursday
The tutorial on Thursday, 28.4 is cancelled.
On the following Thursdays the tutorial will be held as usual.
Last updated on 27/4/2011, 12:16:42  
No tutorial tomorrow


The tutorial tomorrow the 27th of April is cancelled
Created on 26/4/2011, 21:01:34  
HW2 was updated

The function linkToFuture was updated to return article id and not article name
Created on 25/4/2011, 18:41:10  
HW2 parder.c was updated

An updated version of parser.c is on the course site
Created on 13/4/2011, 18:54:29  
HW2 (wet) is published


You can find HW2 in the assignments section.
Please find the time to review the homework.
Created on 12/4/2011, 09:34:39  
Additional presentation about division
was published under "course material".
Created on 6/4/2011, 15:18:47  
a typo was corrected in hw1 question 3.1
The new version is in the course site
Created on 3/4/2011, 11:52:58  
small changes were made in the first assignment

The new version can be found in the course site
Created on 27/3/2011, 15:57:57  
First assignment
The first assignment was published. It is due until 5/4

In order to solve it you should read the first two lectures in:
http://webcourse.cs.technion.ac.il/234293/Spring2011/en/ho_Lecture%20notes%20by%20Prof.%20Janos%20Makowsky.html

(especially slides 12-27 in lecture 2)

good luck
Created on 22/3/2011, 10:55:46  
PostgreSQL accounts created
Accounts were created for all the students registered to the course.
The PostgreSQL username is identical to your T2/TX username and the password is set to your ID with leading zeros if necessary.
The tables presented in the first tutorials are available for you to "play" with. You are encouraged to do so. Feel free to modify them as you like.
These are the same accounts that you'll use in the wet assignment.

Please check you can log in. You can use for this matter the web-interface - http://csl1.cs.technion.ac.il/~cs236363/phpPgAdmin-4.2.2/
If you encounter any problems, send email to aevgeny /at/ cs with your username and ID.
Last updated on 4/3/2011, 16:43:26  
Welcome to Database Systems Course - 236363

Dear Students,
Welcome to Database Systems 236363, Spring 2011.
You are kindly required to read the syllabus and the F.A.Q. sections regarding SQL accounts and Administration carefully.
SQL accounts will be opened soon, and further information will be given in the tutorials.
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.

We wish you good luck
Course Staff
Created on 27/2/2011, 12:51:35