Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect
Unfiled
This intensive three-day course provides students with the knowledge and skills to model business requirements in order to create a baseline database design. It focuses on the use of Object Role Modeling (ORM) and the ORM modeling tool in Microsoft Visual Studio .NET Enterprise Architect. Students will also learn the database modeling process and how ORM relates to Entity Relationship (ER) diagrams.
|
|
Program Outline
Module 1: Introduction to Modeling Business Requirements
This module provides an overview of the business requirements modeling process. It introduces students to Object Role Modeling (ORM) and the associated terminology.
Lessons
Lab A: Examining External Information
After completing this module students will be able to:
Module 2: Analyzing External Information and Creating a Conceptual Model—CSDP Step 1
This module explains how to transform familiar information examples into elementary facts and apply quality checks.
Lessons
Lab A: Analyzing External Information and Creating a Conceptual Model—CSDP Step 1
After completing this module students will be able to:
Module 3: Drawing a Conceptual Model and Entering Sample Data—CSDP Step 2
This module explains how to draw fact types and apply population checks.
Lessons
Lab A: Drawing Fact Types and Applying Population Checks
After completing this module students will be able to:
Module 4: Trimming the Conceptual Schemaf—CSDP Step 3
The following topics are covered in this module:
Lessons
Lab A: Implementing Primitive Entity Types and Derived Fact Types—CSDP Step 3
After completing this module students will be able to:
Module 5: Adding Uniqueness Constraints and Checking Arity of Fact Types—CSDP Step 4
This module explains how to add uniqueness constraints create nested object types and check the arity of facts.
Lessons
Lab A: Adding Uniqueness Constraints and Checking Arity of Fact Types
After completing this module students will be able to:
Module 6: Adding Mandatory Role Constraints and Checking for Logical Derivations—CSDP Step 5
This module explains how to add mandatory role constraints and check for logical derivations.
Lessons
Lab A: Adding Mandatory Role Constraints and Checking for Logical Derivations
After completing this module students will be able to:
Module 7: Adding Value and Set Constraints and Creating Entity Subtypes—CSDP Step 6
This module explains how to add value set comparison and sub-typing constraints.
Lessons
Lab A: Adding Value Constraints Set Constraints and Entity Subtypes
After completing this module students will be able to:
Module 8: Adding Frequency and Ring Constraints—CSDP Step 7
This module explains how to add other constraints and perform final checks.
Lessons
Lab A: Implementing Frequency and Ring Constraints
After completing this module students will be able to:
Module 9: Generating a Relational Logical Model
This module explains how to transfer a conceptual data model to a relational logical model.
Lessons
Lab A: Generating a Relational Logical Model
After completing this module students will be able to:
Module 10: Completing the Baseline Model
This module explains how to complete the baseline model by setting data types in the conceptual model and setting physical names in the relational logical so that the initial physical schema can be generated.
Lessons
Lab A: Completing the Baseline Model
After completing this module students will be able to:
Module 11: Generating and Reverse Engineering Physical Schema
This module explains how to transfer a data model to and from SQL Server.
Lessons
Lab A: Forward and Reverse Engineering Physical Schema
After completing this module students will be able to:
Additional Reading
To help you prepare for this class consider the following resources:
Related Exams
Student Pre-Requisites
Before attending this course students must have:
Student Materials
The student kit includes:
Program Goals
After completing this course students will be able to:
