Publication

Abstract : The Entity-Relationship (ER) model has been recognized as the de facto standard for supporting relational database design. If the ER model is modeled cautiously, taking the business rules into consideration and then transformed into relations the resultant relations will be normalized. However, in most of the scenarios, database designers design relations directly without developing ER models which results in poor database design. In this paper, we propose a modeling methodology which eliminates modeling multivalued attributes in the ER model there by eliminating the need for normal forms that deal with multivalued attributes and nontrivial multivalued dependencies.