Diagrammatic Approach for Complete Automation of Relational Database Normalization at Conceptual Level
AER (Articulated Entity Relationship) diagrams proposed by one, are the extension of Entity Relationship (ER) diagrams to accommodate Functional Dependencies (FDs) as their integral part. Accommodation of FDs in ER diagram helps to achieve total and unconditional automation of relational database normalization. In this paper the authors have implemented a software Integrated Development Environment (IDE), called AER IDE, designed by extending the Graphical Editing Framework (GEF) and Draw2d plug-in functionality of Eclipse. The AER IDE helps to draw, validate, store and normalize AER diagrams. An AER IDE has five modules. AER Editor allows creation and edition of AER diagrams using Model View Controller (MVC) approach. AER diagrams are translated and stored as an xml file.