Sarabjeet Singh Hanspal

Training and Consultation: Database Design, Data Modeling & Normalization

Intended Audience

This workshop is ideal for business analysts and application developers responsible for the analysis and design of any component of an application, including the database, application logic, or user interface. Business managers and professionals needing to understand how data modeling can be used to improve understanding, consistency and accuracy in business terminology, policy, and rules will also benefit.

On workshop completion, participants will be able to:

• Explain what a data model is, why they are so important, and where they fit

• Translate user requirements into appropriate entity-relationship model design structures

• Use both top-down and bottom-up approaches to get started creating a data model

• Follow steps to get to a normalized entity-relationship model

• Read a data model, and use it to communicate with both technical and non-technical audiences

• Review data models for "goodness" by being able to apply simple validation techniques

Course Outline

• Introduction to modeling: need, concepts, benefits and notations

• Three phases: Conceptual to Logical to Physical

• Applying refinement: what, when and why

• Getting modeling started

• Bottom-up or Top-down?

• Understanding Anomalies

• Normalization: UNF, 1NF, 2NF and 3NF

• Beyond 3NF

• Implementing Business Rules

• Handling Time-Dependent Data