Data models are a cornerstone of design. Engineers build a model of a car to work out any details before putting it into production. In the same manner, system designers develop models to explore ideas and improve the understanding of the database design.
Purpose of model : The objective is to produce a model that fits a multitude of these uses, can be understood by an end user, and contains sufficient detail for a developer to build a database system.
ER MODEL
An entity relationship (ER) model is an illustration of various entities in a business and the relationships between them. An ER model is derived from business specifications or narratives and built during the analysis phase of the system development life cycle. ER models separate the information required by a business from the activities performed within a business
Benefits : Documents information for the organization in a clear, precise formatProvides a clear picture of the scope of the information requirementProvides an easily understood pictorial map for the database designOffers an effective framework for integrating multiple applications
No comments:
Post a Comment