CIMA E1 Syllabus C. Data And The Finance Function - Data Modelling - Notes ^{4 / 8}

Data Modelling

Data modelling is taking an organisation’s data requirements and laying them out in a way that is easy to turn them into computer code. 

To do this, there are three stages:

1. Conceptual - To organise, scope and define business concepts and rules

2. Logical - To develop a technical map of rules and data structures

3. Physical - Implementation of the database

Advantages of data modelling are:

1. Provides a consistent foundation for handling data

2. Achieves regulatory compliance by ensure that data is complete and secure

3. Consistency of naming conventions and values ultimately underpin and systematic and reliable database

4. Quality of data is enhanced because data modelling provides an organisation with a well-planned approach to its data, ensuring completeness and facilitating a high quality data warehouse