Download now Free registration required
In this paper, an Articulated Entity Relationship (AER) diagram is proposed, which is an extension of Entity Relationship (ER) diagram to accommodate the Functional Dependency (FD) information as its integral part for complete automation of normalization. In current relational databases (RDBMS) automation of normalization by top down approach is possible using ER diagram as an input, provided the FD information is available independently, meanwhile, through user interaction. Such automation the authors call partial and conditional automation. To avoid this user interaction, there is a strong need to accommodate FD information as an element of ER diagram itself. Moreover, ER diagrams are not designed by taking into account the requirements of normalization.
- Format: PDF
- Size: 482.4 KB