IP4600E - SGBD
Objectifs
Objectif général :
1 - Design UML class diagrams
2 - Map UML class diagrams int Relational schemas=,
3 - Write SQL queries, in order to create MySQL databases, and to select/modify data.
Objectifs détaillés :
1 - The students sould be able to design UML class diagrams form specifications given in the natural language.
2 - The students should be able to design relational schemas
- Map UML Class Diagrams into Relational Schema
- Check if the relational schema is normalized to the third normal form.
3 - The students should be able to write (express) SQL queries :
- Create a MySQL databases
- Write select queries,
- Create and delete tables,
- Insert/modify/delete records (data),
- Use mathematical functions,
- Create views (virtual tables).
Volume horaire (h)
- Cours Magistraux : 10h
- Travaux Dirigés : 2h
En bref
Crédits ECTS : Cf UE
Nombre d'heures 12
Contact(s)
Lieu(x)
- Toulouse