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 |
| 11 | Object Relational Mapping (ORM) pdf (lecture, last update: 05.04.2023) scripts.zip (create script, a generator of DTO, last update: 5.4.2022) AuctionSystemORM_sqls (ORM, .NET, SQL Server, last update: 5.4.2022) Object Relational Mapping (ORM) Concurrency Control II ASP.NET, Integration of ORM:
| pdf (last change: 8.3.2022), script (last change: 8.3.2022). Consultation of the project Object Relational Mapping (ORM) Object Relational Mapping (ORM) Integration of ORM, GUI |
| 12 | Patterns of ORM Integration into User Interface Forms
| Integration of ORM, GUI
|
| 13 | Physical Database Design, Query Processing pdf (lecture, last update: 26.4.2022) | Integration of ORM, GUI |
| 14 |
Object-Relational Data Model | Isolation levels of transactions: dais_cv9.pdf, dais_cv9-scripts.zip |