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:46] ezimanyi [Temporal databases] |
teaching:infoh415:tp [2023/11/03 12:27] ezimanyi [Temporal databases] |
||
---|---|---|---|
Line 77: | Line 77: | ||
* {{: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:2021_infoh415_tp04_05_06_exercices.pdf|Exercises and solutions}} | ||
- | * {{:teaching:infoh415:infoh415_1415_tp04_05_06_scripts.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}} | ||
* {{:teaching:infoh415:ex10_aggregation_step_by_step.pdf|10th query step by step drawing}} | * {{:teaching:infoh415:ex10_aggregation_step_by_step.pdf|10th query step by step drawing}} | ||
Line 83: | 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 9 | ||
- | * Session 8: Queries 10 to 13 and constraints | + | * Session 8: Queries 10 to 13 |
===== Active databases ===== | ===== Active databases ===== |