Bases de donnéesOutils de l'Ingénieur S5 (GSI)

• Understand the database concept.
• Understand a conceptual data model.
• Be able to write SQL queries. All these notions are tested under Access.

• 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, logical between the 3 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.

Continuous control CM / TD / TP

• Georges Gardarin, Database, Eyrolle editions
• Céline Labbé, Modeling data, PRATIK editions, Comprendre collection
• H elma Spona, Access 2002, Micro Application, Grand Livre collection