What is Data Modelling?
The process of designing how data will be structured, stored, and related in a database.
Why It Matters
Good data modelling prevents problems later by ensuring your database structure matches your application's needs.
Real-World Example
Deciding that a customer can have many orders, and each order can have many items, then designing the tables accordingly.
“Understanding terms like Data Modelling matters because it helps you have better conversations with developers and make smarter decisions about your software. You do not need to be technical. You just need to know enough to ask the right questions.”
Related Terms
Schema
A blueprint that defines the structure of your data, including fields and their types
Normalisation
Organising a database to reduce redundancy by splitting data into related tables.
Star Schema
A data warehouse design pattern with a central fact table connected to dimension tables, resembling a star shape.
Database
An organised collection of data that your application can store, retrieve, and update
Learn More at buildDay Melbourne
Want to understand these concepts hands-on? Join our one-day workshop and build a real web application from scratch.
Related Terms
Database
An organised collection of data that your application can store, retrieve, and update
Schema
A blueprint that defines the structure of your data, including fields and their types
Normalisation
Organising a database to reduce redundancy by splitting data into related tables.
Star Schema
A data warehouse design pattern with a central fact table connected to dimension tables, resembling a star shape.
SQL
A language for communicating with databases, used to create, read, update, and delete data
NoSQL
Databases that store data differently from traditional tables, often as flexible documents or key-value pairs