Open In App

Building blocks of a Data Model

Last Updated : 25 Mar, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

A data model is a structure of the data that contains all the required details of the data like the name of the data, size of the data, relationship with other data and constraints that are applied on the data. It is a communication tool.

A data model is essential in order to store the database in a sorted manner. It will provide the interaction between the system analyst, designer and application programmer. It improves the understanding of designing of the database in which the organization is interested.

A data model constitutes of building blocks. They are:

1. Entities
2. Attributes
3. Relationships 
4. Constraints  

These are explained as following below in brief.

  1. Entities:
    Entities are real time objects that exist.It can be a person, place, object, event, concept. Entities are represented by a rectangle box containing the entity name in it.

    Example: Student, employee.

  2. Attributes:
    It is the set of characteristics representing an entity.It is represented by a ellipse symbol with attribute name on it.

    Example: A student has attributes like name, roll number, age and much more.

  3. Relationship:
    It describes the association between two entities.It is represented using diamond symbol containing relationship name with it.The data model generally uses three kinds of relationships:one to many, many to many, one to one.

    Example: The relationship between two entities Student and Class has many to many relationship.

  4. Constraints:
    Constraints are conditions applied on the data.It provides the data integrity.

    Example: A student can take a maximum of 2 books from the library is applied as a constraint on the student database.


Like Article
Suggest improvement
Previous
Next
Share your thoughts in the comments

Similar Reads