Introduction to Information and Data Modelling

Data is today's gold, so data modelling is an important skill to be able to handle data well.

This course provides a comprehensive introduction to data modeling techniques using Unified Modeling Language (UML) Class Diagrams, the Entity Relational (ER) model and phyiscal (relationsl) data models to create conceptual data models, logical data models down to physical data models.

Participants will learn the fundamentals of designing and representing data structures  and how to translate these conceptual designs into practical relational database schemas amd keep the trace for data lineage.

The course covers key concepts, techniques, and best practices essential for effective data modeling in various software development projects using Enterprise Architect from SparxSystems.

Enterprise Architect allows you to capture conceptual, logical and physical data models with one tool in the same model repository. You can import schemas from existing databases or automatically generate database scripts from your modelled schema, providing end-to-end traceability from concept to implementation.

With the help of Model Driven Architecture (MDA) transformations, EA provides the possibility to transform a Platform-Independent Model (PIM) into a Platform-Specific Model (PSM).  In the context of information and data models, MDA can be used to translate a logical data model into a physical data model. Furthermore, it is also possible to convert physical data models into a logical data model.

What you will learn:

  • Use UML::Class Models to create logical datamodels (LDM)
    • UML Classes, Attributes, Associations, DataTypes
  • Use EA's physical Data Model language (PDM)
    • Tables, Columns, primary keys, foreign keys
  • Use EA's Model Driven Archtiecture (MDA) implementation to automatically generate a physical Data Model from a logical UML Class Diagram
    • Using the DDL Transformation
  • Using the Entity Relationship (ER) Model in EA as a logical Data Model
  • LDM 2 PDM: Use EA's Model Driven Archtiecture (MDA) implementation to automatically generate a physical Data Model from a logical Entity Relationship Model
  • PDM 2 LDM: Use EA's Model Driven Archtiecture (MDA) implementation to automatically generate a logical Entity Relationship Model from a physical Data Model
  • Generate DDL Scripts
  • Import a physical Data Model via ODBC Connection
  • Use EA's Database Builder Tool (alternate approach to create, maintain, forward and reverse engineer physical data models)
    • Basic handling like: Tables, Columns, PK, FK, etc.
    • DB round trip engineering