2090 Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect Training Class

Lesson 1: Introduction to Modeling Business Requirements

Overview of Database Modeling Process
Data Modeling Concepts

Lesson 2: Analyzing External Information and Creating a Conceptual Model-CSDP Step 1

Verbalizing Data Use Cases
Formalizing Fact Types

Lesson 3: Drawing a Conceptual Model and Entering Sample Data-CSDP Step 2

Drawing Fact Types
Applying a Population Check
Applying CSDP Step 2

Lesson 4: Trimming the Conceptual Schema-CSDP Step 3

Implementing Primitive Entity Types
Implementing Derived Fact Types
Applying CSDP Step 3

Lesson 5: Adding Uniqueness Constraints and Checking Arity of Fact Types-CSDP Step 4

Implementing Uniqueness Constraints
Implementing Nested Object Types
Checking Fact Arity
Applying CSDP Step 4

Lesson 6: Adding Mandatory Role Constraints and Checking for Logical Derivations-CSDP Step 5

Implementing Mandatory Constraints
Implementing a Primary Reference Scheme
Checking for Logically Derivable Fact Types
Applying CSDP Step 5

Lesson 7: Adding Value and Set Constraints, and Creating Entity Subtypes-CSDP Step 6

Implementing Value Constraints
Implementing Set ConstraintsImplementing Entity SubtypesApplying CSDP Step 6

Lesson 8: Adding Frequency and Ring Constraints-CSDP Step 7

Implementing Frequency Constraints
Implementing Ring Constraints
Applying CSDP Step 7

Lesson 9: Generating a Relational Logical Model

Understanding Relational Logical Models
Understanding Normalization
Generating a Relational Logical Model

Lesson 10: Completing the Baseline Model

Refining Conceptual and Logical Models
Documenting Conceptual and Logical Models

Lesson 11: Generating and Reverse Engineering Physical Schema

Forward Engineering
Reverse Engineering