Course OutlineModule 1: Introduction to Modeling Business RequirementsThis 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 Modeling Process
- Data Modeling Concepts
Module 2: Analyzing External Information and Creating a Conceptual Model—CSDP Step 1This module explains how to transform familiar information examples into elementary facts and apply quality checks.Lessons - Verbalizing Data Use Cases
- Formalizing Fact Types
Lab : 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: Module 3: Drawing a Conceptual Model and Entering Sample Data—CSDP Step 2This module explains how to draw fact types and apply population checks.Lessons - Drawing Fact Types
- Applying a Population Check
- Applying CSDP Step 2
Lab : Drawing Fact Types and Applying Population Checks- Drawing ORM Fact Types in Visio
- Implementing a Population Check
- 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 Schemaf—CSDP Step 3Lessons - Implementing Primitive Entity Types
- Implementing Derived Fact Types
- Applying CSDP Step 3
Lab : Implementing Primitive Entity Types and Derived Fact Types—CSDP Step 3- Identifying the Conceptual Partitioning Scheme
- Implementing Primitive Entity Types
- 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 4This module explains how to add uniqueness constraints, create nested object types, and check the arity of facts.Lessons - Implementing Uniqueness Constraints
- Implementing Nested Object Types
- Checking Fact Arity
- Applying CSDP Step 4
Lab : Adding Uniqueness Constraints, and Checking Arity of Fact Types- Implementing Uniqueness Constraints
- Checking the Arity of Fact Types
- Splitting Fact Types
After completing this module, students will be able to: Module 6: Adding Mandatory Role Constraints and Checking for Logical Derivations—CSDP Step 5This module explains how to add mandatory role constraints and check for logical derivations.Lessons - Implementing Mandatory Constraints
- Implementing a Primary Reference Scheme
- Checking for Logically Derivable Fact Types
- Applying CSDP Step 5
Lab : Adding Mandatory Role Constraints, and Checking for Logical Derivations- Implementing Mandatory Role Constraints
- Implementing Primary Reference Schemes
- Checking for Logically Derivable Fact Types
After 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 6This module explains how to add value, set comparison, and sub-typing constraints.Lessons - Implementing Value Constraints
- Implementing Set Constraints
- Implementing Entity Subtypes
- Applying CSDP Step 6
Lab : Adding Value Constraints, Set Constraints, and Entity Subtypes- Implementing Entity Subtype
- Implementing Set Constraints
- Implementing Value Constraints
After 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 7This module explains how to add other constraints and perform final checks.Lessons - Implementing Frequency Constraints
- Implementing Ring Constraints
- Applying CSDP Step 7
Lab : Implementing Frequency and Ring Constraints- Implementing Frequency Constraints
- Implementing Ring Constraints
After completing this module, students will be able to: Module 9: Generating a Relational Logical ModelThis module explains how to transfer a conceptual data model to a relational logical model.Lessons - Understanding Relational Logical Models
- Understanding Normalization
- Generating a Relational Logical Model
Lab : Generating a Relational Logical Model- Generating a Logical Model
After completing this module, students will be able to: Module 10: Completing the Baseline ModelThis 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 and Logical Models
- Documenting Conceptual and Logical Models
Lab : 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 SchemaThis module explains how to transfer a data model to and from SQL Server.Lessons - Forward Engineering
- Reverse Engineering
Lab : Forward and Reverse Engineering Physical Schema- Generating a Database from a Logical 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.
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.
|
| |
