 | Study programme 2019-2020 | Français | |
| Databases I | |||
Learning Activity |
| Code | Lecturer(s) | Associate Lecturer(s) | Subsitute Lecturer(s) et other(s) | Establishment |
|---|---|---|---|---|
| S-INFO-005 |
|
|
| Language of instruction | Language of assessment | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Term |
|---|---|---|---|---|---|---|---|
| Français | Français | 30 | 0 | 0 | 0 | 0 | Q1 |
| Organisational online arrangements for the end of Q3 2019-2020 assessments (Covid-19) |
|---|
|
| Description of the modifications to the Q3 2019-2020 online assessment procedures (Covid-19) |
| Quiz in Moodle |
Content of Learning Activity
The relational model.
Relational algebra.
Relational calculus.
SQL.
Normalization (3NF, BCNF, 4NF, 5NF).
Transaction management.
Required Reading
Note de cours - Partie 1 - Bases de données I (2019-2020) - Jef Wijsen
Required Learning Resources/Tools
Web site with course notes, slides, and past examinations.
Recommended Learning Resources/Tools
Not applicable
Other Recommended Reading
Serge Abiteboul, Richard Hull, Victor Vianu: Foundations of Databases. Addison-Wesley 1995, ISBN 0-201-53771-0
David Maier: The Theory of Relational Databases. Computer Science Press 1983, ISBN 0-914894-42-0
(both books are available online)
Mode of delivery
- Face to face
Type of Teaching Activity/Activities
- Cours magistraux
- Conférences
Evaluations
The assessment methods of the Learning Activity (AA) are specified in the course description of the corresponding Educational Component (UE)