INTRODUCTION
The Entity-Relationship (ER) model in databases
refers to a diagrammed scheme that is used for
visualize the behavior of a database, since
allows us, in a simpler way, to organize the
entities with the most important attributes and their
relationships so that it results in someone outside of the
construction of the database a practical way to
to understand it.
In this way, there are basic concepts that must
explain in detail, such as entity, relationship, and attribute.
An entity is nothing more than the representation of objects or
things, whether real or abstract, that are different
clearly between each other. On the other hand, an attribute, like its
The name indicates it well, these are the characteristics that
describe or represent an entity and lastly, the
relationship is about a bond that allows us to define the
dependency between one or more entities; that is, we
allows to require that several entities share certain
essential attributes.
There are other elements such as relationships of
cardinality, which specifies the type of relationship that
they establish the entities among themselves and the keys, which are
unique attributes, which serve as a reference to a
specific entity.
On the other hand, there are Entity-Relationship models.
extended (ERE) that present qualities similar to the
from an ER model, but that provide greater flexibility to the
time to design the database according to what is needed
with this.
CONCLUSION
One could say, if one wishes, that an Entity model-
Relationship is fundamental for the design of a database.
data. While it is only the graphical representation of this and
not specifically necessary, but indeed a tool
that facilitates its design. An Entity-Relationship model is not
more than a data processing model or model of
data, which allows representing entities in a database
of data. It is built in two simple steps. It is prepared
the diagram with the necessary entities and relationships for
continue completing it with lists of attributes and
restrictions that cannot be reflected in the diagram.
Still, the modeling or graphing of this type of data
it is not enough to implement a database
starting from there, but it does give us results of its
behavior and, in this way, allows predicting data
even before being processed or captured.
For this reason, it is important to know how it
build, what it is made of and what it is used for.