Practical example – developing the data model

In this section, we will walk through a practical example of developing the data model for an incident management feature. By examining this real-life scenario, you’ll gain insights into the process of designing and structuring your data tables effectively. Sarah did consider preparing an entity-relationship (ER) diagram, but her customers didn’t want to pay for this as part of the design; they said they would rather see the pages and that she could show them tables of data represented in a view. Sarah did some background reading on ER diagrams before this.

Further reading on ER diagrams

Go to https://learn.microsoft.com/en-us/power-apps/developer/data-platform/use-metadata-generate-entity-diagrams to learn more about ER diagrams.

Creating tables in Dataverse

To start implementing the data model, Sarah must create three tables: Incident, Incident Type, and Injury Type. These three tables must be implemented...