Introduction to Database Systems
News
2.11.2018 - The solution of the first test is presented here.
16.11.2018 - The repair of the first test will be on Friday 23.11.2018 at 9:00 in the class EB207.
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 modeling 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: 24.10.2018 14:20.
Home Project
Another part of the credit is a home project which is focused on an data analysis of an information system. The maximum number of points for the home project is 30 and minimum is 15. The detailed description of the project can be found here
Actual version of web system for evaluation of the projects does not work correctly and has some issues with evalution 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. Link also contains template of the SQL scripts with the three files.
| Week | Lecture | Exercise |
| 1. | Lecture slides: Introduction to database systems Lecture slides: Relational model | Tasks: Conceptual Data Model, SQL Script: Customer-Purchase-Product Description: Connection to a Sql Server |
| 2. | Lecture slides: Relational algebra Lecture slides: SQL I Script: Student study subject | Tasks: Task understanding |
| 3. | Lecture slides: SQL II | Tasks: SQL I Solutions: SQL I |
| 4. | Lecture slides: SQL III | Tasks: SQL II Solutions: SQL II |
| 5. | Sample tasks | Tasks: SQL III Solutions: SQL III |
| 6. | Lecture slides: Conceptual modelling I | Tasks: Test practise |
| 7. | Lecture slides: DDL, DML | Test 1 - SQL SELECT statement Description: Data model Script: Station, Substance, Measurement |
| 8. | Lecture slides: Conceptual modelling II | Script: Airline model Tasks: DDL, DML Solutions: DDL, DML |
| 9. | Test 2 - DDL and DML | |
| 10. | Specification: Project Lecture slides: Task specification | Approval of project topics |
| 11. | Lecture slides: Functional dependencies | Submission of task specification (27.11.) |
| 12. | Lecture slides: Normal Forms | Tasks: Functional Dependencies |
| 13. | Tasks: Decomposition | |
| 14. | Final test (max 10p/ min 5p) | Presentation of the project and final submission of project |