Back to Search Results

Training Course Summary:

The course provides a full understanding of the way in which to model the information used to support the business.

Pre-Requisites:

There are no formal pre-requisites for taking either the course or the examination, but some experience of systems analysis or design is recommended.

Who Should Attend:

The course is intended primarily for systems analysts and designers who will be involved in the specification of data leading to Data Base design. It is also useful for Project or Team Leaders, Analyst/Programmers, and those involved in reviewing system development products.

Training Course Overview/Content:

This course will enable course participants to:

identify entities, relationships and attributes
draw Logical Data Structures and complete the supporting documentation
normalise data to third Normal Form using Relational Data Analysis
enhance the Logical Data Structure by using third Normal Form relations
validate the data model against the system’s functional requirements

Follow-up Courses

Course participants can choose from a variety of courses, depending upon which ISEB Diploma they wish to gain.


Course Content

Data Modelling

Entity (master, detail)
Relationships (cardinality, optionality)
Attributes
Keys (simple, compound, hierarchic, foreign)
Identifying entities and relationships
Drawing the Logical Data Structure
Resolving many-to-many relationships
Resolving one-to-one relationships
Entity & Relationship Descriptions
Data Catalogue
Exclusive & recursive relationships
Entity sub-types, super-types & aspects
Partitioning the model

Relational Data Analysis
Concepts of normalisation
Relations
Sources for RDA
Normalisation procedure
Listing un-normalised data
Converting un-normalised data to 1NF, then 2NF, then 3NF
Rationalising Results
RDA in practice
Building partial data models
Enhancing the Required System LDM using 3NF

Validating the Logical Data Model
Access Path Analysis
Functional requirements
Entry points
Access paths

Qualifications:

This course will prepare students to take the written examination leading to the ISEB Certificate in Data Modelling