Here we propose new heuristics that assist the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from a natural language description and describe the implementation of such a system called ER-Converter. Though this is a semi-automatic transformation process, ER-Converter aims to require minimal human intervention during the process. ER-Converter has been evaluated in blind trials against a set of database problems. ER-Converter has an average of 95% recall and 82% precision. The evaluation results are discussed and demonstrate that ER-Converter could be used, for example, within the domain model of a multimedia intelligent tutoring system, designed to assist in the learning and teaching of databases.
|Title of host publication||Unknown Host Publication|
|Editors||L McGinty, B Crean|
|Place of Publication||Dublin, Ireland|
|Publisher||Artificial Intelligence Association of Ireland|
|Number of pages||12|
|Publication status||Published - Sep 2004|
|Event||Proc. of the 15th Artificial Intelligence and Cognitive Science Conference (AICS-04) - Galway-Mayo Institute of Technology (GMIT), Castlebar, Ireland|
Duration: 1 Sep 2004 → …
|Conference||Proc. of the 15th Artificial Intelligence and Cognitive Science Conference (AICS-04)|
|Period||1/09/04 → …|
Omar, N., Hanna, JRP., & McKevitt, P. (2004). Heuristic-based entity-relationship modelling through natural language processing. In L. McGinty, & B. Crean (Eds.), Unknown Host Publication (pp. 302-313). Dublin, Ireland: Artificial Intelligence Association of Ireland.