Bases de Donnees (Databases)
TD/TP on relational databases: DBMS, SQL, normalization theory, conceptual modeling, and programmatic interfaces.
Term: Spring
Location: IMT Atlantique, Nantes
Course Overview
This course covers the fundamentals of relational database systems. Students learn to design, query, and manage databases through a combination of theory and hands-on practice (TD/TP).
Key Topics
- Relational model and data integrity constraints
- SQL queries, transactions, and security
- Normalization theory (functional dependencies, normal forms)
- Conceptual modeling with UML
- Programmatic interfaces for data persistence in applications
Target Audience
First-year engineering students (FISE 1A) at IMT Atlantique, semester S6.
Schedule
| Week | Date | Topic | Materials |
|---|---|---|---|
| 1 | Systemes de gestion de bases de donnees (DBMS) Introduction to DBMS, relational model, data integrity, and initial SQL practice. | ||
| 2 | Langage SQL Advanced SQL queries, transactions, security and access rights. | ||
| 3 | Theorie de la Normalisation Functional dependencies, normal forms, and relation decomposition. | ||
| 4 | Modelisation Conceptuelle Schema design with UML, derivation rules, and practical case studies. | ||
| 5 | Interfaces programmatiques Managing data persistence in object-oriented applications. |