Databases (06PODBDD)

• Coefficient : 1.5
• Hourly Volume: 21h (including 18h supervised)
  Labo : 18h supervised (and 3h unsupervised)

AATs Lists

Description

The programme is structured around four objectives:

1. to understand the mathematical concepts underlying the relational model
    - relational logic and calculus
    - relational algebra and query trees
2. master the SQL language to :
    - describe and structure data (DDL: Data Definition Language)
    - manipulate relational data (DML: Data Manipulation Language)
3. know how to formulate a query :
    - use relational calculation to represent all the information to be searched for
    - by sequencing the relational algebra operations to be implemented
    - by representing a query tree
    - by writing the corresponding SQL query
4. designing and structuring a database :
    - know how to represent a relational data model using the
    UML
    - master the DDL commands of the SQL language to structure a database
    database    

Learning Outcomes AAv (AAv)

• AAv1 [heures: 9, A1] : At the end of the BDR training, students know how to SPECIFY in a formal manner (relational calculation and algebra, query tree) a query corresponding to a search for information (expressed in French) on a known database.

• AAv2 [heures: 16, D1] : At the end of the BDR training, students know how to TRANSLATE into SQL language a search for information (expressed formally) on a known database regardless of the information present in the base.

• AAv3 [heures: 16, A1,C1] : At the end of the BDR training, based on needs expressed by a client, students know how to DESIGN in a structured way a relational database satisfying these needs. This design will be based on the formalisms seen in class (Entity-Association, UML).

• AAv4 [heures: 9, D1] : At the end of the BDR training, students are able to TRANSLATE a database model into SQL language and exploit it by executing queries corresponding to use cases expressed by a customer.

Assessment methods

Average of several short continuous assessment assessments from CTD (coefficient 1) and Lab (coefficient 1).

Key Words

relational algebra, UML modelling, relational DBMS, SQL language, SQLite, PostgreSQL

Prerequisites

Mathematical notions of logic and set theory

Resources

• ENIBOOK : http 😕/www.enib.fr/enibook/
• Georges Gardarin : http 😕/georges.gardarin.free.fr
• Claude Chrisment : ”Bases de données relationnelles” (Hermès 2008)
• Laurent Audibert : ”Bases de données : de la modélisation au SQL” (Ellipses 2009)
• Jean-Luc Hainaut : ”Bases de données : concepts, utilisation et développement” (Dunod 2018)