Sivut:
|
Exercises
In this course practicing is important in order to learn the issues and to master them. Some tasks for self testing are embedded in the web-based e-learning material. These tasks are aimed to provide feedback on how you have learnt the topic. They do not give any credit points. SQL practicingSQL queries and database maintenance operations are practiced using the SQL-Trainer software. There are 40 SQL tasks devided in 6 groups. Each group has a deadline of its own. Deadlines for the SQL-tasks are:
The database used in SQL practicing is described in the database schema (both graphical and textual). To start the training software go to the SQL-Trainer start page. Tasks succesfully carried out by the deadline bring in credit points. The Trainer software evaluates the answers and accepts or rejects them. There are no limits for the number of tries for each task. You may get at most 9 credit points of the SQL tasks. About 80 per cents of tasks are needed for the maximum credit. If you run into problems with the SQL tasks, you may post the description of your problem into the discussion group, send e-mail to the course assistant or the lecturer, or present your problem in the study group. The discussion group is there for students to assist each other. Discussion groups are in the Moodle environment (register there with your linux user account and password) You are, however, not supposed to give the correct queries as assistance but hints that assist the other student to find out the correct answer. Good hints are rewarded with bonus points. The course assistant is also following the discussion group on a regular basis. Example answers for the SQL tasks are published in the task page after the deadline. Hint: Do not leave answering the tasks to the last hours before the deadline. There might be computer or network problems. The working of the Trainer software is not monitored regularly during week-ends. Study groupsThe goal of a stydy group is to study the kernel structures and the design principles of the relational databases by the use of example cases. The stydy group has 4 official meetings and as many unofficial meetings as you want to. The course assistant is available as the instructor in the official meetings.
Database design task in study groupsEach study group designs a small database and presents their plan as a written document. This document consists of:
Technically the document should be either a MS-Word compatible document, a PDF-file or an HTML page. In the last stydy group session groups presents their plans to other groups. The group should prepare for the presentation by making slides about
|