Data modelling and design DTAN

(modified)

Developing models and diagrams to represent and communicate data requirements and data assets.

Guidance notes

(new)

The development of models to represent and communicate data requirements and to enable organisations to understand their data assets  The iteration, review and maintenance of data requirements and data models.

Data modelling supports activities such as - but not limited to -

  • helping organisations understand their data assets developing software systems, and the relationships between real-world entities.
  • data engineering, integration and interoperability
  • data retrieval
  • data governance and master data management

There are a range of different data modelling schemes but typically they contain the same components - entities, relationships, attributes and domains.

Types of data modelling schemes include - but not limited to - relational, object-oriented, NoSQL, time-based.

Data models are used to communicate different levels of detail - conceptual, logical and physical. 

Data modelling and design: Level 5

(modified)

Sets standards for data modelling and design tools and techniques, advises on their application, and ensures compliance. Manages the investigation of corporate data requirements based upon a detailed understanding of the corporate information requirements. Co-ordinates the application of analysis, design and modelling techniques to establish, modify or maintain data structures and their associated components. Manages the iteration, review and maintenance of data requirements and data models.

Data modelling and design: Level 4

(modified)

Investigates enterprise data requirements where there is some complexity and ambiguity. Plans own data modelling and design activities, selecting appropriate techniques and the correct level of detail for meeting assigned objectives. Provides advice and guidance to others using the data structures and associated components.

Data modelling and design: Level 3

(modified)

Applies standard data modelling and design techniques, based upon a detailed understanding of requirements. Establishes, modifies and maintains data structures and associated components. Communicates the details of data structures and associated components to others using the data structures and associated components.

Data modelling and design: Level 2

(modified)

Establishes, modifies or maintains simple data structures and associated components. Uses specific data modelling and design techniques under guidance.