FR
EN
Bases de donnéesMathématiques et Informatique 2 (GSI)
3ECTS (EU)
2Coefficient
26:40Hours
Séquencement
Learning objectives
- Understand the database concept.
- Understand a conceptual data model.
- Be able to write SQL queries. All these notions are tested under Access.
Program
- Introduction to database concepts. Definition of the logical architecture of a GBS: separate the description of the data from their processing. Approach of the 3 levels of data abstraction: external, conceptual and physical. Definition of the functionality required by a DBMS. These are designed to meet a number of objectives, such as: physical independence, consistency between the three levels of data abstraction, provision of non-procedural data manipulation language, provision of data administration tools, easy access to data, controlled management of data redundancy, consistency, sharing and security.
- Introduction to Codd's relational model, a database of two-dimensional table data modelling.
- SQL: Standard data manipulation language.
- The Conceptual Data Model: Basic Entity/Relationship Concepts. Definition of the constituent objects of an MCD, management rules. Definition of the translation rules of an Entity/Relationship model to a relational model.
Assessment
- Continuous control CM / TD / TP
References
- Georges Gardarin, Database, Eyrolles editions
- Céline Labbé, Modeling data, PRATIK editions, Comprendre collection
- Helma Spona, Access 2002, Micro Application, Grand Livre collection
Skills
8| Ref. | Verb | Description | Level |
|---|---|---|---|
| C2_2 | design | MCD | 1 |
| C2_2 | design | MLD | 1 |
| C2_2 | design | Request Relationship Algebra | 1 |
| C2_2 | design | SQL query | 1 |
| C2_2 | analyze | Request Relationship Algebra | 1 |
| C2_2 | analyze | MCD | 1 |
| C2_2 | analyze | MLD | 1 |
| C2_2 | analyze | SQL query | 1 |