data analysis and database design

Delegates will learn
  • How to develop the entity model
  • How to handle involuted relationships
  • How to handle entity sub-typing
  • How to carry out normalisation (TNF)
  • How to manage TNF to entity model conversion
  • How to go about further normalisation (BCNF, 4NF)
  • How to carry out access path analysis
  • How to construct the entity life history model
Target Audience
  • Business Analysts
  • Data analysts
  • Database designers
Style

This is an intensive 3-day non-residential course aimed at anyone involved in developing database systems.  This highly practical course ensures delegates can successfully apply a data driven approach through a project life cycle. Delegates will gain the ability to construct a logical data model to support functional requirements. The course also provides a basis for technical design by verifying functional models with logical data models.  This is a useful precursor to any database management technical course.

Topics
  • Why data analysis is important
  • Business drivers
  • Data as a corporate asset
  • Data Modeling by inspection
  • Defining Entities
  • Entity Relationships
  • Optionality & Cardinality
  • Entity Modeling
  • Defining Attributes
  • Validating the Entity Model
  • Normalisation
  • Building an Entity Model from the TNF structures
  • Merging the TNF Entity Model with the Inspection Model
  • Advanced techniques (4th & 5th Normal Form, Boyce-Codd Normal Form)
  • Access Path Analysis
  • Referential Integrity
  • Entity Life Histories
  • Physical Database Design