Data modelling and design DTAN

(modified)

The development of models to represent and communicate data requirements and to enable organisations to understand their data assets and the relationships between real-world entities. The iteration, review and maintenance of data requirements and data models.

Guidance notes

Data modelling supports activities such as - but not limited to - the development of software systems, data integration, data retrieval data engineering, master data management, data governance.  

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 can be used communicate 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 corporate data requirements. Applies data analysis, design, modelling, and quality assurance techniques, to establish, modify or maintain data structures and their associated components. Provides advice and guidance to database designers and others using the data structures and associated components.

Data modelling and design: Level 3

(modified)

Applies data analysis, design, modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components. Advises database designers and other application development team members on the details of data structures and associated components.

Data modelling and design: Level 2

(modified)

Applies data analysis, design, and modelling techniques to establish, modify or maintain a data structure and its associated components