This example represents the ER diagram of the college student database. The student, college, mechanical, electronics and computer science are entities and enrols in and specialized in are the relationship. The attributes are name, age, gender, DOB, affiliation, address. Entity Relationship Diagram (ERD) is a diagram that shows the relationship between entity sets in a database. ER diagrams, in other words, assist in the explanation of database logical structure. Entities, attributes, and relationships are the building blocks of ER diagrams.
Rectangles represent entities, ovals represent attributes, and diamond shapes indicate relationships in ER Diagrams.