 | Study programme 2018-2019 | Français | |
 | Databases I | ||
Activité d'apprentissage à la Faculty of Science |
| Code | Lecturer(s) | Associate Lecturer(s) | Subsitute Lecturer(s) et other(s) |
|---|---|---|---|
| S-INFO-049 |
|
| Language of instruction | Language of assessment | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Term |
|---|---|---|---|---|---|---|---|
| Français | Français | 30 | 15 | 0 | 0 | 0 | Q2 |
Content of Learning Activity
The course presents the basics theoretical aspects of database conception:
- Entity-relation diagram, conceptual model, logic model and physical model
- "Pure" query language: relational algebra, tuple relational calculus and domain relational calculus.
- The SQL query language.
- The normal form theory
- Indexing mechanisms
- Advanced functionalities (stored procedure, trigger, replication)
- Introduction to NoSQL systems
Exercises allow the students to become familiar with the concepts presented during the course.
Required Learning Resources/Tools
Not applicable
Recommended Learning Resources/Tools
Not applicable
Other Recommended Reading
R. Elmasri and Shamkant B. Navathe. Fundamentals Of Database Systems. 6th edition. Pearson Education.
Mode of delivery
- Face to face
Type of Teaching Activity/Activities
- Cours magistraux
- Travaux pratiques
- Travaux de laboratoire
- Exercices de création et recherche en atelier
- Etudes de cas
Evaluations
The assessment methods of the Learning Activity (AA) are specified in the course description of the corresponding Educational Component (UE)