Modeling data

In data modeling, we deal with the relationships between Entities. As an example, a support ticket request from a help desk application (already setting the tone for the application that we are going to develop in the exercise) will have several fields, and not all of them will be in the same Entity. The Entity that supports the ticket must have its primary key, description, who created it, when it was created, who updated it, when it was updated, and its status. If we analyze it carefully, we can model this data through relationships with other Entities. For example, who created and who updated the record in the Entity can be foreign keys that refer to a user Entity (which the platform already makes available automatically, synchronized with the user provider). The state can be a foreign key that references a Static Entity where we will have all the states. These are examples of one-to-many relationships:

Figure 5.3 – One-to-many view in...