期刊名称：International Journal of Database Management Systems
印刷版ISSN：0975-5985
电子版ISSN：0975-5705
出版年度：2010
卷号：2
期号：4
出版社：Academy & Industry Research Collaboration Center (AIRCC)
摘要：AER (Articulated Entity Relationship) diagrams proposed by us, 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 we 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. AER Validator provides the facility of AER diagram validation based on a set of proposed rules. AER Normalizer allows normalization of an AER diagram, in one go, with the help of the proposed AER normalization rules and algorithms. Thus, it allows the total and unconditional automation of relational database normalization up to a given normal form; as an integral part of AER IDE. It also serves as a visual aid for the normalization process which is always easy to understand and interpret rather than theoretical approach. AER-XML Bidirectional Translator provides the import and export functionality of AER diagram, to and from an XML template making it compatible with the other toolset. AER-SQL Generator generates DDL scripts in the SQL schema format. The AER IDE is tested with ten distinct AER diagrams with all possible combinations of AER features and validation rules.
