IP4600 - SGBD

IP4600 - SGBD

Objectives

General objective:

1 - Design of Relational Databases,
2 - Write SQL queries, in order to create MySQL databases, and to select/modify data.

Detailed objectives:

1 - The students should be able to design relational databases
- Map UML Class Diagrams into Relational Schema
- Check if the relational schema is normalized to the third normal form.
2 - 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).

Hours

  • Lectures : 8
This course is part of the programme

In brief

ECTS credits : cf Teaching Unit

Number of hours 8

Teaching language
Anglais

Contact(s)

Jean-Baptiste GOTTELAND

Phone : +33 5 62 25 95 84

Email : jean-baptiste.gotteland @ enac.fr

Assia HACHICHI

Email : assia.hachichi @ enac.fr