{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,22]],"date-time":"2025-12-22T09:05:29Z","timestamp":1766394329760,"version":"3.48.0"},"reference-count":43,"publisher":"MDPI AG","issue":"1","license":[{"start":{"date-parts":[[2025,12,20]],"date-time":"2025-12-20T00:00:00Z","timestamp":1766188800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["BDCC"],"abstract":"<jats:p>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\u2019s effectiveness in accurately evaluating varied student submissions while maintaining adaptability across different design styles.<\/jats:p>","DOI":"10.3390\/bdcc10010002","type":"journal-article","created":{"date-parts":[[2025,12,22]],"date-time":"2025-12-22T08:35:27Z","timestamp":1766392527000},"page":"2","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["AI Assisted System for Automated Evaluation of Entity-Relationship Diagram and Schema Diagram Using Large Language Models"],"prefix":"10.3390","volume":"10","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-0916-7312","authenticated-orcid":false,"given":"Raji","family":"Ramachandran","sequence":"first","affiliation":[{"name":"Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India"}]},{"given":"Parvathy","family":"Vijayan","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India"}]},{"given":"Athulya","family":"Anilkumar","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India"}]},{"given":"Veena","family":"Gangadharan","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India"}]}],"member":"1968","published-online":{"date-parts":[[2025,12,20]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","unstructured":"Murali, R., Ravi, N., and Surendran, A. (2024, January 8\u201311). Augmenting Virtual Labs with Artificial Intelligence for Hybrid Learning. Proceedings of the 2024 IEEE Global Engineering Education Conference (EDUCON), Kos Island, Greece.","DOI":"10.1109\/EDUCON60312.2024.10578649"},{"key":"ref_2","doi-asserted-by":"crossref","first-page":"2353494","DOI":"10.1080\/23311916.2024.2353494","article-title":"Exploring large language models as an integrated tool for learning, teaching, and research through the Fogg Behavior Model: A comprehensive mixed-methods analysis","volume":"11","author":"Jyothy","year":"2024","journal-title":"Cogent Eng."},{"key":"ref_3","doi-asserted-by":"crossref","first-page":"7339","DOI":"10.1007\/s10639-021-10581-5","article-title":"Adoption of online proctored examinations by university students during COVID-19: Innovation diffusion study","volume":"26","author":"Raman","year":"2021","journal-title":"Educ. Inf. Technol."},{"key":"ref_4","doi-asserted-by":"crossref","first-page":"866","DOI":"10.31681\/jetol.1335906","article-title":"An evaluation of the use of artificial intelligence applications in online education","volume":"6","year":"2023","journal-title":"J. Educ. Technol. Online Learn."},{"key":"ref_5","doi-asserted-by":"crossref","unstructured":"Nandakumar, S., Kumar, S.S., Anand, S., and Rao, S.N. (2025, January 11\u201312). Comparative Study of LLMs in Assessment Evaluation and Affective Feedback Generation. Proceedings of the 2025 Seventh International Conference on Computational Intelligence and Communication Technologies (CCICT), Sonepat, India.","DOI":"10.1109\/CCICT65753.2025.00105"},{"key":"ref_6","doi-asserted-by":"crossref","unstructured":"Tong, W., and Zhang, T. (2024). CodeJudge: Evaluating Code Generation with Large Language Models. arXiv.","DOI":"10.18653\/v1\/2024.emnlp-main.1118"},{"key":"ref_7","doi-asserted-by":"crossref","first-page":"219","DOI":"10.1109\/TLT.2023.3253071","article-title":"Embeddings for automatic short answer grading: A scoping review","volume":"16","author":"Putnikovic","year":"2023","journal-title":"IEEE Trans. Learn. Technol."},{"key":"ref_8","doi-asserted-by":"crossref","first-page":"2495","DOI":"10.1007\/s10462-021-10068-2","article-title":"An automated essay scoring system: A systematic literature review","volume":"55","author":"Ramesh","year":"2022","journal-title":"Artif. Intell. Rev."},{"key":"ref_9","first-page":"2749","article-title":"A survey on automatic subjective answer evaluation","volume":"20","author":"Desai","year":"2021","journal-title":"Adv. Appl. Math. Sci."},{"key":"ref_10","first-page":"427","article-title":"A comparative analysis of entity-relationship diagrams","volume":"3","author":"Song","year":"1995","journal-title":"J. Comput. Softw. Eng."},{"key":"ref_11","doi-asserted-by":"crossref","unstructured":"Li, Q., and Chen, Y.L. (2009). Entity-relationship diagram. Modeling and Analysis of Enterprise and Information Systems, Springer.","DOI":"10.1007\/978-3-540-89556-5_6"},{"key":"ref_12","first-page":"1088","article-title":"Use of Hybrid Mechanism of High Performance in Distributed Database Management System","volume":"14","author":"Banita","year":"2025","journal-title":"Int. J. Latest Technol. Eng. Manag. Appl. Sci."},{"key":"ref_13","doi-asserted-by":"crossref","unstructured":"Javed, M., and Lin, Y. (2020). Automated assessment of ER model using the domain knowledge. Computer and Information Science, Springer International Publishing.","DOI":"10.1007\/978-3-030-25213-7_10"},{"key":"ref_14","unstructured":"Ramachandran, R., Mariya, C., and Shini, A. (2023, January 7\u20138). Query-Based Evaluation of Multi-document Summarization Models. Proceedings of the World Conference on Information Systems for Business Management, Thailand, Bangkok."},{"key":"ref_15","doi-asserted-by":"crossref","unstructured":"Ramachandran, R., Abhijith, K., and Karthik, J. (2024, January 24\u201326). Knowledge Extraction from Distributed Heterogeneous Data Sources. Proceedings of the 2024 5th International Conference for Emerging Technology (INCET), Belgaum, India.","DOI":"10.1109\/INCET61516.2024.10592904"},{"key":"ref_16","doi-asserted-by":"crossref","unstructured":"Veena, G., Vinayak, A., and Nair, A.J. (2021, January 1\u20133). Sentiment analysis using improved VADER and dependency parsing. Proceedings of the 2021 2nd Global Conference for Advancement in Technology (GCAT), Bangalore, India.","DOI":"10.1109\/GCAT52182.2021.9587829"},{"key":"ref_17","doi-asserted-by":"crossref","first-page":"120440","DOI":"10.1016\/j.eswa.2023.120440","article-title":"AGRONER: An unsupervised agriculture named entity recognition using weighted distributional semantic model","volume":"229","author":"Veena","year":"2023","journal-title":"Expert Syst. Appl."},{"key":"ref_18","unstructured":"Omar, N., Naser, M.A., and Vadera, S. (2025, January 29\u201331). Heuristic-Based Entity-Relationship Modelling Through Natural Language Processing. Proceedings of the International Conference on Information and Communication Systems (ICICS), Nanjing, China."},{"key":"ref_19","doi-asserted-by":"crossref","unstructured":"Omar, N., Hanna, P., and Mc Kevitt, P. (2006, January 6\u20138). Semantic analysis in the automation of ER modelling through natural language processing. Proceedings of the 2006 International Conference on Computing & Informatics, Kuala Lumpur, Malaysia.","DOI":"10.1109\/ICOCI.2006.5276559"},{"key":"ref_20","doi-asserted-by":"crossref","unstructured":"Williams, E., and Xing, G. (March, January 26). GRADE: Grading and Assessment of Database ER Diagrams. Proceedings of the 56th ACM Technical Symposium on Computer Science Education (SIGCSE TS 2025), Pittsburgh, PA, USA.","DOI":"10.1145\/3641555.3705191"},{"key":"ref_21","doi-asserted-by":"crossref","unstructured":"Krieger, N., Speth, S., and Becker, S. (2024, January 20). HyLiMo: A Hybrid Live-Synchronized Modular Diagramming Editor as IDE Extension for Technical and Scientific Publications. Proceedings of the First IDE Workshop (IDE\u201924), Lisbon, Portugal.","DOI":"10.1145\/3643796.3648458"},{"key":"ref_22","doi-asserted-by":"crossref","unstructured":"Riazi, S., and Rooshenas, P. (March, January 26). LLM-Driven Feedback for Enhancing Conceptual Design Learning in Database Systems Courses. Proceedings of the 56th ACM Technical Symposium on Computer Science Education V.1 (SIGCSE TS 2025), Pittsburgh, PA, USA.","DOI":"10.1145\/3641554.3701940"},{"key":"ref_23","doi-asserted-by":"crossref","first-page":"1703","DOI":"10.20537\/2076-7633-2024-16-7-1703-1713","article-title":"Generating database schema from requirement specification based on natural language processing and large language model","volume":"16","author":"Salem","year":"2024","journal-title":"Comput. Res. Model."},{"key":"ref_24","doi-asserted-by":"crossref","unstructured":"Avignone, A., Tierno, A., Fiori, A., and Chiusano, S. (2025). Exploring Large Language Models\u2019 Ability to Describe Entity-Relationship Schema-Based Conceptual Data Models. Information, 16.","DOI":"10.3390\/info16050368"},{"key":"ref_25","doi-asserted-by":"crossref","unstructured":"Buss, C., Safari, M., Termehchy, A., Lee, S., and Maier, D. (2025). Towards Scalable Schema Mapping using Large Language Models. arXiv.","DOI":"10.1145\/3737412.3743490"},{"key":"ref_26","doi-asserted-by":"crossref","first-page":"61","DOI":"10.14257\/ijdta.2015.8.2.07","article-title":"Generating ER Diagrams from Requirement Specifications Based on Natural Language Processing","volume":"8","author":"Btoush","year":"2015","journal-title":"Int. J. Database Theory Appl."},{"key":"ref_27","doi-asserted-by":"crossref","unstructured":"Ghosh, S., Mukherjee, P., Chakraborty, B., and Bashar, R. (2018, January 3\u20137). Automated Generation of E-R Diagram from a Given Text in Natural Language. Proceedings of the International Conference on Machine Learning and Data Engineering (iCMLDE), Sydney, NSW, Australia.","DOI":"10.1109\/iCMLDE.2018.00026"},{"key":"ref_28","doi-asserted-by":"crossref","unstructured":"Ferrari, A., Abualhaijal, S., and Arora, C. (2024, January 24\u201324). Model generation with LLMs: From requirements to UML sequence diagrams. Proceedings of the 2024 IEEE 32nd International Requirements Engineering Conference Workshops (REW), Reykjavik, Iceland.","DOI":"10.1109\/REW61692.2024.00044"},{"key":"ref_29","unstructured":"DeBari, D. (2024). Evaluating Large Language Models in Software Design: A Comparative Analysis of UML Class Diagram Generation. [Ph.D. Thesis, Politecnico di Torino]."},{"key":"ref_30","doi-asserted-by":"crossref","unstructured":"Li, Y., Keung, J., Ma, X., Chong, C.Y., Zhang, J., and Liao, Y. (2024, January 2\u20134). LLM-Based Class Diagram Derivation from User Stories with Chain-of-Thought Promptings. Proceedings of the 2024 IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC), Osaka, Japan.","DOI":"10.1109\/COMPSAC61105.2024.00017"},{"key":"ref_31","unstructured":"Rouabhia, D., and Hadjadj, I. (2024). Enhancing Class Diagram Dynamics: A Natural Language Approach with ChatGPT. arXiv."},{"key":"ref_32","doi-asserted-by":"crossref","unstructured":"Fathiyah, H., and Widyani, Y. (2024, January 30\u201331). Use Case Generator Based on User Stories. Proceedings of the 2024 IEEE International Conference on Data and Software Engineering (ICoDSE), Online.","DOI":"10.1109\/ICoDSE63307.2024.10829877"},{"key":"ref_33","doi-asserted-by":"crossref","unstructured":"Karippara, K., Nayar, A.D., Illikkal, V., Vasudevan, N., and Jayaraman, S. (2020, January 10\u201312). Synthesis, analysis and visualization of networked executions. Proceedings of the 2020 5th International Conference on Communication and Electronics Systems (ICCES), Coimbatore, India.","DOI":"10.1109\/ICCES48766.2020.9138091"},{"key":"ref_34","doi-asserted-by":"crossref","unstructured":"Mohan, A., and Jayaraman, S. (2022, January 23\u201325). Enabling Granular Exploration of Sequence Diagrams with Activity Diagrams. Proceedings of the 2022 International Conference on Computing, Communication, Security and Intelligent Systems (IC3SIS), online.","DOI":"10.1109\/IC3SIS54991.2022.9885450"},{"key":"ref_35","unstructured":"Kurotych, A.O., and Bulatetska, L.V. (2024, January 27). Optimizing the process of ER diagram creation with PlantUML. Proceedings of the CS&SE@SW, Kryvyi Rih, Ukraine."},{"key":"ref_36","unstructured":"Shahbaz, A., and Ahsan, M. (2020, January 29\u201330). Automatic Generation of Extended ER Diagram Using Natural Language Processing. Proceedings of the International Conference on Computing, Mathematics and Engineering Technologies (iCoMET), Sukkur, Sindh, Pakistan."},{"key":"ref_37","first-page":"165","article-title":"A System for the Semiautomatic Generation of ER Models from Natural Language Requirements","volume":"31","author":"Ambriola","year":"1999","journal-title":"Data Knowl. Eng."},{"key":"ref_38","doi-asserted-by":"crossref","first-page":"3005","DOI":"10.1007\/s10462-022-10246-w","article-title":"Human-in-the-loop machine learning: A state of the art","volume":"56","year":"2023","journal-title":"Artif. Intell. Rev."},{"key":"ref_39","doi-asserted-by":"crossref","first-page":"3750","DOI":"10.1016\/j.procs.2025.04.630","article-title":"Extracting Triplets from Domain-specific Texts using Fine-Tuned LLaMA Models: A Comparative Study","volume":"258","author":"Veena","year":"2025","journal-title":"Procedia Comput. Sci."},{"key":"ref_40","unstructured":"Martinez-Gil, J. (2025). Evaluating Small-Scale Code Models for Code Clone Detection. arXiv."},{"key":"ref_41","unstructured":"Rozi\u00e8re, B., Gehring, J., Gloeckle, F., Sootla, S., Gat, I., Tan, X.E., Adi, Y., Liu, J., Sauvestre, R., and Remez, T. (2023). Code Llama: Open Foundation Models for Code. arXiv."},{"key":"ref_42","unstructured":"Guo, D., Zhu, Q., Yang, D., Xie, Z., Dong, K., Zhang, W., Chen, G., Bi, X., Wu, Y., and Li, Y. (2024). DeepSeek-Coder: When the Large Language Model Meets Programming\u2013The Rise of Code Intelligence. arXiv."},{"key":"ref_43","doi-asserted-by":"crossref","unstructured":"Ramachandran, R., Jawad, A.A., and J, A.U. (2025, January 5\u20136). Predictive Analysis of Machine Learning and Deep Learning Algorithms for Lung Disease Prediction. Proceedings of the 2025 International Conference on Inventive Computation Technologies (ICICT), Online.","DOI":"10.1109\/ICICT64420.2025.11004988"}],"container-title":["Big Data and Cognitive Computing"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2504-2289\/10\/1\/2\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,12,22]],"date-time":"2025-12-22T09:03:39Z","timestamp":1766394219000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2504-2289\/10\/1\/2"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,12,20]]},"references-count":43,"journal-issue":{"issue":"1","published-online":{"date-parts":[[2026,1]]}},"alternative-id":["bdcc10010002"],"URL":"https:\/\/doi.org\/10.3390\/bdcc10010002","relation":{},"ISSN":["2504-2289"],"issn-type":[{"value":"2504-2289","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,12,20]]}}}