| Code | Lecturer(s) | Associate Lecturer(s) | Subsitute Lecturer(s) et other(s) |
|---|---|---|---|
| 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 |
Contents
The relational model.<br style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;" />Relational algebra.<br style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;" />Relational calculus.<br style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;" />SQL.<br style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;" />Normalization.<br style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;" />Transaction management.
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
Term 1 Assessment - type
- Presentation and works
- Written examination
Term 1 Assessment - comments
Written examination on the theory and written examination on SQL.<br style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;" />Weights: theory 75%, SQL 20%, personal project 5%.
Weights for students who are exempted from the personal project: theory 80%, SQL 20%.
Term 2 Assessment - type
- N/A
Term 2 Assessment - comments
Not applicable
Term 3 Assessment - type
- Presentation and works
- Written examination
Term 3 Assessment - comments
Written examination on the theory and written examination on SQL.<br style="color: rgb(102, 102, 102); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;" />Weights: theory 75%, SQL 20%, personal project 5%.
Weights for students who are exempted from the personal project: theory 80%, SQL 20%.
Resit Assessment - Term 1 (B1BA1) - type
- N/A
Resit Assessment - Term 1 (B1BA1) - Comments
Not applicable
Type of Teaching Activity/Activities
- Cours (cours magistraux; conférences)