Authors: Veda C. Storey
Tags: 1991, conceptual modeling
The Entity-Relationship (E-R) model is often recommended for use m the database design process because its concepts are percewed to be both natural and easy to use This paper describes a methodology for the design of a relational database based on the E-R model The methodology starts with the identification of the basic E-R constructs that occur m an apphcatlon resulting in an mltlal database design Next, ways of capturing certam semantics of an application through data abstraction and procedures for Identifying potential design problems are discussed The translation of the E-R model into a set of normahzed relations completes the design process This methodology budds on previous work on the Extended EntityRelationship Model and on the automation of database design.
