EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

AI Assisted System for Automated Evaluation of Entity-Relationship Diagram and Schema Diagram Using Large Language Models

Raji Ramachandran, Parvathy Vijayan, Athulya Anilkumar, Veena Gangadharan

Big Data and Cognitive Computing · 20.12.2025 · 10 (1) · 2

DOI: 10.3390/bdcc10010002 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Big Data and Cognitive Computing, online erschienen am 20.12.2025. Verfasst von Raji Ramachandran und 3 weiteren Autor:innen. Die Arbeit wurde bisher 3-mal zitiert (Crossref) und nennt 43 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Automated assessment in education has seen rapid growth with the integration of AI, particularly for objective and structured tasks. However, evaluating open-ended design problems such as Entity Relationship (ER) diagrams and relational schemas remains a significant challenge due to the variability in valid representations. This paper proposes an AI-assisted framework using Large Language Models(LLMs) to interpret natural language database scenarios, generate reference ER diagrams and schemas in PlantUML format. and compare student submissions against the system generated solutions to assess correctness. We proposed a novel scoring mechanism for evaluating the semantic and structural similarity of entities, relationships, keys, and table mappings, rather than relying on exact syntax matching. Additionally, manual verification of AI-generated reference outputs enables human oversight and refinement, making the system a supportive tool rather than a replacement for educators. This approach offers scalable, intelligent evaluation for database design tasks, reducing the manual grading effort while ensuring fair and concept-driven assessment. Experimental results demonstrate the system’s effectiveness in accurately evaluating varied student submissions while maintaining adaptability across different design styles.

Zitieren

APA

Ramachandran, R., Vijayan, P., Anilkumar, A., & Gangadharan, V. (2025). AI Assisted System for Automated Evaluation of Entity-Relationship Diagram and Schema Diagram Using Large Language Models. Big Data and Cognitive Computing, 10(1), 2. https://doi.org/10.3390/bdcc10010002

Vancouver

Ramachandran R, Vijayan P, Anilkumar A, Gangadharan V. AI Assisted System for Automated Evaluation of Entity-Relationship Diagram and Schema Diagram Using Large Language Models. Big Data and Cognitive Computing. 2025;10(1):2. doi:10.3390/bdcc10010002

BibTeX
@article{Ramachandran2025,
  author = {Ramachandran, Raji and Vijayan, Parvathy and Anilkumar, Athulya and Gangadharan, Veena},
  title = {AI Assisted System for Automated Evaluation of Entity-Relationship Diagram and Schema Diagram Using Large Language Models},
  journal = {Big Data and Cognitive Computing},
  year = {2025},
  volume = {10},
  number = {1},
  pages = {2},
  doi = {10.3390/bdcc10010002}
}
Kostenlos starten →