Fusion: Practice and Applications FPA 2692-4048 2770-0070 10.54216/FPA https://www.americaspg.com/journals/show/2690 2018 2018 Faculty of Information System, University of Information Technology, Ho Chi Minh city, Vietnam; Vietnam National University, Ho Chi Minh city, Vietnam Hung Hung Faculty of Information Technology, Ho Chi Minh University of Education, Ho Chi Minh City, Vietnam Hung Nguyen Campus in Ho Chi Minh City, University of Transport and Communications, Vietnam Nha P. .. Faculty of Information System, University of Information Technology, Ho Chi Minh city, Vietnam; Vietnam National University, Ho Chi Minh city, Vietnam Sang .. Faculty of Computer Science, University of Information Technology, Ho Chi Minh city, Vietnam; Vietnam National University, Ho Chi Minh city, Vietnam Hien D. Nguyen 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, foreignprimary 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 2024 121 131 10.54216/FPA.150211 https://www.americaspg.com/articleinfo/3/show/2690