Focus on Business Analysis: Professional Data Modeling
(SBDMD, Live Instructor-Led Training, 2 days)


Dates and Pricing


Jan 15 to Jan 16, 2018$1,150/person Feb 12 to Feb 13, 2018$1,150/person Mar 12 to Mar 13, 2018$1,150/person

Outline

Object Oriented Analysis and Design
Understanding the Role of the Business Use Case
Performing Object Identification
Eliminating Objects: Identifying Antonyms and Antonyms
Creating a Candidate List with Definitions
Identifying Primary Object Associations
Drafting a Domain Model
Exploring Relational Data
The Relationship between an Object and an Entity
The Relationship between a Property and a Field
When a Property becomes a Table
When an association becomes a Table
The Importance of Normal Form
What 1st Normal Form Provides
What 2nd Normal Form Provides
What 3rd Normal Form Provides
What Boyce-Codd Normal Form Provides
The Cost of Failing to Normalize
The Benefits of Denormalization
Exploring Relational Database Constructs
About Tables, Fields, Keys and Indexes
Ensuring Entity Integrity with Primary Keys
Ensuring Referential Integrity with Foreign Keys
Ensuring Domain Integrity with Constraints
Exploring the Role of Indexes
Moving from Analysis to Design
The Basics of ER Diagrams
Moving from an Object to an Entity
Adding Entity Relationships
Adding Entity Attributes
Adding Relationship Attributes
Specifying Data Types
Finalizing the Mode with Quality Checks
Generating the Model for a Specific RDBMS