This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
teaching:infoh415:tp [2023/11/03 11:48] ezimanyi [Temporal databases] |
teaching:infoh415:tp [2023/11/30 09:37] ezimanyi [Active databases] |
||
---|---|---|---|
Line 73: | Line 73: | ||
* {{:teaching:infoh415:2021_infoh415_tp04_05_06_slides.pdf|Recap}} | * {{:teaching:infoh415:2021_infoh415_tp04_05_06_slides.pdf|Recap}} | ||
- | * {{:teaching:infoh415:difference_full.pdf| Drawing temporal difference}} | + | * {{:teaching:infoh415:temporal_difference_example.pdf| Drawing temporal difference}} |
* {{:teaching:infoh415:temporal_join_example.pdf| Drawing temporal join}} | * {{:teaching:infoh415:temporal_join_example.pdf| Drawing temporal join}} | ||
+ | * {{:teaching:infoh415:temporal_coalescing_example.pdf| Drawing temporal coalescing}} | ||
* {{:teaching:infoh415:2021_translationea.pdf| Traduction of EA schemas}} | * {{:teaching:infoh415:2021_translationea.pdf| Traduction of EA schemas}} | ||
- | * {{:teaching:infoh415:2021_infoh415_tp04_05_06_exercices.pdf|Exercises and solutions}} | + | * {{:teaching:infoh415:temporal_database_exercises.pdf|Exercises and solutions}} |
* {{:teaching:infoh415:postgresql_server_script.zip|SQL Server Scripts}} | * {{:teaching:infoh415:postgresql_server_script.zip|SQL Server Scripts}} | ||
* {{:teaching:infoh415:infoh415_tp05_ex10.pdf|Explanation of 10th query exercise}} | * {{:teaching:infoh415:infoh415_tp05_ex10.pdf|Explanation of 10th query exercise}} | ||
Line 82: | Line 83: | ||
* Planning: | * Planning: | ||
- | * Session 7: Exercice 1 (relational schema) and queries 1 to 9 | + | * Session 7: Exercice 1 (relational schema) and queries 1 to 8 |
- | * Session 8: Queries 10 to 13 and constraints | + | * Session 8: Queries 9 to 13 |
===== Active databases ===== | ===== Active databases ===== | ||
- | ==== Before Session 10 ==== | + | ==== Before Session 9 ==== |
If you are planning on working on your own laptop/computer (which is strongly advised given the state of the computers in the computer rooms), please download and install the following before the first exercise session. | If you are planning on working on your own laptop/computer (which is strongly advised given the state of the computers in the computer rooms), please download and install the following before the first exercise session. | ||
* For windows: | * For windows: | ||
Line 99: | Line 100: | ||
- | ==== Session 10 : Exercises "PhD" ==== | + | ==== Session 9 : Exercises "PhD" ==== |
* {{:teaching:infoh415:2021_adb_tp1_slides.pdf|Slides: Intro + recap}} | * {{:teaching:infoh415:2021_adb_tp1_slides.pdf|Slides: Intro + recap}} | ||
Line 106: | Line 107: | ||
- | ==== Sessions 11 and 12 : Exercises "Employees Departments Projects" ==== | + | ==== Sessions 10 and 11 : Exercises "Employees Departments Projects" ==== |
| | ||