Generación automática del diagrama entidad-relación y su representación en SQL desde un lenguaje controlado (UN-LENCEP)

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.