Show simple item record

dc.contributor.author Hettiarachchi, S
dc.contributor.author Sugandhika, C
dc.contributor.author Kathriarachchi, A
dc.contributor.author Ahangama, A
dc.contributor.author Weerasuriya, GT
dc.contributor.editor Sudantha, BH
dc.date.accessioned 2022-11-18T04:11:40Z
dc.date.available 2022-11-18T04:11:40Z
dc.date.issued 2019-12
dc.identifier.citation S. Hettiarachchi, C. Sugandhika, A. Kathriarachchi, S. Ahangama and G. T. Weerasuriya, "A Scenario-based ER Diagram and Query Generation Engine," 2019 4th International Conference on Information Technology Research (ICITR), 2019, pp. 1-5, doi: 10.1109/ICITR49409.2019.9407793. en_US
dc.identifier.uri http://dl.lib.uom.lk/handle/123/19558
dc.description.abstract 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. en_US
dc.language.iso en en_US
dc.publisher Information Technology Research Unit, Faculty of Information Technology, University of Moratuwa, Sri Lanka en_US
dc.relation.uri https://ieeexplore.ieee.org/document/9407793/ en_US
dc.subject ER diagram en_US
dc.subject SQL query generation en_US
dc.subject Natural Language Processing en_US
dc.title A scenario-based er diagram and query generation engine en_US
dc.type Conference-Full-text en_US
dc.identifier.faculty IT en_US
dc.identifier.department Information Technology Research Unit, Faculty of Information Technology, University of Moratuwa. en_US
dc.identifier.year 2019 en_US
dc.identifier.conference 4th International Conference in Information Technology Research 2019 en_US
dc.identifier.place Colombo,Sri Lanka en_US
dc.identifier.proceeding Proceedings of the 4th International Conference in Information Technology Research 2019 en_US
dc.identifier.doi doi: 10.1109/ICITR49409.2019.9407793 en_US


Files in this item

Files Size Format View

There are no files associated with this item.

This item appears in the following Collection(s)

  • ICITR - 2019 [19]
    International Conference on Information Technology Research (ICITR)

Show simple item record