Title :
Survey on tools and systems to generate ER diagram from system requirement specification
Author :
Uduwela, Wasana C. ; Wijayarathna, Gamini
Author_Institution :
Dept. of Ind. Manage., Univ. of kelaniya, Kelaniya, Sri Lanka
Abstract :
Lack of Information Communication Technology (ICT) knowledge and the cost have been identified as challenges to Small and Medium Enterprises (SMEs) to adapt ICT. However there are tools and systems freely available to generate information systems automatically, but those require the database structure of the system. Database conceptualization based on the system requirement specification in natural language (SRS-NL) is the most significant landmark in the process of database design. Therefore it is desirable to have a tool, so that the non-technical people in SMEs could use to generate a quality conceptual database model (CDM) based on NL-SRS automatically. Comprehensive literature survey was conducted and evaluated the identified tools by analyzing usability, affordability and quality of the outcomes. Analysis showed that some limitations of the tools which cannot be used by non-technical people in SMEs.
Keywords :
database management systems; entity-relationship modelling; formal specification; natural language processing; small-to-medium enterprises; software tools; CDM; ER diagram; SME; SRS-NL; conceptual database model; database design; entity relationship diagram; information system; small and medium enterprise; system requirement specification in natural language; Business; Data models; Databases; Natural language processing; Semantics; Syntactics; ERD; Natural Language Processing (NLP); SME;
Conference_Titel :
Industrial Engineering and Engineering Management (IEEM), 2014 IEEE International Conference on
DOI :
10.1109/IEEM.2014.7058662