M2090 – Modeling Business to Create a Database Using Microsoft VS .NET Enterprise Architect Visual Studio
Enquire/Book this course

Trained over 60000 delegates

Course delivered by industry expert instructors

Highly competitive pricing
Those taking this course should have the ability to:
- Describe what databases are and how they are used.
- Understand basic programming concepts.
- Tables
- Columns
- Data integrity
- Data types
- Database designers
- Database implementers
- Database administrators
- Application developers (client, server, Web)
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.
- 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.
Course Content
- Overview of Database Modeling Process
- Data Modeling Concepts
- Verbalizing Data Use Cases
- Formalizing Fact Types
- Verbalizing Fact Types
- Entering Fact Types into the Conceptual Model
- Complete CSDP step 1.
- Verbalize data use cases.
- Formalize fact types.
- Create a conceptual model.
- Drawing Fact Types
- Applying a Population Check
- Applying CSDP Step 2
- Drawing ORM Fact Types in Visio
- Implementing a Population Check
- Validating the Model
- Apply CSDP step 2.
- Draw fact types.
- Apply population checks.
- Implementing Primitive Entity Types
- Implementing Derived Fact Types
- Applying CSDP Step 3
- Identifying the Conceptual Partitioning Scheme
- Implementing Primitive Entity Types
- Implementing Arithmetically Derived Fact Types
- 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.
- Implementing Uniqueness Constraints
- Implementing Nested Object Types
- Checking Fact Arity
- Applying CSDP Step 4
- Implementing Uniqueness Constraints
- Checking the Arity of Fact Types
- Splitting Fact Types
- Apply CSDP step 4.
- Implement uniqueness constraints.
- Implement nested object types.
- Identify fact arity.
- Implementing Mandatory Constraints
- Implementing a Primary Reference Scheme
- Checking for Logically Derivable Fact Types
- Applying CSDP Step 5
- Implementing Mandatory Role Constraints
- Implementing Primary Reference Schemes
- Checking for Logically Derivable Fact Types
- Complete CSDP step 5.
- Implement mandatory role constraints.
- Implement a primary reference scheme.
- Avoid modeling logically derivable fact types.
- Implementing Value Constraints
- Implementing Set Constraints
- Implementing Entity Subtypes
- Applying CSDP Step 6
- Implementing Entity Subtype
- Implementing Set Constraints
- Implementing Value Constraints
- Complete CSDP step 6.
- Implement value constraints.
- Implement set constraints.
- Implement entity subtypes.
- Implementing Frequency Constraints
- Implementing Ring Constraints
- Applying CSDP Step 7
- Implementing Frequency Constraints
- Implementing Ring Constraints
- Complete CSDP step 7.
- Implement frequency constraints.
- Implement ring constraints.
- Understanding Relational Logical Models
- Understanding Normalization
- Generating a Relational Logical Model
- Generating a Logical Model
- Generate a relational logical model.
- Describe a relational logical model.
- Describe normalization.
- Refining Conceptual and Logical Models
- Documenting Conceptual and Logical Models
- Setting Physical Data Types
- Setting Physical Names
- Generating Reports
- Complete a baseline model.
- Refine conceptual and logical models.
- Document conceptual and logical models.
- Forward Engineering
- Reverse Engineering
- Generating a Database from a Logical Model
- Updating an Existing Database
- Reverse Engineering an Existing Database
- 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.
- Information Modeling and Relational Databases, Terry Halpin, Morgan Kaufman Publishers, ISBN 1-55860-672-6.
- Designing Relational Database Systems, Rebecca M. Riordan, Microsoft Press.