How to Model and Analyze Business System Data

1. General Introduction

• Requirements Definition
• The IT Project Landscape
• Will the Real Problem Please Stand Up!
• The Cost of Errors
• Requirements Activities
• Current and Future Situations
• Analysis of Business Systems Analysis
• Two Critical Success Factors of System Development
• What is an Integrated Business Solution?
• The Uncertainty Principle
• The Fate Chart
• A Question File
• A Problem with Language
• Things to Talk About . . .
• Categories and Types of Requirements
• Another Common Classification
• The Three C’s of Requirements Definition
• What to Expect from This Class

2. Defining Business Data

• The Data Foundation
• Data, Information and Knowledge
• Data Model Diagrams
• Data Model Diagrams Alternative Graphic Conventions
• Data Model Diagrams Additional Information
• Data Model Diagram for Project Resources
• Data Model Evolution
• Levels of Data Models
• Defining Entities
• Data Model Diagram for Education Department
• For Your Data Model
• An Employee Training Data Model
• Employee Training Attributes
• Simple Document for Invoicing System
• Data Model from a Form
• Identifying Entities
• Normalization — a Bottom Up Approach
• The Order Document for the Invoicing System
• Normalized Order
• Identifying Relationships from Normalization
• Relationships for an Order
• Normalize the Shipping Ticket
• The Shipping Ticket
• Normalization Helpful Hints
• On Merging Data Models
• Normalize an Invoice
• The Invoice
• Data Modeling — Two Approaches
• Completing the Invoicing System Data Model
• E/R (Entity-Relationship) Diagrams: A Summary

3. Creating a Data Model for the Future

• Creating a New System Data Model
• Changing a Data Model
• Quality Check
• Data Stability
• Modifying the Project Resources Data Model
• Previous Data Model for Project Resources
• Modifying Diagrams and Forms
• As-Is Data Model and Forms for the Invoicing System
• As-Is Forms for the Invoicing System
• Attributes: Inside an Entity
• Attribute Definition
• New System Data Model from Scratch
• Integrating Models (Conserving Data)
• Integrating Data Models
• Horizontal Balancing
• Data Design
• Sample Models
• Information Requirements
• User View Exercise
• Invoicing System Data Model
• Invoicing System Attributes
• Data Models vs. Databases
• Summary

4. Consider the Physical Data Model

• Constraining Factor
• Performance Factors (Trade-Offs)
• Design Trade-Offs
• Performance Factors: Access & Frequency
• Performance Factors
• Data Volumes

2 days

Business Analysts
Business Process Owners
Data Administrators
Data Analysts
Requirements Definition Specialists
System Analysts
Test Engineers
Anyone charged with managing, understanding and/or improving information use.

NONE

How to Gather, Analyze, and Define Business System Requirements

How to Model, Analyze, and Improve Business Processes

How to Manage Small Projects

Our instructors have extensive experience in applying these techniques on projects with business experts from a wide variety of fields.