Articulated Entity Relationship (AER) Diagram for Complete Automation of Relational Database Normalization

International Journal of Database Management Systems 05/2010; DOI: 10.5121/ijdms.2010.2206
Source: DOAJ

ABSTRACT In this paper an Articulated Entity Relationship (AER) diagram is proposed, which is an extension of EntityRelationship (ER) diagram to accommodate the Functional Dependency (FD) information as its integral partfor complete automation of normalization. In current relational databases (RDBMS) automation ofnormalization by top down approach is possible using ER diagram as an input, provided the FD informationis available independently, meanwhile, through user interaction. Such automation we call partial andconditional automation. To avoid this user interaction, there is a strong need to accommodate FDinformation as an element of ER diagram itself. Moreover, ER diagrams are not designed by taking intoaccount the requirements of normalization. However, for better automation of normalization it must be anintegral part of conceptual design (ER Diagram). The prime motivation behind this paper to design a systemthat need only proposed AER diagram as a sole input and normalize the database up to a given normal formin one go. This would allow more amount of automation than the current approach. Such automation we callas total and unconditional automation, which is better and complete in true sense. As the proposed AERdiagram is designed by taking in to account the normalization process, normalization up to Boyce CoddNormal Form (BCNF) becomes an integral part of conceptual design. Additional advantage of AER diagramis that any modifications (addition, deletion or updation of attributes) made to the AER diagram willautomatically be reflected in its FD information. Thus description of schema and FD information isguaranteed to be consistent. This cannot be assured in current approach using ER diagrams, as schema andFD information are provided to the system at two different times, separately.

Download full-text


Available from: Manikrao Dhore, Jul 04, 2015
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: It is proposed that this paper shows the types of pros and cons of storage and data retrieval tools. Also it shows the pros and cons of each type with a detailed explanation. The explanation shows how and when they can use any of them also determine the means and security applications in these tools and give the pros and cons of each one. In addition to provide tips and benefits of each one of them in terms of storage size and the number of tables. Also the number of users and analysis tools databases and support tools for each one of them, and how to repair, back up, and recover evidence rules for each one of them. Identifying the powers of users and the cons in each one and determine when Microsoft SQL server or Microsoft access can be used if needed. There are several versions of SQL server in the market. Each copy gives a certain capability. The user will find a copy for Project Enterprise. Which is the largest, the powerful, and most frequently used version. Also there is a developer’s copy. Where a developer will have an enterprise version with full specification. This version deigned only for developers who develop programs that run on SQL server. Moreover developer’s copy there is a miniature version of windows CE edition. Which works on windows CE systems for handheld devices.
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: Normalization is an important database design method, in the course of the teaching of data modeling the understanding and applying of this method cause problems for students the most. For improving the efficiency of learning normalization we looked for alternative normalization methods and introduced them into education. We made a survey among engineer students how efficient could they execute the normalization with different methods. We executed statistical and data mining examinations to decide whether any of the methods resulted significantly better solutions.
    05/2014; 6(2). DOI:10.5121/ijdms.2014.6201
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: A deductive system for database normalization is implemented by using a Flora-2 reasoning engine. The system allows for checking a relational schema up to Boyce-Codd normal form (BCNF) and functional independent normal form (FINF). Examples of system usage are presented and discussed.
    Information Technology Interfaces (ITI), Proceedings of the ITI 2011 33rd International Conference on; 07/2011