Data Modelling

GB Direct

Course

Online

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

Data Modelling covers the two key approaches to modelling data: entity relationship modelling and third normal form analysis. The first day examines the importance of modelling data using an approach that reflects the business users needs and priorities. The second day covers the more mechanistic approach offered by normalisation and then brings the two resultant views of the data together. During the course, participants will apply both data modelling techniques to a range of exercises.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • IT

Course programme

Principles of data modelling

  • Entities
  • Attributes
  • Relationships
  • Keys
  • Entity descriptions

Data relationships

  • Cardinality
  • Optionality
  • Exclusivity
  • Recursion
  • Naming relationships
  • Relationship descriptions

Data modelling - further concepts

  • Attribute descriptions
  • Domain descriptions
  • Sub-types, super-types
  • Partitioning data models
  • Transferable and non-transferrable relationships
  • Entity aspects

Relational data analysis

  • Relations
  • Primary and candidate keys
  • Third normal form analysis

Drawing third normal form models

  • Rationalising the results of relational data analysis
  • Representing relations and keys
  • Rules for building the TNF model
  • Comparing the TNF model with the data model

Validating the data model

  • Validating against requirements
  • Access paths
  • Entry points and input attributes
  • Navigation
  • Volumetrics

See related categories

Data Modelling

Price on request

The best SQL Server courses

See all

See all