Data Modeling for Business Analysts
Course Length: 2 days
DESCRIPTION
This course is an introduction to data modeling principles and processes. This course assists in taking requirements and translating them into data requirements by using graphical data modeling notation. This course explains how to normalize data and handle complex relationships between data concepts (classes/entities). This course will provide a practical approach for analyzing and modeling data requirements making them ready to be transformed into a relational database.
TARGET AUDIENCE
Business Analysts or other team members who need to understand how to read, modify, create data diagrams and models for development and database teams.
PREREQUISITES
None
COURSE OUTLINE
COURSE TOPICS
- The world of Business Modelling
- Uses of data models
- Definition of conceptual, logical and physical Data Modeling
- Benefits of data modeling
- Approaches to data modeling
- Understanding data entities – Validation of data entities
- Entities versus attributes
- Naming conventions for attributes
- Symbols used for modeling attributes
- Understanding data relationships and cardinality: one to one, one to many, many to many, ranges
- Resolving many to many relationships – simplification
- Optional versus mandatory relationships
- Application of primary keys, foreign keys
- Referential integrity
- Symbols used to document relationships
- Walking users through the Entity Relationship or Class diagram
- Define data normalization and why it’s used
- Understanding normalization levels and their applications
- Understanding de-normalization and its applications
- Moving from a logical data model to a physical data model
- CASE Tools