Database Systems II
Credit conditions
The first part of the semester is finished with a test on PL/SQL (probably in the 7th week). The second part includes a semestral project - an analysis and implementation of the data layer (ORM) of a part of an information system.
Test on PL/SQL
- The data Model: The Chamber of Deputies, The Czech Republic, see Database Systems I, Oracle version: create, drop (last update: 15.2.2024).
- Test 1, Solutions (last update 25.1.2024)
- The last repair test will be on Tuesday 30.4.2024 at 12:30. Please inform the lecturer about your attendance.
Tests on PL/SQL from previous years
- See menu Archiv/Database Systems II
Other resources
- Sakila sample database for Oracle (last update 25.1.2024)
Lectures and Exercises
| Week | Lecture | Exercise |
| 1 | Introduction, SQL: Oracle vs SQL Server pdf (last update: 21.2.2024) | tasks, create/init sql script, solutions (last update: 16.2.2024) |
| 2 | PL/SQL I: block, variables, exceptions pdf (last update: 28.2.2024) | tasks, solutions (last update: 27.2.2024) |
| 3 | PL/SQL II - Procedures, functions, triggers pdf (last update: 6.3.2024) | tasks, update sql script, solutions (last update: 5.3.2024) |
| 4 | PL/SQL III - Programming constructs, cursors pdf (last update: 13.3.2024) | tasks, solutions (last update: 12.3.2024) |
| 5 | PL/SQL IV - Dynamic SQL pdf (last update: 20.3.2024) | tasks, solutions (last update: 19.3.2024) |
| 6. | Object-relational data model pdf (last update: 27.3.2024) | PL/SQL, revision - tasks + solutions (last update: 4.4.2024) |
| 7. | Transactions and recovery
| PL/SQL test
|
| 8. | T-SQL pdf (last update: 10.4.2024) | tasks, create-script, solution (last update: 5.4.2024) |
| 9 | Concurrency Control I pdf (last update: 17.4.2024) | PL/SQL test, revision |
| 10. | Functional analysis pdf (last update: 24.4.2024) | Semestral Project: Form design and functional analysis |
| 11 | Concurrency Control II Study at home | |
| 12 | Query processing in DBMS Study at home | Mini-specification of transaction
|
| 13 | Object-relational Mapping StoreIS_orm.zip (C# + ADO.NET + SQL Server, 15.5.2024) | Implementation of transaction |