Our Workshops
Data Modelling
Description
1-Day Workshop
What is Data Modeling?
Explore data modeling methodologies with the goal of understanding how to choose, apply, and interpret appropriate statistical designs and analyses for practical data problems.
How do business managers and their staff find data and information they need for decision-making?
- Ask the end-users of the data. But who are they?
- And what if the data exists in different versions? Which version is correct?
A data model is the "Corporate Street Directory". It includes data maps and data details in a repository. It is comparable to the city map and details of streets. A data model, therefore:
- Depends on business rules and business conditions
- Depends on the time requirements, and performance
- Depends on the technology used
A data model should be based on an organisation's strategic, tactical and operational business plans, if information systems are to be built that are aligned with the corporate goals.
Most organisations have not, until recently, recognised the importance of data models - which are as vital to the construction of an information system as an architect's plans are for the construction of a house or a skyscraper.
A data model is an essential prerequisite for development of application databases, data warehouses, for internet/intranet systems and for business transformation to take advantage of the Internet and corporate Intranet technologies.
On completion of this workshop the learner will
- Have completed exercises which will guide them through the process of data modelling.
- Have thought critically about the data requirements and processes of a scenario used in class.
- Know the three phases of data modelling and their outcomes.
- Have set up Conceptual and Logical models describing the data in the scenario used in class.
- Understand the notation of different Entity-Relationship diagrams.
- Understand Relational Database Management systems.
- Understand and applied Data Normalisation to the data in the scenario.
Workshop Outline
The Data Modelling Process
Potential shortcomings of the model produced
Considerations during the data modelling process
The Scenario:
Describe the Information for the Conceptual model
Defining the Business Rules
Three Schemas
Conceptual Schema
Modelling approaches
Activity Diagrams
Sample Activity/Workflow Diagram
Activity Diagrams
Concept Mapping
Construct a Concept Map
Add Business Rules
Data Dictionary
Data Dictionary
Logical Schema
Data Modelling Notations
Entity-Relationship Model (Chen)
Entity-Relationship Model (Barker/Crow’s Foot)
Foot notation
Entity-Relationship Model (IDEF1X)
IDEF1X Entity Relationship Matrix
Relational Database Management System RDBMS
Relations or Tables (Entity)
Table Structure
Keys and Constraints
Construct Tables (Entities)
Database Normalisation
Modification Side Effects (Anomalies) addressed by Normalisation
Other optimisation delivered through Normalisation
Normal Forms
________________________________________________________________________________________________________________________________________________________________
On-Site Workshops
- All workshops are offered in-house at your offices to a minimum of 5 delegates
- You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions
Remote Workshops
- All workshops are offered remotely to a minimum of 5 delegates
- Front Foot supply all the electronic workshop material
__________________________________________________________________________________________________________________________________________________________________