The Entity-Relationship Model

917 Words2 Pages

The success of a project can be severely be impacted if each of the key components is not planned out carefully and correctly. For more and more projects these days, a database is one of these key components. The database, while always given attention, is often not given the full planning that it deserves. This lack of planning at the beginning of a project could potentially lead to additional difficulties for the development team or result in limitation in both functionality and performance once the project is completed. To help with the planning of a database their exists a number of tools and methodologies, many of them follow the plans outlined by Dr. Peter Pin-Shan Chen and use the Entity-Relationship Model as their basis.

Dr. Peter Pin-Shan Chen first presented the Entity-Relationship (E-R) Model in March of 1976, in a widely read paper entitled, “The Entity-Relationship Model – Toward a Unified View of Data”. In this paper Dr. Chen proposed merging three other models, the Network model, the Relational Model, and the Entity Set Model into a single system which could take advantage of the best of all three. (Chen, 1976) This new unified model would be comprised of a number of Entities, which would be defined as a person, a place, an object, or some type of event for which the database is being designed to track and maintain. It is important to understand and note that entity definitions may not be well defined across any entire company as one department could easily define a term different depending upon their point of view. For this reason it is a good idea to ensure that these entities are well defined and that they are not used incorrectly. Entities can have a number of Attributes associated with them as additi...

... middle of paper ...

...inking and the Enhanced Entity-Relationship (EER) Model was created to expand the E-R Model. The EER added a number of new useful concepts that more accurately described the modeled data of this new age. Many other concepts and features have been incorporated into this model, which will continue to grow and adjust as the data that is being modeled adjusts and changes. At its heart however will remain the basic features put forth as the Entity-Relationship Model.

Works Cited

Chen, P. (1976). The entity-relationship model - toward a unified view of data. ACM Transactions on Database Systems, 1(1), Retrieved from http://www.csc.lsu.edu/news/erd.pdf

Witt, G. (1997, August). Is data modeling standing still?. Database Programming & Design, 64 . Retrieved from http://go.galegroup.com.portal.lib.fit.edu/ps/i.do?&id=GALE|A19690038&v=2.1&u=mel b26933&it=r&p=CDB&sw=w

More about The Entity-Relationship Model

Open Document