> Empowering Your
   Project Teams through
   Dynamic Education

> Project Management
   Courses

> PMP Certification

> Program Management 
   Courses

< Technology Management 
   Courses

> Course Authors and 
   Instructors

> Please contact us for details
   on scheduling and costs.

Data and Information Modeling

Intended Audience

This course is designed for Data Modelers, Systems/Business Analysts, and Project Managers who develop system requirements and model the business rules of the enterprise. Even those with experience in developing system requirements will appreciate the rigorous methodology of this course and the assurance that system requirements have conceptual integrity before the system is built.

Course Description

The course focuses on the basics as well as the sophisticated techniques in data modeling. The life cycle of the data model is reviewed from basic to keyed to fully-attributed. The differences between the conceptual data model and the logical data model are fully explored. Hands-on exercises highlight the need for the application of rigorous rules such as refinement, normalization and the rule of foreign keys.

Learning Outcomes

Through mini lectures and hands-on teamwork, the course seeks to develop good data and information modeling skills, focusing on techniques for discovering and validating requirements. Practical instruction is given on how to—

• Identify data entities

• Understand the specific types of data entities and their purpose

• Model data requirements and business rules

• Identify candidate keys and select the most appropriate key

• Identify foreign keys and associative entities

• Use attributive entities

• Refine and normalize a data model