Overview 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.
Pre-Requisites
Before attending this cl
Next Course Dates
Dates available on request. Please contact us
More Information
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:
- Tables
- Columns
- Data integrity
- Data types
Some of the individuals that may benefit from this course are:
- Database designers
- Database implementers
- Database administrators
- Application developers (client, server, Web)
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.
- Module 1: Introduction to Modeling Business Requirements
- Module 2: Analyzing External Information and Creating a Conceptual Model—CSDP Step 1
- Module 3: Drawing a Conceptual Model and Entering Sample Data—CSDP Step 2
- Module 4: Trimming the Conceptual Schemaf—CSDP Step 3
- Module 5: Adding Uniqueness Constraints and Checking Arity of Fact Types—CSDP Step 4
- Module 6: Adding Mandatory Role Constraints and Checking for Logical Derivations—CSDP Step 5
- Module 7: Adding Value and Set Constraints, and Creating Entity Subtypes—CSDP Step 6
- Module 8: Adding Frequency and Ring Constraints—CSDP Step 7
- Module 9: Generating a Relational Logical Model
- Module 10: Completing the Baseline Model
- Module 11: Generating and Reverse Engineering Physical Schema