ICITR - 2019

Permanent URI for this collectionhttp://192.248.9.226/handle/123/14731

Browse

Browsing ICITR - 2019 by Author "Ahangama, A"

Filter results by typing the first few letters
Now showing 1 - 1 of 1
  • No Thumbnail Available
    item: Conference-Full-text
    A scenario-based er diagram and query generation engine
    (Information Technology Research Unit, Faculty of Information Technology, University of Moratuwa, Sri Lanka, 2019-12) Hettiarachchi, S; Sugandhika, C; Kathriarachchi, A; Ahangama, A; Weerasuriya, GT; Sudantha, BH
    Designing and developing a database is a crucial task in the System Development Life Cycle (SDLC). To design a database, it is essential to have proper knowledge about drawing Entity-Relationship (ER) Diagrams. Drawing ER diagrams is challenging for novices and people without a technical background. Furthermore, to retrieve data from a database requires expert domain knowledge about a database querying language like Structured Query Language (SQL). To address these issues, a system is proposed to identify and extract the necessary information from a given scenario to automatically generate the ER diagram. Based on that ER diagram, the system creates the database and is capable of generating SQL queries for any given type of natural language queries, in order to simplify accessing the data stored in the database.