Modeling Business Requirements To Create a Database Using Ms Visual Studio .Net Enterprise Architect

Aliware
A Torino

840 
+IVA
Vuoi parlare del corso con un consulente?
Confronta questo corso con altri simili
Leggi tutto

Informazione importanti

  • Corso
  • Livello base
  • Torino
Descrizione

Obiettivo del corso: 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 E.
Rivolto a: This course will benefit those who need to understand the principles of database design in preparation for modeling, designing, developing, or administering Microsoft SQL Server databases.

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Consultare
Torino
Via Matteo Pescatore 15, 10124, Torino, Italia
Visualizza mappa

Programma

Course Syllabus

Modeling Business Requirements to Create a Database Using Microsoft® Visual Studio® .NET Enterprise Architect

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.

Audience

This course will benefit those who need to understand the principles of database design in preparation for modeling, designing, developing, or administering Microsoft SQL Server databases. It will also help those who are developing applications that access SQL Server data in an online transaction processing (OLTP) environment. Candidates should be familiar with databases and their uses.

Those taking this course should have the ability to:

· Describe what databases are and how they are used.

· Understand basic programming concepts.

· Understand the following relational database terms: o

Tables o

Columns o

Data integrity o

Data types

Some of the individuals that may benefit from this course are:

· Database designers

· Database implementers

· Database administrators

· Application developers (client, server, Web)

At Course Completion

After completing this course, students will be able to:

§ Analyze business requirements.

§ Create a conceptual database model using ORM.

§ Create a logical database model (ER diagram).

§ Validate the model against the external information.

§ Transfer the model into a SQL

Server database.

Prerequisites

Before attending this course, students must have:

§ The ability to describe what databases are and their uses.

§ The ability to understand basic concepts of querying databases.

§ The necessary skills to log on to and navigate in a Microsoft Windows® environment.

Student Materials


The student kit includes:

§ Student Workbook

§ Microsoft Visio 2002/2000

Viewer Web Component

§ Microsoft SQL Server 2000 Enterprise Edition

Evaluation Copy

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

§ Overview of Database ModelingProcess

§ Data Modeling Concepts

Lab A: Examining

External Information

§ Examining an Airline FlightsTheme

§ Examining an Academic Faculty

Theme

After completing this module, students will be able to:

§ Describe the process of modeling business requirements.

§ Summarize the process of modeling a baseline database model.

§ Summarize data modeling concepts.

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

§ Verbalizing Data Use Cases

§ Formalizing Fact Types

Lab A: Analyzing External Information and Creating a Conceptual Model-CSDP

Step 1

§ Verbalizing Fact Types

§ Entering Fact Types into the

Conceptual Model

After completing this module, students will be able to:

§ Complete CSDP step 1.

§ Verbalize data use cases.

§ Formalize fact types.

§ Create a conceptual model.

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

§ Drawing Fact Types

§ Applying a Population Check

§ Applying CSDP Step 2

Lab A: Drawing Fact

Types and Applying Population Checks

§ Drawing ORM Fact Types inVisio

§ Implementing a PopulationCheck

§ Validating the Model

After completing this module, students will be able to:

§ Apply CSDP step 2.

§ Draw fact types.

§ Apply population checks.

Module 4: Trimming the Conceptual Schema-CSDP Step 3

This module explains how to check for entity types that should be combined and to note arithmetically derived fact types.

Lessons

§ Implementing Primitive EntityTypes

§ Implementing Derived FactTypes

§ Applying CSDP Step 3

Lab A: Implementing

Primitive Entity Types and Derived Fact Types-CSDP Step 3

§ Identifying the ConceptualPartitioning Scheme

§ Implementing Primitive EntityTypes

§ Implementing Arithmetically Derived

Fact Types

After completing this module, students will be able to:

§ Check for entity types that should be combined and note any arithmetic derivations.

§ Implement primitive entity types.

§ Implement derived fact types.

§ Apply CSDP step 3.

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

§ Implementing UniquenessConstraints

§ Implementing Nested ObjectTypes

§ Checking Fact Arity

§ Applying CSDP Step 4

Lab A: Adding Uniqueness

Constraints, and Checking Arity of Fact Types

§ Implementing UniquenessConstraints

§ Checking the Arity of FactTypes

§ Splitting Fact Types

After completing this module, students will be able to:

§ Apply CSDP step 4.

§ Implement uniqueness constraints.

§ Implement nested object types.

§ Identify fact arity.

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

§ Implementing MandatoryConstraints

§ Implementing a Primary ReferenceScheme

§ Checking for LogicallyDerivable Fact Types

§ Applying CSDP Step 5

Lab A: Adding Mandatory

Role Constraints, and Checking for Logical Derivations

§ Implementing Mandatory RoleConstraints

§ Implementing PrimaryReference Schemes

§ Checking for LogicallyDerivable Fact TypesAfter completing this module, students will be able to:

§ Complete CSDP step 5.

§ Implement mandatory role constraints.

§ Implement a primary reference scheme.

§ Avoid modeling logically derivable fact types.

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

§ Implementing ValueConstraints

§ Implementing Set Constraints

§ Implementing Entity Subtypes

§ Applying CSDP Step 6

Lab A: Adding Value

Constraints, Set Constraints, and Entity Subtypes

§ Implementing Entity Subtype

§ Implementing Set Constraints

§ Implementing ValueConstraintsAfter completing this module, students will be able to:

§ Complete CSDP step 6.

§ Implement value constraints.

§ Implement set constraints.

§ Implement entity subtypes.

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

This module explains how to add other constraints and perform final checks.

Lessons

§ Implementing Frequency Constraints

§ Implementing Ring Constraints

§ Applying CSDP Step 7

Lab A: Implementing

Frequency and Ring Constraints

§ Implementing FrequencyConstraints

§ Implementing Ring ConstraintsAfter completing this module, students will be able to:

§ Complete CSDP step 7.

§ Implement frequency constraints.

§ Implement ring constraints.

Module 9: Generating a Relational Logical Model

This module explains how to transfer a conceptual data model to a relational logical model.

Lessons

§ Understanding RelationalLogical Models

§ Understanding Normalization

§ Generating a Relational

Logical Model

Lab A:

Generating a Relational Logical Model

§ Generating a Logical Model

After completing this module, students will be able to:

§ Generate a relational logical model.

§ Describe a relational logical model.

§ Describe normalization.

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

§ Refining Conceptual andLogical Models

§ Documenting Conceptual and

Logical Models

Lab A: Completing the

Baseline Model

§ Setting Physical Data Types

§ Setting Physical Names

§ Generating Reports

After completing this module, students will be able to:

§ Complete a baseline model.

§ Refine conceptual and logical models.

§ Document conceptual and logical models.

Module 11: Generating and Reverse Engineering Physical Schema

This module explains how to transfer a data model to and from SQL

Server.

Lessons

§ Forward Engineering

§ Reverse Engineering

Lab A: Forward and

Reverse Engineering Physical Schema

§ Generating a Database from aLogical Model

§ Updating an Existing Database

§ Reverse Engineering an

Existing Database

After completing this module, students will be able to:

§ Transfer a database model to and from SQL Server 2000.

§ Generate a database from a relational logical model.

§ Update a database from a modified relational logical model.

§ Reverse engineer a database into a relational logical model.

Additional

Reading

To help you prepare for this class, consider the following resources:

§ Information Modeling and Relational Databases, Terry Halpin, Morgan Kaufman Publishers, ISBN 1-55860-672-6.

§ Designing Relational Database Systems,

Rebecca M. Riordan, Microsoft Press.

Confronta questo corso con altri simili
Leggi tutto