Web application for Generating Entity-Relationship Diagrams with Natural Language Processing

Entity-Relationship (ER) diagrams are widely used in software engineering to model relational databases and serve as semantic representations easily understood by humans. They convey the meaning of data, their relationships, and key modeling concepts. Despite their usefulness, designing ER diagrams requires technical expertise. This work proposes a prototype leveraging natural language processing tools, particularly large language models (LLMs), to simplify and democratize their creation. Using simple prompts, the system generates structured outputs in standard formats that can later be used for ER diagram construction. As a result, a web application was developed, offering a user-friendly interface that reduces time and effort, aiming to make diagram creation more accessible.

Authors

Institutions

Publication Details

Published
2024-11-01
DOI
https://doi.org/10.17979/spudc.9788497498913.36
Primary Topic
Service-Oriented Architecture and Web Services
Type
article
Field-Weighted Citation Impact
0.00

Funders

Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Web application for Generating Entity-Relationship Diagrams with Natural Language Processing

David Vilares, David Sineiro Barreiro
Service-Oriented Architecture and Web Services
article

Web application for Generating Entity-Relationship Diagrams with Natural Language Processing

David Vilares, David Sineiro Barreiro
article en

Abstract

Entity-Relationship (ER) diagrams are widely used in software engineering to model relational databases and serve as semantic representations easily understood by humans. They convey the meaning of data, their relationships, and key modeling concepts. Despite their usefulness, designing ER diagrams requires technical expertise. This work proposes a prototype leveraging natural language processing tools, particularly large language models (LLMs), to simplify and democratize their creation. Using simple prompts, the system generates structured outputs in standard formats that can later be used for ER diagram construction. As a result, a web application was developed, offering a user-friendly interface that reduces time and effort, aiming to make diagram creation more accessible.

CITIC Group (China) (CN)
Xunta de Galicia, European Regional Development Fund, Agencia Estatal de Investigación
Openalex Percentile: Top 57%
Service-Oriented Architecture and Web Services
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.