Discuss the basic concepts of Entity Relationship (ER) Model. Illustrate as to how an ER model is diagrammed.
Open in App
Solution
It is a popular conceptual data model, which is mostly used in database-oriented applications. The major elements of ER Model are entities, attributes, identifiers and relationships that are used to express a reality for which a database is to be designed. The model is best depicted with the help of ER symbols, the list and description of which is shown in the figure. The formal blue print with a pictorial presentation of ER model is called as ER diagram. While preparing an ER diagram the following symbols are used to represent different types of entities, attributes, identifiers and relationships. The elements of ER model that are meant to describe and display the reality are discussed in the context of an accounting reality given.