{"id":"https://openalex.org/W7116663831","doi":"https://doi.org/10.3390/bdcc10010002","title":"AI Assisted System for Automated Evaluation of Entity-Relationship Diagram and Schema Diagram Using Large Language Models","display_name":"AI Assisted System for Automated Evaluation of Entity-Relationship Diagram and Schema Diagram Using Large Language Models","publication_year":2025,"publication_date":"2025-12-20","ids":{"openalex":"https://openalex.org/W7116663831","doi":"https://doi.org/10.3390/bdcc10010002"},"language":"en","primary_location":{"id":"doi:10.3390/bdcc10010002","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc10010002","pdf_url":null,"source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.3390/bdcc10010002","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5054894344","display_name":"Raji Ramachandran","orcid":null},"institutions":[{"id":"https://openalex.org/I81556334","display_name":"Amrita Vishwa Vidyapeetham","ror":"https://ror.org/03am10p12","country_code":"IN","type":"education","lineage":["https://openalex.org/I81556334"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Raji Ramachandran","raw_affiliation_strings":["Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India"],"raw_orcid":"https://orcid.org/0000-0002-0916-7312","affiliations":[{"raw_affiliation_string":"Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India","institution_ids":["https://openalex.org/I81556334"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5120949009","display_name":"Parvathy Vijayan","orcid":null},"institutions":[{"id":"https://openalex.org/I81556334","display_name":"Amrita Vishwa Vidyapeetham","ror":"https://ror.org/03am10p12","country_code":"IN","type":"education","lineage":["https://openalex.org/I81556334"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Parvathy Vijayan","raw_affiliation_strings":["Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India","institution_ids":["https://openalex.org/I81556334"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104157659","display_name":"Athulya Anilkumar","orcid":null},"institutions":[{"id":"https://openalex.org/I81556334","display_name":"Amrita Vishwa Vidyapeetham","ror":"https://ror.org/03am10p12","country_code":"IN","type":"education","lineage":["https://openalex.org/I81556334"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Athulya Anilkumar","raw_affiliation_strings":["Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India","institution_ids":["https://openalex.org/I81556334"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5068415099","display_name":"Veena Gangadharan","orcid":null},"institutions":[{"id":"https://openalex.org/I81556334","display_name":"Amrita Vishwa Vidyapeetham","ror":"https://ror.org/03am10p12","country_code":"IN","type":"education","lineage":["https://openalex.org/I81556334"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Veena Gangadharan","raw_affiliation_strings":["Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Applications, Amrita School of Computing, Amrita Vishwa Vidyapeetham, Amritapuri 690525, India","institution_ids":["https://openalex.org/I81556334"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5054894344","https://openalex.org/A5068415099"],"corresponding_institution_ids":["https://openalex.org/I81556334"],"apc_list":{"value":1400,"currency":"CHF","value_usd":1515},"apc_paid":{"value":1400,"currency":"CHF","value_usd":1515},"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.78979039,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"10","issue":"1","first_page":"2","last_page":"2"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.36230000853538513,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.36230000853538513,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12884","display_name":"Educational Assessment and Pedagogy","score":0.0828000009059906,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.05220000073313713,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.5123000144958496},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4636000096797943},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.4426000118255615},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.4341999888420105},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.42649999260902405},{"id":"https://openalex.org/keywords/adaptability","display_name":"Adaptability","score":0.41280001401901245},{"id":"https://openalex.org/keywords/class-diagram","display_name":"Class diagram","score":0.3573000133037567},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.3544999957084656}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8180999755859375},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.5123000144958496},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4636000096797943},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.4426000118255615},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.4341999888420105},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.42649999260902405},{"id":"https://openalex.org/C177606310","wikidata":"https://www.wikidata.org/wiki/Q5674297","display_name":"Adaptability","level":2,"score":0.41280001401901245},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.39879998564720154},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3864000141620636},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.3849000036716461},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3646000027656555},{"id":"https://openalex.org/C202446494","wikidata":"https://www.wikidata.org/wiki/Q664166","display_name":"Class diagram","level":4,"score":0.3573000133037567},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.3544999957084656},{"id":"https://openalex.org/C2777286243","wikidata":"https://www.wikidata.org/wiki/Q5591926","display_name":"Grading (engineering)","level":2,"score":0.34279999136924744},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3352000117301941},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3269999921321869},{"id":"https://openalex.org/C114408938","wikidata":"https://www.wikidata.org/wiki/Q333373","display_name":"Abstract syntax","level":3,"score":0.30979999899864197},{"id":"https://openalex.org/C179603123","wikidata":"https://www.wikidata.org/wiki/Q1941921","display_name":"Modeling language","level":3,"score":0.3059000074863434},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.2955000102519989},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2840999960899353},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.27950000762939453},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2784999907016754},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.2711000144481659},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.26750001311302185},{"id":"https://openalex.org/C161756209","wikidata":"https://www.wikidata.org/wiki/Q613423","display_name":"Use Case Diagram","level":5,"score":0.2669000029563904},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.2565000057220459},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.25440001487731934},{"id":"https://openalex.org/C103278499","wikidata":"https://www.wikidata.org/wiki/Q254465","display_name":"Similarity (geometry)","level":3,"score":0.2538999915122986}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3390/bdcc10010002","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc10010002","pdf_url":null,"source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:c5954959afa242d5bdfea837e4bd9c05","is_oa":true,"landing_page_url":"https://doaj.org/article/c5954959afa242d5bdfea837e4bd9c05","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Big Data and Cognitive Computing, Vol 10, Iss 1, p 2 (2025)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3390/bdcc10010002","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc10010002","pdf_url":null,"source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.8556281328201294,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W98164311","https://openalex.org/W2171174900","https://openalex.org/W2908735376","https://openalex.org/W2921737648","https://openalex.org/W2965271728","https://openalex.org/W3040880957","https://openalex.org/W3171035162","https://openalex.org/W3201077663","https://openalex.org/W3213389151","https://openalex.org/W4292289324","https://openalex.org/W4295953868","https://openalex.org/W4323338676","https://openalex.org/W4376130103","https://openalex.org/W4388269499","https://openalex.org/W4399253720","https://openalex.org/W4400410977","https://openalex.org/W4401019373","https://openalex.org/W4401391253","https://openalex.org/W4401719166","https://openalex.org/W4401880117","https://openalex.org/W4404782360","https://openalex.org/W4405783412","https://openalex.org/W4405826651","https://openalex.org/W4406355359","https://openalex.org/W4407681469","https://openalex.org/W4409965697","https://openalex.org/W4410252955","https://openalex.org/W4410630760","https://openalex.org/W4413096733","https://openalex.org/W4413307789"],"related_works":[],"abstract_inverted_index":{"Automated":[0],"assessment":[1],"in":[2,41,66,159],"education":[3],"has":[4],"seen":[5],"rapid":[6],"growth":[7],"with":[8],"the":[9,39,74,89,121,143,156],"integration":[10],"of":[11,94,111],"AI,":[12],"particularly":[13],"for":[14,87,130,138],"objective":[15],"and":[16,30,64,69,91,98,118,150],"structured":[17],"tasks.":[18],"However,":[19],"evaluating":[20,88,161],"open-ended":[21],"design":[22,140,170],"problems":[23],"such":[24],"as":[25],"Entity":[26],"Relationship":[27],"(ER)":[28],"diagrams":[29,63],"relational":[31],"schemas":[32,65],"remains":[33],"a":[34,83,123,128],"significant":[35],"challenge":[36],"due":[37],"to":[38,54,78],"variability":[40],"valid":[42],"representations.":[43],"This":[44,132],"paper":[45],"proposes":[46],"an":[47],"AI-assisted":[48],"framework":[49],"using":[50],"Large":[51],"Language":[52],"Models(LLMs)":[53],"interpret":[55],"natural":[56],"language":[57],"database":[58,139],"scenarios,":[59],"generate":[60],"reference":[61,113],"ER":[62],"PlantUML":[67],"format.":[68],"compare":[70],"student":[71,163],"submissions":[72,164],"against":[73],"system":[75,122],"generated":[76],"solutions":[77],"assess":[79],"correctness.":[80],"We":[81],"proposed":[82],"novel":[84],"scoring":[85],"mechanism":[86],"semantic":[90],"structural":[92],"similarity":[93],"entities,":[95],"relationships,":[96],"keys,":[97],"table":[99],"mappings,":[100],"rather":[101,126],"than":[102,127],"relying":[103],"on":[104],"exact":[105],"syntax":[106],"matching.":[107],"Additionally,":[108],"manual":[109,144],"verification":[110],"AI-generated":[112],"outputs":[114],"enables":[115],"human":[116],"oversight":[117],"refinement,":[119],"making":[120],"supportive":[124],"tool":[125],"replacement":[129],"educators.":[131],"approach":[133],"offers":[134],"scalable,":[135],"intelligent":[136],"evaluation":[137],"tasks,":[141],"reducing":[142],"grading":[145],"effort":[146],"while":[147,165],"ensuring":[148],"fair":[149],"concept-driven":[151],"assessment.":[152],"Experimental":[153],"results":[154],"demonstrate":[155],"system\u2019s":[157],"effectiveness":[158],"accurately":[160],"varied":[162],"maintaining":[166],"adaptability":[167],"across":[168],"different":[169],"styles.":[171]},"counts_by_year":[],"updated_date":"2026-05-06T08:25:59.206177","created_date":"2025-12-22T00:00:00"}