General Engineering Program
| General Data | ||||
|---|---|---|---|---|
| Academic program | General Engineering Program | Module Manager(s) :
GAGNEUX Antoine |
||
| EC Type : Lectures | Database (LIIAem06EBaseDon) | |||
|
Tutorials : 2h00 Lab Work : 4h00 Lectures : 2h00 Individual work : 8h00 Total duration: 8 |
Status
|
Period
Semester 6 |
Teaching language :
French |
|
| General objectives |
|---|
| Introduction to modeling and querying databases. - Modeling a simple database with UML (class diagram) - Reading and understanding a database model - Querying a database with SQL |
| Content |
|---|
| The CDM (conceptual data model) will be approached using the UML class diagram and the MLD (logical data model) with the relational model. Labwork involves using databases with the SQL language. |
| Corequis |
|---|
| UML, class diagram |
| Bibliographie |
|---|
| Bases de données de la modélisation au SQL, Laurent Audibert, 2009, Edition Eclipse, 256p. |
| Assessment(s) | |||
|---|---|---|---|
| N° | Nature | Coefficient | Observable objectives |
| 1 | 1 | Practical work | |