A data model is the foundation of any application. It’s the entities/tables that store your data, and the relationships between them. But how do you build one from scratch?
In this video, we start with a real-world scenario for a property management company who needs to schedule housekeepers for their properties. We break down the entities we need, and decide whether they should be custom entities or if we can repurpose something that comes out-of-the-box. Then we discuss the different types of relationships and look at examples for each: one-to-many (1:N), many-to-one (N:1) and many-to-many (N:N). Once armed with the concepts about relationships, we apply them to our data model.
To wrap up, we see a brief list of tools that can be used to create ERDs.
If you’re interested in learning more, I’ve partnered with Pluralsight to build out a full 2-hour course about how to get started with model-driven apps in Power Apps: https://pluralsight.pxf.io/7mVor5
00:00 – Overviewing the sample app/scenario we’ll be data modeling
00:41 – Determining the entities/tables needed in the data model
02:36 – Do we need custom entities or can we use out-of-the-box?
05:02 – Relationships in a Power Apps data model
05:35 – One-to-many (1:N) relationship
06:17 – Many-to-one (N:1) relationship
07:25 – Many-to-many (N:N) relationship
07:50 – Determining which relationships we need for our data model
10:13 – The completed data model
10:29 – Tools for creating entity-relationship diagrams (ERDs)