Data Modelling using Enterprise Architect     

Code:

 IS550-300

Series:

 Information Management

Duration:

 3 days

Data as a Resource
Managing Enterprise Resources
Planning, Monitoring & Controlling
Managing by Direct Observation
Information & Resource Management
Information as a Substitute for Direct Observation
Information vs Data
Information vs Technology
The Data Resource
Data as an Abstraction of the Real World
The Role of Metadata & Data Administration
Introduction to Data Modelling

Data Modelling Concepts
Entities
Classification
Abstraction
Reification
Entities & Attributes
Entities & Database Tables
Rows & Columns
Primary Keys
Identifying Entities
Concrete things
Roles of People & Organisations
Events & Periods of Time
Transactions, Agreements & Interactions
What to look for
Where to look
What to challenge
Relationships
Binary relationships & Entity Association
Representing "facts" with Relationships
Cardinality of Relationships
Optional & Mandatory Relationships
Relationships, Database Tables & Foreign Keys

Representing Facts
Relationships between differnet Entities
One-to-One Relationships
One-to-Many Relationships
Many-to-Many Relationships
Redundant Relationships
Effect of Time
Entity Definitions & Relationships
Simplifying one-to-one Relationships
Expanding Many-to-Many Relationships
Multiple Relationships
Recursive Relationships
Recursive one-to-one Relationships
Recursive one-to-many Relationships
Recursive many-to-many Relationships
Expanding Recursive many-to-many Relationships

Describing Roles & Types
Modelling Roles correctly
Modelling Types correctly
Generalise & Specialise
Entity Sub-types
Inference & Inheritance
Entity Sub-types & Database Tables

Data Dictionary
Entity Definitions
Selecting Entity Names
Constructing a Glossary of Entity descriptions
Attribute Definitions
Data Types
Lists of Values
Adding Attribute Descriptions to the Glossary

Data Analysis
Data Modelling vs Data Analysis
Relational Database concepts
Functional Dependency
Diagramming Attributes
Functional Dependencies between Attributes
Dependency Diagrams
Grouping Attributes into Tables
Representing Repeating Groups
Identifying Partial Dependencies
Identifying Transitive Dependencies
Resolving Many-to-Many Associations between Attributes
Synthesising Dependency Diagrams into a Database Design

Third Normal Form
Objectives of Normalisation
Redundancy & Insert, Update, Delete Anomalies
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Grouping into Tables

Data Modelling using Enterprise Architect


After completing this course, participants will be able to:

  • understand and describe the fundamental concepts on which data modelling is based and the techniques and sequence used in deriving a data model.
  • perform a data modelling process from initiation through to the mapping of a physical database design.
  • take a corporate, rather than a system-specific view of the organisation’s data resource.

Prerequisites:


Assumes no prior knowledge of data modelling concepts and techniques.  Some familiarity with business data and business systems is useful.