Data modeling is the process of identifying entities, fields, and relationships. The solution architect is responsible for defining the data model. A functional consultant may assist in the data modeling process. Data modeling is a skill and is something you get a lot better at with experience.
One of the key activities in the initial stages of your project is to create a high-level Entity Relationship Diagram (ERD) showing the entities and their relationships. An ERD helps the project team and business stakeholders understand the data in your system and how it relates to the other data.
Data modeling sounds simple, but it is anything but simple. At a base level, it involves identifying the reuse of existing entities, identifying new entities, determining the ordinality and cardinality of relationships between entities, and choosing fields and their data types. You will use techniques such as data normalization to help guide you in building your ERD. ...