IOSR Journal of Computer Engineering (IOSR-JCE) e-ISSN: 2278-0661,p-ISSN: 2278-8727, Volume 18, Issue 1, Ver. I (Jan – Feb. 2016), PP 37-43 www.iosrjournals.org DOI: 10.9790/0661-18113743 www.iosrjournals.org 37 | Page Towards Automated Generation of ER-Diagram using a Web Based Approach Amol V. Khaire 1 , Pramod B. Mali 2 1 PG Student, Department of Computer Engineering, Smt. Kashibai Navale College of Engineering, Vadgaon Bk, Pune, India 2 Assistant Professor, Department of Computer Engineering, Smt. Kashibai Navale College of Engineering, Vadgaon Bk, Pune, India Abstract : Diagrams plays an important role in the software development process. Drawing the diagrams manually is the time consuming task, so there are many tools to draw and modify the diagram. From all the diagrams ER (Entity Relationship) Diagram plays an important role in the software development process in Computer Engineering. This paper will describe the existing tools and presents a Web Application to generate the Entity Relationship Diagram automatically. This Web Application will allow us to generate Entity Relationship Diagram automatically by a form filling method which will take the Entity, Attribute and Relationship as an input and gives the Entity Relationship Diagram as output automatically. Keywords - Automated ER-Diagram, Entity Relationship Diagram, Software Development Process, Web Application I. INTRODUCTION There are numerous Diagrams like block diagrams, organizational chart for showing the hierarchical structure, network diagram of an association, Pie Chart, Flow Chart, ER-Diagram and so forth. In any case, out of every one of these Diagrams ER-Diagram is critical in the programming development process. In today's business world, databases are almost significant, as they describe information about an organization and entity relationship modeling is by a wide margin the most well-known approach to express the expository consequence of an early stage in the creation of the new database [1]. In this paper, we are going to see the distinction between the ER-Diagram creating tools which is a manual procedure, additionally require the lots of knowledge about tools and a web Application that we are going to create. Presently there are different tools to draw the diagram. These tools are not at risk for automatic generation of ER-Diagram (Entity Relationship graph). These tools provide the platform for the user to represent the ER-diagram using various symbols. Currently used tools for creation of ER-diagram are Edraw [7], DIA [8] and so forth. These tools are producing the Entity Relationship Diagram manually. This infer to requirement of dragging and dropping the items which are required to draw the Entity Relationship Diagram. It should to be noticed that there are numerous representations of ER-Diagram for the same problem. We additionally plan to implement the web Application in the three stages Step1:- Taking the input from the user, i.e. Entity, Attribute and Relationships Step2:- Providing input to a web form. Step3:- Generate and Store the ER-Diagram. DIA [7] and Edraw [8] is a manual tool to produce ER-Diagram. Paper [1] has not more concentrate on ER-Diagram, paper [2] has not Clear thought regarding the how to produce an ER-diagram naturally, paper [3] have the troublesome procedure for creating ER-Diagram automatically, so we are developing the Web application which is generating the Entity Relationship Diagram automatically. As this process is automatic this can be very useful for the user. II. LITERATURE SURVEY ADG (Auto-Diagram generator) tool is used to create the Flow Chart, Block Diagram and Entity Relationship Diagram by form filling and text selection method [1]. Form filling strategy used is one of the best methodologies for a novice user to determine the diagram prerequisites. The diagram generator and editor is the principle part of this tool. DeZign tool is utilized for generation of a diagram [2]. DeZign tool creates the Extended Entity Relationship Diagram and this is utilizing the form filling system as like the ADG (auto graph generator) tool. DeZign utilize the three modules to create the Diagram. DeZign device utilizes a Simple English explanation as information and gives the Entity Relationship Diagram as a yield. Paper [3] Explains about an ABCM (Association based theoretical model) and how the ABCM utilizes a connection Adaptive way to deal with creating the Entity Relationship chart. Before creating the ER diagram a graphical tool called Association based theoretical model is utilized to discover a relationship between a two or more objects