CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2090 - Modeling to Create a Database Using MS Visual Studio .NET

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This 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.

Click here for a printer-friendly version of this page

Prerequisites

Ability to describe what databases are and their uses, basic concepts of querying databases and skills to log on to and navigate in a Microsoft Windows environment

Detailed Class Syllabus

Introduction to Modeling Business Requirements

Overview of Database Modeling Process

Data Modeling Concepts

What a Database Model Represents

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

Verbalizing Data Use Cases

Formalizing Fact Types

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

Draw Fact Types

Perform Population Check

Apply CSDP Step 2

Trimming the Conceptual Schema-CSDP Step 3

Implementing Primitive Entity Types

Implementing Derived Fact Types

Applying CSDP Step 3

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

Implementing Uniqueness Constraints

Checking Fact Arity

Applying CSDP Step 4

Implementing Nested Object Types

Adding Mandatory Role Constraints and Checking For Logical Derivations-CSDP

Implementing Mandatory Constraints

Implementing a Primary Reference Scheme

Checking for Logically Derivable Fact Types

Applying CSDP Step 5

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

Implementing Value Constraints

Implementing Set Constraints

Implementing Entity Subtype

Applying CSDP Step 6

Adding Frequency and Ring Constraints-CSDP Step 7

Implementing Frequency Constraints

Implementing ring Constraints

Applying CSDP Step 7

Generating a Relational Logical Model

Understanding Relational Logical Models

Understanding Normalization

Generating a Relational Logical Model

Completing the Baseline Model

Refining Conceptual and Logical Models

Documenting Conceptual and Logical Models

Generating and Reverse Engineering Physical Schema

Forward Engineering

Reverse Engineering