Database Systems I
Actual info
- Final test, December 13, 2023: test_20231213a.pdf, test_20231213b.pdf
- Welcome to the new academic year
- The repair test from SELECT queries will be 21.11.2023 at 12:30 in the classroom EB113.
- The repair test from DML/DDL commands will be 13.12.2023 at 16:00 in the classroom EB207.
Summary of main documents
- Project instructions (last update: 15.10.2023)
- Sample project (last update: 15.11.2021)
Online Tests
You have to pass two tests which will take place directly on a computer during an exercise. The first test will be focused on SELECT queries. The second test will be focused on a database conceptual design and its creation. It is possible to use any materials during the tests (any communication with classmates will be prohibited). The maximum number of points for the SELECT test is 40 and the minimum is 20. The maximum points for the conceptual modeling test are 20 and a minimum is 10. At most two attempts of every test will be possible. It is not possible to use a web browser. You can use own paper and electronic materials.
- Model: The chamber of deputies (data model) , The Czech Republic: chamber_cr_en.sql
- Model description: model.pdf
- Example test: test.pdf
- First attempt of the test: test 16:00.pdf , test 17:45.pdf and solutions.pdf
- Example DML/DDL test: test.pdf
Home Project
A home project is focused on data analysis of an information system. The maximum number of points for the home project is 30 and the minimum is 15. One part of the project is focused on the SQL scripts. Before uploading your SQL scripts into the system, you may test them using the desktop application. We will use this software for the evaluation as well. The link also contains a template of the SQL scripts with the three files. Example of the sql scripts are here.
