Introduction to Database Systems

Credit Conditions

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 minimum 20. The maximum number of points for the conceptual modelling test is 20 and minimum 10. At most two attempts of every test will be possible.

The First Test

The first test will take place on the exercise no. 7. Students are allowed to use any static materials available on the web. They are not allowed to access shared content (email, social networks, forums, online documents and so on).

The test will use the following data model. Run this script to create the tables in your database. Last update of the script: 9.10.2019.

Home Project

Another part of the credit is a home project which 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. The detailed description of the project can be found here and example of the data analysis can be found here

The actual version of the web system for evaluation of the projects does not work correctly and has some issues with evaluation of the SQL scripts. Before you will upload your SQL scripts into the system, 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.