 | Study programme 2020-2021 | 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 2020-2021 assessments (Covid-19) |
|---|
|
| Description of the modifications to the Q3 2020-2021 assessment procedures (Covid-19) |
| Exercices: SQL, RA, Tuple calculus, Domain calculus and MERISE Theory: Cahpters 1,3,6,7,8,(9) Questions by email - answers deposit on Moodle |
Organisational arrangements for the end of Q2 2020-2021 assessments (Covid-19) online or face-to-face (according to assessment schedule)
- Written exam (multiple choice, open questions)
Description of the modifications to the Q2 2020-2021 assessment procedures (Covid-19) online or face-to-face (according to assessment schedule)
Exercices: SQL, RA, Tuple calculus, Domain calculus and MERISE
Theory: Cahpters 1,3,6,7,8,(9)
Questions by email - answers deposit 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)