It is critical for non-developer people to understand at least the basics of Data Modeling. For our case we will cover a simplified version of Database Modeling which shall allow you to properly identify then map the data structure and relationships for your business.
There are 3 main elements in Data Modeling:
An Entity is a data table of one type of “Information”, like for instance “Student” or “Subject” or “Enrollment”. Each row represent one instance of that entity type.
An Attribute is the column/cell element where each column/cell will contain the attribute value for each row/Entity. For instance “Student Name” and “Email” can be attributes or column values of the Entity “Student”.
A Relationship which is a cross-reference or a data connection between multiple Entities or tables. We will cover this in depth in the next lesson.