Byron Employment

Byron Employment. Over 71,725 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $1950.00

Course Overview

2090 Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise 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.

Learning Method

Instructor Lead

Schedule

Group bookings only

Duration

3 Days

Prerequisites

  • This course requires a basic understanding of databases and their underlying purpose.
  • Use the Windows user interface

Course Outline

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

     

Lunch

Lunch is provided for students for the duration of the course

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 8263 5906
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 8263 5906 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search