Business Data Modeling Workshop - BA32 ( 3 Days )
Price: $1800.00
Course Outline
Download Course Outline (PDF)
View Course Schedule
Abstract/Overview
This course teaches all the necessary skills to capture business data requirements in a formal Data Model. Students are guided through a gradual process from the conceptual, the logical, and the physical phases of data modeling. In addition to covering all the relevant concepts of data modeling in a non-tool specific context, this course also teaches the practical aspects of preparing and conducting data modeling sessions in a JAD-like environment. With the help of extensive progressive workshop exercises and a final case study students gain hands-on experience in building a Data Model.
Audience - Who Should Attend?
The course is intended for those who will be responsible for performing business analysis and documenting the results through the creation of a data model. This course can also be used to prepare individuals who will be participants in data modeling sessions, including end-users and Information Systems personnel.
Prerequisite
Although no data processing experience is necessary, an understanding of business requirements would be very useful.
Objective
- Learn a proven step-by-step process to create a rigorous, unambiguous data model.
- Understand the objectives of data modeling and how it is positioned within the system development life cycle.
- Be able to differentiate between the conceptual, logical, and physical phases of data modeling.
- Learn the fundamental components of the conceptual data model: entity types, relationships and attributes; and be able to construct an entity relationship diagram.
- Learn how to use constructs of the relational model to aid the development of a logical data model.
- Be able to use advanced constructs to enhance model semantics: entity type hierarchy, dependency, history, complex and recursive relationships.
- Learn how to construct solid and powerful definitions for entity types and attributes.
- Understand how data modeling relates to emerging new technologies including object orientation and data warehousing.
- Understand the process and basic techniques of the bottom-up approach to data modeling, including normalization up to fourth normal form.
- Learn how to plan, organize, and execute the data modeling project.
- Learn the basic techniques of model verification and confirmation.
Content
Introduction
- Information Systems Development and Business Requirements
- What is a Business Model?
- What is a Data Model?
Conceptual Modeling
- Entity Types
- Type vs. Instance, The Identifier
- Relationships
- Attributes
- The Associative Entity Type
- Subject Area
- The Modeling Process
Logical Modeling
- What is a Logical Model?
- Conceptual to Logical
- The Relational Model of Data
- Domain, Table
- Null Value, Candidate Key
- Primary Key, Foreign Key
- Building the Logical Model
- Modeling Entity Types
- Modeling Relationships
- Modeling Attributes
- Single-Valued vs. Multi-Valued
- The Refined Modeling Process
Definitions
- Purpose of Definitions
- Categories of Characteristics
- Parts of a Proper Definition
- The Definition Process
Advanced Modeling Concepts
- Entity Type Hierarchy
- Dependent Entity Type
- History
- Complex and Recursive Relationships
The Modeling Project
- Preparation
- Conducting Modeling Sessions
- Wrap Up, Documentation Bottom-Up Modeling
- User View Analysis
- Canonical Synthesis
- Normalization
- First, Second, Third Normal Forms
- Boyce-Codd, Fourth Normal Forms
Data Modeling and Emerging Technologies
- Object Orientation
- Data Modeling vs. OOA
- Transition from Data to Object Models
Data Warehousing
- Modeling for the Data Warehouse
- The Logical Model
- Developing De-normalized Views
- The Design Model
Model Verification
- Completeness, Correctness -Stability Analysis
Course Schedule
| Start Date | Location | Class Code | Duration (days) |
| Wed, Oct 13 2010 | Ottawa | P36129 | 3 |
| Mon, Dec 13 2010 | Toronto | P36125 | 3 |
| | | | |
top