OVERVIEW

A data model should be based on an organisation’s strategic, tactical and operational business plans, if information systems are to be built that are aligned with the corporate goals. But most organisations have not, until recently, recognised the importance of data models – which are as vital to the construction of an information system as an architect’s plans are for the construction of a house or a skyscraper.

Today, a data model is an essential prerequisite for development of Application Data Bases, Data Warehouses, for Internet/Intranet systems and for business transformation to take advantage of the Internet and corporate Intranet technologies.

OBJECTIVE

On completion of the course, both business experts and IT experts will understand:

  • How data modeling and data mapping are used to represent expert business knowledge.
  • How data entities, attributes and associations are used to represent business meaning in a design partnership with business and IT staff.
  • How data modeling can be used to represent management information needs and the underlying data in data models that enable rapid business change.
  • How data modeling can identify business requirements for data bases, Internet/Intranet and Data Warehousing projects.
  • How data modeling can be used for Forward Engineering, Reverse Engineering and Business Reengineering projects

COURSE CONTENT

Day 1

Data Modeling Concepts

Introduces and defines the components of a data model – data entities, attributes and associations, and their representation in data maps and entity lists.

Day 2

Data Entity Types

Defines and illustrates the use of each data entity type – principal (supertype) entities, secondary (subtype) entities, type entities, role entities, intersecting entities that are used to represent business activities, processes and systems, and structure entities that are used to capture expert knowledge for development of dynamically-updated expert data bases.

Data Mapping Conventions

Introduces conventions used to document data maps, and represent business strategies for strategic analysis of business alternatives.

Day 3

Strategies and Associations

Shows how data maps can be used for rapid feedback to management for refinement of strategic alternatives.

Data Attribute Types

Defines and illustrates the use of primary and foreign keys, compound keys and candidate keys. Defines and illustrates non-key attributes including secondary keys (ie. selection attributes), derived attributes, elemental attributes, group attributes and repeating groups.

Day 4

Outbound Activities Aimed At Improving:

  • Communication
  • Teamwork
  • Confidence
  • Motivation

Day 5

Course Exercises

 Five course exercises of increasing difficulty are included for student completion throughout the course, together with sample solutions.

Certificates

WHO SHOULD ATTEND

Audience for the Training

  • Business managers and their staff who need to understand the concepts of data modeling, so they can participate actively in partnership with IT staff in data modeling sessions that draw on their business expertise.
  • IT managers, data administrators and systems development staff who also need to understand the concepts of data modeling to participate with business managers and staff in data modeling sessions, and so enable the IT staff to draw on their systems development expertise in a design partnership with the business experts.
  • Others interested

METHODOLOGY

  • Face To Face
  • Role playing
  • Post session assessment
  • Video presentation
  • Case study

PERIOD

5 working days

LANGUAGE

  • English
  • Indonesia
  • Tetun