This is an old revision of the document!

INFO-H-415 : Exercises

Active databases

Before Session 1

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 exercice session.

For windows:
- Azure studio or SQL Server Management Studio
- SQL Server Express
For mac:
- Follow this tutorial. Note that I could not verify if this tutorial works by myself.
For linux:
- SQL Server. While choosing the “edition”, please select the free “Express” edition.
- Azure studio. To connect to your SQL Server express, please indicate server: “localhost”, login: “SA” and the password selected during the installation of SQL Server.

Session 1 : Exercises "PhD"

Sessions 2 and 3 : Exercises "Employees Departments Projects"

Recap
Exercises + Solutions
SQL Server Scripts
New scripts
The second exercise session will take place the 30/09 14h-16h in S.UB4.126

Temporal databases

Sessions 4, 5 and 6

Recap
Drawing temporal difference Attention: this drawing is not totally correct, an update version should be posted soon
Drawing temporal join
Traduction of EA schemas
Exercises and solutions
SQL Server Scripts
Explanation of 10th query exercise
10th query step by step drawing

Planning:
- Session 4: Exercice 1 (relational schema) and queries 1 to 5
- Session 5: Queries 6 to 8 and constraints
- Session 6: Queries 9 to 13

Graph databases

Sessions 7, 8, 9

Material for Graph databases sessions

Please be sure to install the correct version of Neo4J as indicated in the installation document.

Spatial databases (PostGIS)

For the spatial databases exercises, you will to install the following tool on your computer:

The two first exercise sessions will both be devided into a lab part and an exercise part. During the lab part, we will show you how to use the different tools and what we can do with them. This part will not be covered during the exam. During the exercise part, you will need to write some spatial databases requests. This part will be covered during the examination. PostgreSQL and PostGIS should be easy to install and are the two software necessary to perform the exercises. QGIS will only be used for the lab part of the sessions.

Table of Contents