The implementation of data in an IS project is critical to 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 databases.
Training at your location, our location or remotely
Ref. MDO
2d - 14h
Would you like to transpose this course—without changes—for your company?
A la carte training
Do you want a training course tailored to the needs of your company and its teams? Your training will be built to measure by our experts!
The implementation of data in an IS project is critical to 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 databases.
Teaching objectives
At the end of the training, the participant will be able to:
Develop and describe 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
Intended audience
Anyone involved in an IT project: Project managers, analysts and designers, data and database administrators.
Prerequisites
No particular knowledge.
Course schedule
Introduction
The role of data in the IS.
Overview of modeling techniques and methods.
Data Dictionary
Data search.
Sources: Review of existing applications, management documents, strategic choices of the company.
Data description: Naming rules, definition rules. Documenting existing systems.
Hands-on work
Writing a data dictionary.
Semantic data modeling
How to define data independently of the logical and physical infrastructure.
Data modeling levels: Specification level; design specification level.
Approaching this problem with UML. The UML class diagram. Classes, attributes, objects, associations, constraints.
How can the same problem be handled with another formalism? The entity-relationship diagram.
Standardization. How do normal forms help to understand the data?
The role of data in the description of business and oversight processes.
Get users involved in data modeling. Validation.
Addressing data in the context of detailed specification validation.
Hands-on work
Develop a UML class diagram from a dictionary Transform the created model into an entity-relationship model. Check the normality of the previous models.
Logical data modeling
The stages of model transformation.
The rules for moving from a semantic (conceptual) model to a logical model.
The passage from a logical model to the physical model, the optimization work.
Project manager’s participation in the optimization work.
Hands-on work
Turning a model into a logic model.
Modeling tools
Presentation of a UML tool (StarUML and/or PowerAMC).
Presentation of an entity-relationship tool (PowerDesigner "MCD version").
Customer reviews
4 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
No session at the moment, we invite you to consult the schedule of distance classes.