Revista Ingenierías Universidad de Medellín
Print version ISSN 1692-3324
ZAPATA JARAMILLO, Carlos Mario; GONZALEZ CALDERON, Guillermo and CHAVERRA MOJICA, John Jairo. Automatic generation of entity-relationship diagram and its representation in SQL from a controlled language (UN-LENCEP). Rev. ing. univ. Medellín [online]. 2011, vol.10, n.18, pp. 127-136. ISSN 1692-3324.
Entity-relationship diagram (ERD) is one of the used in modelling the domain information. Several proposals have emerged for speeding up and improving the software development process by either automatically or semi-automatically obtain the ERD. Natural language, controlled languages, and intermediate representations have been used in such a task. The stakeholders (people with some concern in application development), when untrained, are incapable to understand several of such representations. As a consequence, stakeholder active participation in software development is highly restricted. Trying to solve these problems, a set of heuristic rules for automatically obtaining ERD and its SQL-based equivalence is proposed in this paper. The starting point is UN-Lencep, a controlled language already used for generating other artefacts belonging to software application development.
Keywords : UN-Lencep; entity relationship; SQL.