Course Duration: 2 Days

Course Category: Business Analysis & Requirements Engineering

 

14 Contact Hours

Data Modelling

   
Course Overview
The production of information is the sole purpose of commercial computing. The data from which their information is derived is undoubtedly an extremely valuable resource for any enterprise.It is therefore not surprising that efficient organisation of that data will produce significant and lasting corporate benefits.

Despite this, applications development for many years focussed more on the functionality of information systems and gave insufficient attention to the structuring of the ever-expanding databases.This attention has shifted in recent times, in part due to the serious difficulties that have arisen from an inadequate structuring of older databases.

The information technology industry now fully accepts that data modelling is one of the most important of its functions, yet the number of practitioners with appropriate skills is still unacceptably low.

This course presents a comprehensive view of data modelling as a necessary process in the design of accurate, maintainable and efficient databases.It will describe the position of data modelling in relation to the other processes employed to achieve a physical database implementation.

The course includes topics such as data planning, top-down and bottom-up design and demonstrates the way in which data modelling is complementary to process modelling.
   
Objectives
The course aims to equip the participants with knowledge of the following subjects, and to provide an ability to apply the techniques related to these:
  • definition and benefits of a database approach
  • data modelling concepts and terminology
  • data planning
  • determining data requirements
  • documenting user views
  • normalisation
  • combining user views to form a data model
  • database models
  • mapping a physical database design
   
Benefits Organisations with data structured for access and security will reap both operational and strategic benefits. This course will provide staff the ability to take a corporate, rather than a system-specific view of the organisations data resource. Data modelling skills are increasingly respected in the industry but still less common than programming and process analysis skills. Hence they are a valuable addition to any practitioners toolbox.
   
Pre-Requisites

It is essential that the participant have a general knowledge of information systems and their development. Some knowledge of database concepts is desirable.

   
Structure and Presentation
The emphasis of this course is on "learning by doing" through student exercises, designed to support an appropriate working method and to reinforce the theory.

This course is presented in seminar style with the course leader encouraging participation. Where possible, concepts are adapted to the environment of the participants to ensure relevance and applicability.

Participation is encouraged throughout.The instructor have practical experience implementing all aspects of data modelling, hence he can relate the methods and techniques presented to the actual work environments through the integral discussion sessions.

Participants will have ample opportunity to construct their own data models using the techniques gained from this course.

Comprehensive course notes are provided for each person attending which follow the course material and provide a useful post-course reference.
   
Who Should Attend
This course is designed for
  • Information Systems Planners
  • Managers of the Information Technology function
  • Data Administration staff who will be responsible for data modelling
  • Systems Analysts and Programmers who will contribute to the definition of data requirements
  • Users who will participate in the definition of data requirements or the data modelling process.
   
Course Agenda

Introduction


Data as a Resource

  • Managing Resources
  • Information
  • Abstraction
  • Data
  • The Data Resource
  • Information vs Data
  • Information vs Technology
  • Reasons for Modelling
  • Data Models

Introduction To Data Modelling

  • Abstraction
  • Entities
  • Tables
  • Tangible Things
  • Personal and Organisational Roles
  • Events
  • Interactions
  • What to Look For
  • Where to Look
  • What to Challenge

Relationships

  • One-to-One Relationships
  • One-to-Many Relationships
  • Many-to-Many Relationships
  • Relationships and Tables
  • Resolving 1-1 Relationships
  • Many-to-Many Relationships
  • Redundant Relationships
  • The Effect of Time
  • Entity Definitions & Relationships
  • Change of Model Purpose

Data Modelling Advanced Concepts

  • Optional & Mandatory Relationships
  • Mutually Exclusive Relationships
  • Multiple Relationships
  • Recursive One-to-One Relationships
  • Recursive 1-Many Relationships
  • Recursive Many-Many Relationships

Entity Sub-Types

  • Generalisation and Specialisation
  • Entity Sub-Types
  • Entity Sub-Types and Tables

Data Models & the Data Dictionary

  • Choosing Entity Names
  • Entity Descriptions
  • Entity Attributes
  • Entity Keys
  • Attribute Definitions
  • Attribute Descriptions
Data Analysis
  • "Top-Down" Data Modelling Approach
  • "Bottom-Up" Data Analysis Approach
  • Features of Relational Tables
  • Dependency Diagrams
  • Functional Dependency
  • Grouping Attributes Into Tables
  • Repeating Groups of Attributes
  • Partial Dependencies
  • Transitive Dependencies
  • Many-Many Associations Between Attributes
  • Resolving Many-Many Associations Between Attributes
  • Synthesising Dependency Diagrams
Third Normal Form
  • Overview of Normalisation
  • Problems With Un-Normalised Tables
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Composing Normalised Tables
Sixth Normal Form
  • Boyce/Codd Normal Form
  • Introduction to Fourth and Fifth NF
  • Tables With Dependent Attributes
  • Tables With Independent Attributes
  • Fourth Normal Form
  • Join Dependencies
  • Fifth Normal Form
  • Entity Sub-Types
  • Sixth Normal Form

 

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <font color="" face="" size=""> <span style="">

    PMI, PMP, PMBOK, CAPM, PMI-ACP and the Registered Education Provider logo are registered marks of the Project Management Institute, Inc.
    CMMI®, Capability Maturity Model®, Capability Maturity Modeling®, CMM®, PCMM® and Carnegie Mellon® are registered in the US Patent and Trademark Office by Carnegie Mellon University.
    ISTQB® is a Registered Trade Mark of the International Software Testing Qualifications Board.
    IIBA®, BABOK® and Business Analysis Body of Knowledge® are registered trademarks owned by International Institute of Business Analysis. CBAP® and CCBA® are registered certification marks owned by International Institute of Business Analysis. Certified Business Analysis Professional, Certification of Competency in Business Analysis, Endorsed Education Provider, EEP and the EEP logo are trademarks owned by International Institute of Business Analysis.
    The APMG-International Agile Project Management, AgilePM and Swirl Device logos are trademarks of The APM Group Limited.
    PRINCE2®, ITIL®, IT Infrastructure Library®, and MSP® are registered trademarks of AXELOS Limited. The Swirl logo™ is a trade mark of AXELOS Limited.
    The ITIL Licensed Affiliate logo is a trademark of AXELOS Limited.
    SCRUM Alliance REP SM is a service mark of Scrum Alliance, Inc.