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
(none)
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
- Architektura
- Domain-Driven Design, przykłady
- NHibernate, przykłady
- LINQ, przykłady
- Warstwa prezentacji, modele danych, przykłady
Listy zadań
| Exercises | Title | Monday | Thursday | Friday |
| Lista 1 | T-SQL: basics | 13.3.2023 | 9.3.2023 | 10.3.2023 |
| Lista 2 | T-SQL: programming | 20.03.2023 | 16.03.2023 | 17.03.2023 |
| Lista 3 | Cursors | 27.03.2023 | 23.03.2023 | 24.03.2023 |
| Lista 4 | Triggers | 03.04.2023 | 30.03.2023 | 31.03.2023 |
| Lista 5 | Transactions and locks | 17.04.2023 | 13.04.2023 | 14.04.2023 |
| Lista 6 | Optimization | 24.04.2023 | 20.04.2023 | 21.04.2023 |
| Lista 7 | MongoDB | 08.05.2023 | 27.04.2023 | 28.04.2023 |
| Lista 8 | Neo4j | 15.05.2023 | 04.05.2023 | 05.05.2023 |
| Lista 9 | Application specification | 22.05.2023 | 11.05.2023 | 12.05.2023 |
| Lista 10 | Domain model & Application Services | 29.05.2023 | 18.05.2023 | 26.05.2023 |
| Lista 11 | User Interface | 05.06.2023 | 25.05.2023 | 02.06.2023 |
| Lista 12 | Repositories, NHibernate | 12.06.2023 | 01.06.2023 | 07.06.2023 |
| Lista 13 | Models, filtering-paging-sorting, specifications | 19.06.2023 | 15.06.2023 | 16.06.2023 |
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.
Points tresholds 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 |