aspg-3-2690-1791417800 20261008000320 American Scientific Publishing Group admin@americaspg.com American Scientific Publishing Group Fusion: Practice and Applications FPA 2770-0070 2692-4048 2024 15 2 Duc Truong Faculty of Information System, University of Information Technology, Ho Chi Minh city, Vietnam; Vietnam National University, Ho Chi Minh city, Vietnam Hung Nguyen Faculty of Information Technology, Ho Chi Minh University of Education, Ho Chi Minh City, Vietnam Nha P. Tran Campus in Ho Chi Minh City, University of Transport and Communications, Vietnam Sang Vu Faculty of Information System, University of Information Technology, Ho Chi Minh city, Vietnam; Vietnam National University, Ho Chi Minh city, Vietnam Hien D. Nguyen Faculty of Computer Science, University of Information Technology, Ho Chi Minh city, Vietnam; Vietnam National University, Ho Chi Minh city, Vietnam The knowledge of courses can be represented by using ontology to create intelligent educational systems. This study proposes the Onto-Linking model as a knowledge framework that expresses the knowledge of the inputted schema to investigate the schema linking problem of the Text-to-SQL model. It combines the ontology with the structure of the schema. The proposed ontology is utilized to encapsulate the semantics of the intellectual elements of the schema, such as the table names, column names, foreign/primary key restrictions, and information about the probing schema connection. Therefore, the model makes it easier to accurately translate natural language questions into SQL queries. It improves query creation, helps with error handling, and supports query validation by helping the model better grasp the query's intent. The outcomes of the pedagogically oriented model aimed at guiding learners to comprehend the process of reasoning to attain the respective solution. 2024 121 131 2690 https://creativecommons.org/licenses/by/4.0/ 10.54216/FPA.150211 https://www.americaspg.com/journal/3/article/2690 https://www.americaspg.com/storage/61713577659.pdf