Introduction to Database Systems

Real Time Tests

Students have to pass throw 2 realtime tests during the semester. First test from SQL language, second test from data modeling. Maximum points from each of them is 15, minimum 7.

SQL Test

Student will get the task in paper form, that will contain list of tables, names of their attributes and tasks to do. Student will download test application from this link and unzip it. After the execution of application, he will log in with his school login (LDAP) and password and click on Ověřit a spustit test (it means Check and run test). Student will log in into database account studenttzd to database tzd, after that open New Query, where we will write and test SQL queries. After he is satisfied with his answer, he will copy (CTRL+C => CTRL+V) the query into the test application. The application always shows him the specific task, that he is solving. Then the query can be saved. Each query has to be saved separately. Text message will inform student about successful save.

After all tasks are done and the student wants to evaluate his test, he will press the button Vyhodnotit (it means Evaluate). At this point, student will be impossible to save new solutions or do any changes and automatic check of results will be done.

• If the task is not answered, or answered with an empty response, student will not get any points and task will be displayed with black color.
• If the task contains errors that lead to SQLException (syntax, typos, missing spaces, etc), the student will not get any points and task will be displayed with orange color.
• If the task does not have correct number of rows and columns in the response, the student will not get any points and task will be displayed with red color.
• If the task, that depends on the sequence (containing an ORDER BY clause), does not have all rows in correct order in all collumns, the student will not get points and task will be displayed with red color.
• If the task has correct answer, the student will get one point and the task will be displayed in green.

If the student will accidentally close the application, he can execute the application again, but only from the same IP address. Then the test can continue.
During the test we record these information about student:

• login
• IP address from where the first test run
• start time
• end time
• time to saving of particular answeres

Project

Students should choose projects during first two excercises and project has to be consulted with teacher. Maximal number of points from analysis is 15, minimal 7. Detailed information about project requirements are here.  The description of synthesis software is available here.

UPLOAD OF THE PROJECT HAS TO BE DONE TO 11.12.2011 23:59 

The description of upload system is available here.

Description of the project has to be presented in 5th week (10.10.2011) !!!

The first test (SQL language) will be in 10th week (14.11.2011) !!!

The repair test (SQL language) will be in 13th week (6.12.2011 12:30 in front of A1045) !!!

Lectures and Exercises