Projektowanie aplikacji z bazami danych
Design of an application processing data is multi-tier and requires components of different purposes. The goal is to present the appropriate design and implementation of this kind of application. During the classes we will proceed with a sequence of steps which will lead to understanding and creating of specific parts of the system and in the end we will get a complete and working application. More details are available at System Zapisów.
News
11.01.2026: If someone from a group on Monday or Tuesday is not able to complete the Exercise Set 10 according to the schedule, there is a possibility to present that a week later.
Presentations and examples
- Program
- Podstawy SQL Server
- TSQL: podstawy, przykłady
- TSQL: programowanie, przykłady
- Kursory, przykłady
- Wyzwalacze, przykłady
- Transakcje i blokady, przykłady
- Optymalizacja
- MongoDB, przykłady
- Neo4j, Apache Cassandra, przykłady: Neo4j, Cassandra
- Architektura Aplikacji
- DDD, przykłady
- NHibernate, przykłady (z pakietami, ~30MB), przykłady (bez pakietów, ~1,5MB)
- LINQ, przykłady
- Warstwa prezentacji, przykłady
- Automapper, przykłady
- Walidacja, przykłady
- Integracja aplikacji
Listy zadań
| Exercises | Title | Monday | Tuesday | Thursday | Friday |
| Lista 1 | T-SQL: basics | 13.10 | 14.10 | 16.10 | 17.10 |
| Lista 2 | T-SQL: programming | 20.10 | 21.10 | 23.10 | 24.10 |
| Lista 3 | Cursors and triggers | 27.10 | 28.10 | 30.10 | 31.10 |
| Lista 4 | Transactions | 03.11 | 04.11 | 06.11 | 07.11 |
| Lista 5 | Optimization | 17.11 | 18.11 | 20.11 | 21.11 |
| Lista 6 | MongoDB | 24.11 | 25.11 | 27.11 | 28.11 |
| Lista 7 | Neo4j and Cassandra | 01.12 | 02.12 | 04.12 | 05.12 |
| Lista 8 | DDD solution | 08.12 | 09.12 | 11.12 | 12.12 |
| Lista 9 | UI | 15.12 | 16.12 | 18.12 | 19.12 |
| Lista 10 | NHibernate | 12.01 | 13.01 | 15.01 | 16.01 |
| Lista 11 | Filtering, paging, sorting | 19.01 | 20.01 | 22.01 | 23.01 |
| Lista 12 | Validation and integration | 26.01 | 27.01 | 29.01 | 30.01 |
Rules
- During each class only exercises with a specific due date should be presented (unless otherwise agreed with the lecturer).
The approach in case of delay should be also agreed with the respective lecturer. - At the beginning of each laboratory class, each student should declare which tasks he or she is ready to present (and by that collect the respective points)
- Exercise sets will be published till each Wednesday evening (occasionally might be Thursday evening)
- Solutions should be presented during the laboratory classes. Any other way (e.g. sending files over e-mail) only after the earlier agreement with the lecturer.
- Points collected during the semester will determine the final grade according to the below table.
- Finally, please ensure you follow the kodeks samodzielnego studiowania.
Points thresholds table
| Points | Grade |
|---|---|
| 100%-90% | 5.0 |
| 90%-80% | 4.5 |
| 80%-60% | 4.0 |
| 60%-50% | 3.5 |
| 50%-40% | 3.0 |
| 40%-0% | 2.0 |