Data Modeling Master Class

Data Modeling Master Class

This workshop uses a wide variety of practical design exercises, both individually and in groups for the experienced modeler. Participants can put the theories to work right away rather than waiting for the next opportunity in the workplace. Practical coverage of recent IT developments and the challenges and issues they present to data modellers and database designers.

Objectives:

As a result of attending this course, attendees will:

Understand how to establish deliverables
Differences between business information models versus database designs
Learn Use Cases
How to establish the meanings of names and definitions, object class hierarchy, the use of assertions
Know what makes a good data model
Have a set of quality criteria for comparing alternative data models
Know how to tackle some of the most common and difficult data modeling problems
Understand the limits of normalization, key selections, surrogate keys, overlapping foreign keys, derivable relationships, multi valued dependencies, 4th and 5th normal forms
Understand issues with aggregation. Generalization, generic models
Understand recursive structures, modeling of rules, event entities, time and time dependent entities
Understand attributes, classes, operators, units, attributes of relationships, and derived attributes
Learn representation and documentation of business rules, discovery and verification of business rules
Learn business information model to database design transformation
Learn how to handle Xml as it relates to modeling
Understand the contribution of the data modeler to meta-data

Duration 3 days

Who Should Attend
Systems analysts, system designers, business analysts, data analysts, database designers

Class Format Lecture, group discussions, exercises

Instructor Graham Witt