|
|
. |
. |
. |
Exercises
- The exercises on the Relational Algebra use an example database
(as a figure).
- Exercises on the Relational Algebra (no credit points)
You may discuss the solutions with Juho Muhonen.
- In order to learn the topics taught in the course you should
practice them. To assist practicing, there is a WWW-based practice software
that acts as the user interface (English and Finnish) for executing SQL-queries.
The program also keeps account of the tasks you have done and your solutions
to these tasks. When practicing using
this software you get information about possible problems in your solutions.
If you are able to perform the tasks succesfully and in schedule you get
also points affecting your grade on the course.
Training software
- Start the
Training software by clicking here.
Explanations of Oracle error codes may be found in Oracle manuals.
Look for the Error Messages manual within the Oracle Server Manuals. The manuals are
visible only within the domain Helsinki.fi.
- You may find it usefull to print the Brief SQL syntax.
Date related SQL functions are the only functions you need in the first set of exercises.
Date in transformed into the Finnish date format using function
to_char(the_date, 'DD.MM.YYYY').
Date constants may be given in the American form 'DD-MON-YYYY' for example '20-SEP-2000' or in the
Finnish form 'DD.MM.YYYY' for example 20.9.2000.
- The tasks are divided in two groups. Both groups have a deadline by which you have
to do the tasks in order to get points. You get points of answers found successful
by the software. The deadline for the first group of tasks is October 18th, and the deadline for the second
group is November 4th.
There will be an explanation session (in finnish) after both deadlines.
If you have any problems with the exercises, Juho Muhonen (email: Juho.Muhonen@cs.helsinki.fi)
is available for guidance weekly on Wednesdays at 12-14 and on Thursdays at 8-10 in room B326.
Juho is prepared to answer small questions by email, too.
There are two (2) exercise explanation lectures
(in Finnish)
the first Finnish session is on October 21st at 8-10 and
the second on November 4th at 8-10, both in Teollisuuskatu 23
Auditorium. Explanation lectures are given by Juho Muhonen.
- The answers for the
exercises will be published after the explanation sessions.
|
