Review the application data

The application requires the following meeting information to be persisted:

  • The date, start time, and duration.

  • The status.

  • The customer and agent who are involved.

  • The subject of the meeting.

To model the application data, you identify the entities (the ‘things’) that are involved:
  • Customers

  • Agents

  • Meetings

Each entity has different properties. For example, customers and agents have first and last names, and meetings have descriptions and dates.

Entities also have relationships between each other. For example, each meeting includes a customer and an agent. The following diagram illustrates some of the entity attributes and relationships. For simplicity, not all attributes and relationships are represented.

The design of the data model can be based on this type of diagram.