 | 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-049 |
|
|
| Language of instruction | Language of assessment | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Term |
|---|---|---|---|---|---|---|---|
| Français | Français | 30 | 15 | 0 | 0 | 0 | Q2 |
| 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) |
| Chapters 2, 3 ,4 and 5: exercises Chapters 6, 7 and 8: theory Open course written examination with delivering of questions by mail. Exam access key will be available on Moodle. Students will upload their answers on Moodle. |
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 Big Data and 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)