Database Systems II
Credit conditions
Student has to pass a test from a procedural language PL/SQL. The minimimum number of points is 8 and maximal 15. At most one attempt of the test is possible. The second part of the credit is a semestral project which is focused on a analysis and implementation of the data layer (ORM) of an information system under the platform C#/.NET or Java.
Real-time test
Real time test from PL/SQL will be in the 7th week. Student can use any type of materials during the test (except the social networks and the communication with other people).
- Model is same as in Database Systems I, NHL, script for Oracle.
- Description of the database (NHL)
- Test, Solution of the test
- The repair test from PL/SQL language will be on 28.4., 10:45, EB113.
Project
Requirements:
Evalution of the project:
- Analysis: 15, 15, and 11 points
- ORM: 15 and 11 points
Deadlines of the project:
- See slides of the first lecture.
Test from 2021½22
- Description of the test relation data model (last update 8.3.2022)
- SQL script for the test (last update 15.10.2021)
- Test, Solution of the test
Lectures and Exercises
| Week | Lecture | Exercise |
| 1 | Introduction Functional Analysis |
SQL Language --> Tasks and Examples |
| 2 | PL/SQL I - PL/SQL block, variables, exceptions
| PL/SQL Language -> Tasks and Examples tasks, solutions (last update: 15.2.2022) |
| 3 | PL/SQL II - Procedures, functions, triggers pdf (last update: 20.3.2023) | PL/SQL Language -> Tasks and Examples tasks, update sql script, solutions (last update: 22.2.2022) |
| 4 | PL/SQL III - Programming constructs, cursors, bulk-operations PL/SQL IV - Static and dynamic PL/SQL, bind variables, SQL injection | PL/SQL Language -> Tasks and Examples tasks, solutions (last update: 3.3.2022) |
| 5 | Transactions and DBMS recovery pdf (last update: 29.3.2023) | PL/SQL Language -> Tasks and Examples tasks, solutions (last update: 8.3.2022) |
| 6. | Concurrency Control I pdf (last update: 28.03.2023) | Example tests from last year Description: pdf (last change: 1.3.2021), script (last change: 1.3.2021). Tests (last update: 10.03.2021) |
| 7. | Concurrency Control II pdf (last update: 28.03.2023) | Real test Description: pdf (last change: 8.3.2022), script (last change: 8.3.2022). |
| 8. | T-SQL
| Consultation of the project T-SQL Language -> Tasks and Examples |
| 9 | 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)
|
| 10. | Object Relational Mapping (ORM) | Object Relational Mapping (ORM) |
| 11 | ASP.NET, Integration of 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 |