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 | 0 | 15 | 0 | 0 | Q2 |
Contents
The course presents the basics theoretical aspects of database conception:
- Entity-relation diagram and relational model.
- "Pure" query language: relational algebra, tuple relational calculus and domain relational calculus.
- The SQL query language.
- The normal form theory (1-4 normal form, Byce-Codd normal form).
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
Term 1 Assessment - type
- N/A
Term 1 Assessment - comments
Not applicable
Term 2 Assessment - type
- Written examination
Term 2 Assessment - comments
100% written examination.
Term 3 Assessment - type
- Written examination
Term 3 Assessment - comments
100% written examination.
Resit Assessment - Term 1 (B1BA1) - Comments
Not applicable
Type of Teaching Activity/Activities
- Cours (cours magistraux; conférences)
- Préparations, travaux, recherches d'information