Learning objectives
In this chapter, you will conduct your very first workshop with the team to get an initial idea of the business data. We will then go through an iterative process to create a data model ready to be used for implementation.
The main methodology used is an entity-relationship model (ERM). In a typical Appian project, there is no need to have extensive knowledge of it, hence I will discuss it only to the required level of detail.
An ERM consists of data objects, entities, and their relations. For each entity, the model also contains all the fields and their data types.
I will guide you on how to use all of this while creating a concrete model. You can see an example of an ERM here:
Figure 6.1 – Example ERM
Primary Key and Foreign Key
In a technical data model, we need a unique identifier (UID) for each entity. This is called the primary key (PK). In the implementation, we will use this to load specific items from the Appian...
