Relational database design based on the entity-relationship model

The Entity-Relationship (E-R) model is often endorsed for use in the database design process because its concepts seem 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 procedure starts with the identification of the basic E-R constructs that occur in an application resulting in an preliminary database design. Next, ways of arresting certain semantics of an application through data abstraction and events for identifying probable design problems are discussed. It is commonly known as an ER Diagram. An ER Diagram in DBMS plays a crucial role in designing the database. Today’s business world previews all the requirements demanded by the users in the form of an ER Diagram. Later, it's forwarded to the database administrators to design the database. The Entity Relational Model is a model for classifying entities to be represented in the database and representation of how those entities are interrelated. The ER data model requires enterprise schema that signifies the overall logical structure of a database graphically. In particular, the approach enables transformations of the imaginative ER model by Chen as well as prevalent extensions. We have proven the applicability of this approach in two ways: First, we have created a graphical editor capable of compliantly modeling ER diagrams and automatically transforming them to relational models. Second, we have conducted a practical study with our methodology and the created editor. Our findings show, that the transformation approach works correctly and the executed editor makes it accessible to users.