期刊名称:Journal of Theoretical and Applied Information Technology
印刷版ISSN:1992-8645
电子版ISSN:1817-3195
出版年度:2015
卷号:77
期号:2
出版社:Journal of Theoretical and Applied
摘要:Today, Database systems plays a large part of our everyday lives �especially with the importance of the growing concept of database and storing information and keeping the information in a way secured in the database. Entity Relationship Diagram (ERD) is one of the popular and important concepts in database modeling. The design of the correct database (or good design) depends on the correct ERD that presents the requirements of the required system to the customer. In this paper, an Entity Relationship Diagram Mapper (ERDM) is built to provide developers of database as an End User Development (EUD) tool that enables them to draw any Entity Relationship Diagram then the system automatically map or translate these diagrams into their corresponding relations (or tables). The constructed database by the system has a good design or normalized relations. This system will be useful when the developer or user does not know many things about the mapping process of an Entity Relationship Diagram into Database schemas (its logical design). In order to test the developed system, sample of 100 ERDs collected from different sources were mapped using the system. The experiments showed that the accuracy of the system was 100%, without even any single error.
关键词:Database Design; Normalization; Entity Relationship Diagram; End User Development; Database Schema.