Description

The implementation of data in an IS project is a determining factor in quality and performance. This course presents the methods to effectively model your data at all stages of a project: discovery, understanding and design of data, implementation of the bases.

Who is this training for ?

For whom ?

Anyone involved in an IT project: project management, analysts and designers, data and database administrators.

Prerequisites

Training objectives

Develop and describe the system data

Develop a UML class diagram from a dictionary

Check the normality of a model

Understand how to move from a semantic model to a logical model

Training program

• Introduction
  • The role of data in IS.
  • Panorama of modeling techniques and methods.
• Data Dictionary
  • Research data.
  • Sources: study of existing applications, management documents, strategic choices of the company.
  • Description of data: rules naming, definition rules.
  • Back-documentation.
  • Practical work Development of a data dictionary.
• Semantic data modeling
  • How to define data independently of the logical and physical infrastructure? The levels of data modeling: specifications level; detailed specifications level.
  • Address this issue with UML .
  • The UML class diagram.
  • Classes, attributes, objects, associations, constraints.
  • How to deal with the same problem with another formalism? entity-association.
  • Standardization.
  • How do normal forms contribute to understanding data? The role of data in the description of business processes and management processes .
  • Involve users in data modeling.
  • Validation.
  • Approach data in the context of validating detailed specifications.
  • Practical work Develop a UML class diagram from a dictionary.
  • Transform the created model into an entity-association model.
  • Check normality previous models.
  • Case study Analyze the place of data in specifications.
• Logical Data Modeling
  • The stages of transforming models.
  • The rules for moving from a semantic (conceptual) model to a logical model.
  • The transition from a model logic towards the physical model, optimization work.
  • Participation of the MOA in optimization work.
  • Practical work Transform a model into a logical model.
• Modeling tools
  • Presentation of a UML tool (StarUML and/or PowerAMC).
  • Presentation of an entity-association tool (PowerAMC ​​" MCD version ").