International Journal of Academic Information Systems Research (IJAISR) ISSN: 2000-002X Vol. 2 Issue 2, February – 2018, Pages: 1-7 www.ijeais.org/ijaisr 1 SQL Tutor for Novice Students Masoud I. El Agha, Abdallah M. Jarghon, Samy S. Abu-Naser Department of Information Systems, Faculty of Engineering and information technology, Al-Azhar University, Gaza Abstract: These days, the utilization of innovation to improve educating and learning is expanding quickly. Intelligent Tutoring Systems (ITS) is one of method that uses artificial intelligence techniques to represent a form of computer-based training in which the system uses a knowledge base to provide guidance to the student as the student interacts with the system. In this paper, we plan and create SQL (Structured Query Language) Intelligent Tutoring Systems for beginner understudies in programming SQL, which understudies need to specialize in information base track. The framework gives all themes of SQL and creates a few inquiries for every subject and the understudies should answer these inquiries accurately to move to the following level, the SQL coach concentrate on utilizing video, sound and pictures to make learning process simpler. Keywords: Intelligent Tutoring System, SQL, data Base, ITSB 1. INTRODUCTION The advancement of Intelligent Tutoring System for showing SQL dialect for database subject. Database framework is one of the center subjects in software engineering, showing database picks up challenge when it achieves the part on the best way to educate the question dialect. Instructing and learning database start with the idea of experiencing the outlining of database graph keeping in mind the end goal to define the issue. From the diagram, SQL is needed to construct the database into physical implementation. Most of the students face difficulties when constructing database using SQL or querying database using SQL. Some of them get confused on the command used to manipulate and define the database while others get confused on when to use certain command for certain situation. For instance, A student might be confused when to use the clause SELECT, what is the purpose of WHERE clause and the usage of several aggregate functions such as AVG, COUNT, SUM and etc. Based on the problem regarding the understanding, we are developing Intelligent Tutoring System to handle this problem. ITS is chosen in order enable the system to repeat again consistently since humans are unable to do the same repetitive task consistently [7]. The main role of SQL tutor is to provide customized hints for each student and dynamically generated problems based on inferences about the student knowledge, processing from simple problems to complex problems, another role is to know individual student differences. These roles are considered very important to determine the performance of the tutor. The SQL tutor designed and developed using Intelligent Tutoring System Builder (ITSB) [1]. The ITSB tool designed and developed to help teachers for building Intelligent Tutoring System in many fields. 2. LITERATURE REVIEW ITS have been an important and expanding research area for several years. It has become a very popular and useful in our universities, schools, Factories. There are some of them, such as An Intelligent Tutoring System Authoring Tool designed by Abu Naser teaches how to use java program [2], SQL-Tutor, ITS that teach students English dialogues through interaction with students and it takes into account the individual differences of students through levels [3]. ITS to examine errors in algebra [4]. A comparative study between Animated Intelligent Tutoring Systems (AITS) and Video-based Intelligent Tutoring Systems (VITS) [7], Affective Tutoring Systems (ATS) based on embedded devices is a system that relies on embedded devices for detecting the feelings, emotion, psychology student and also adapt to the student's mood such as angry, frustrated and fatigued etc. Based on the mood and feelings of the student, the student will learn [8, 9], teaching AI searching algorithms [10], teaching database to sophomore students in Gaza [11], Predicting learners performance using NT and ITS [12], learning to program in C++ [13], and security algorithms [37-47]. 3. ITS ARCHITECTURE Generally, ITS as illustrated in Fig. 1[7] consists of four main components namely, expert system, pedagogy module. Broadly defined, an intelligent tutoring system is educational software containing an artificial intelligence component. The software tracks students work tailoring feedback and hints along the way. By collecting information on a particular student's performance, the software can make inferences about strengths and weaknesses and can suggest additional work, student model and user interface. Expert System has the ability to guide the student in solving problems and measure students' performance. Pedagogy module is use to control the interaction between the student and the system. Student model is used to determine student level and their progress during the teaching and learning process. Communication between student and systems is through the user interface [7]. International Journal of Academic Information Systems Research (IJAISR) ISSN: 2000-002X Vol. 2 Issue 2, February – 2018, Pages: 1-7 www.ijeais.org/ijaisr 2 3.1 Student Module The student model stores information that is specific to each individual learner. At a minimum, such a model tracks how well a student is performing on the material being taught. The model is necessary in order to tailor instructions to a student's privacy and learning needs Without this knowledge, the pedagogical component of the tutor has no basis on which to make decisions and is forced to treat all students similarly. 3.2 Pedagogical Module This module utilizes data from student model to figure out what parts of the space information ought to be displayed to the student and recognize the requirements for every understudy. This segment gives a model of the instructing procedure. For instance, data about when to survey, when to display another point, and which subject to exhibit is controlled by the academic module [7,8]. 3.3 Domain Knowledge This component contains information the tutor is teaching, and is the most important since without it, there would be nothing to teach the student. Generally, it requires significant knowledge on engineering to represent a domain so that other parts of the tutor can access it. The domain model covers the following topics:  Lesson 1: Introduction to SQL  Lesson 2: Retrieving Data  Lesson 3: Updating Data  Lesson 4: Inserting Data  Lesson 5: Deleting Data  Lesson 6: Sorting and Filtering Data  Lesson 7: Advanced Filtering  Lesson 8: Summarizing Data  Lesson 9: Grouping Data  Lesson 10: Using Subqueries  Lesson 11: Joining Tables  Lesson 12: Managing Tables  Lesson 13: Using Views  Lesson 14: Stored Procedures  Lesson 15: Using Cursors  Lesson 16: Using Transactions 3.4 Communications Module Interactions with the learner, including the dialogue and the screen layouts, are controlled by this component. It handles the question on how should the material be presented to the student in the most effective way. A screenshots of the tutor interface are shown in Fig 2, Fig 3, Fig 4, Fig 5 , Fig 6 and Fig 7 . International Journal of Academic Information Systems Research (IJAISR) ISSN: 2000-002X Vol. 2 Issue 2, February – 2018, Pages: 1-7 www.ijeais.org/ijaisr 3 Fig. 2: Login screen Fig. 3: Teaching screen International Journal of Academic Information Systems Research (IJAISR) ISSN: 2000-002X Vol. 2 Issue 2, February – 2018, Pages: 1-7 www.ijeais.org/ijaisr 4 F Fig. 4: Examples screen (video example) Fig. 5: Student Exercises form International Journal of Academic Information Systems Research (IJAISR) ISSN: 2000-002X Vol. 2 Issue 2, February – 2018, Pages: 1-7 www.ijeais.org/ijaisr 5 Fig. 6: Shows current assessment of the student performance Fig. 7: Shows a notification of the performance of the student in a specific lesson 4. CONCLUSION This research paper presents recent developments related to the SQL Intelligent tutoring systems , SQL tutor was designed developed using ITSB authoring tool for teaching SQL , this tutor desgined for novice students which they wishing to navigate the world of programming specially data base track , In designing process we focus on displaying material as video ,sound, picture files to facilitate teaching process , In an initial evaluation of the system, the students and teachers were satisfied with it. Our future work is coordinated to the utilization of Distributed AI techniques to accomplish correspondence of the ITS with other clever instructive frameworks educating the same or related subject REFERENCES [1] Abu Naser, S. S. (2016). ITSB: An Intelligent Tutoring System Authoring Tool. Journal of Scientific and Engineering Research, 3(5), 63-71. [2] Elnajjar, A. E. A., & Abu Naser, S. S. (2017). DESTutor: An Intelligent Tutoring System for Teaching DES Information Security Algorithm. International International Journal of Academic Information Systems Research (IJAISR) ISSN: 2000-002X Vol. 2 Issue 2, February – 2018, Pages: 1-7 www.ijeais.org/ijaisr 6 Journal of Advanced Research and Development, 2(1), 69-73. [3] Qwaider, S. R., & Abu Naser, S. S. (2017). Expert System for Diagnosing Ankle Diseases. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 89-101. [4] AbuEl-Reesh, J. Y., & Abu Naser, S. S. (2017). An Expert System for Diagnosing Shortness of Breath in Infants and Children. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 102-115. [5] Al Rekhawi, H. A., Ayyad, A. A., & Abu Naser, S. S. (2017). Rickets Expert System Diagnoses and Treatment. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 149-159. [6] Almurshidi, S. H., & Abu Naser, S. S. (2017). Design and Development of Diabetes Intelligent Tutoring System. EUROPEAN ACADEMIC RESEARCH, 6(9), 8117-8128. [7] Abu Ghali, M. J., Mukhaimer, M. N., Abu Yousef, M. K., & Abu Naser, S. S. (2017). Expert System for Problems of Teeth and Gums. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 198-206. [8] Al-Bayed, M. H., & Abu Naser, S. S. (2017). An intelligent tutoring system for health problems related to addiction of video game playing. International Journal of Advanced Scientific Research, 2(1), 4-10. [9] Hamed, M. A., & Abu Naser, S. S. (2017). An intelligent tutoring system for teaching the 7 characteristics for living things. International Journal of Advanced Research and Development, 2(1), 31-45. [10] Almurshidi, S. H., & Abu Naser, S. S. (2017). Stomach disease intelligent tutoring system. International Journal of Advanced Research and Development, 2(1), 26-30. [11] El Agha, M., Jarghon, A., & Abu Naser, S. S. (2017). Polymyalgia Rheumatic Expert System. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 125-137. [12] Khella, R. A., & Abu Naser, S. S. (2017). Expert System for Chest Pain in Infants and Children. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 138-148. [13] Akkila, A. N., & Abu Naser, S. S. (2017). Teaching the right letter pronunciation in reciting the holy Quran using intelligent tutoring system. International Journal of Advanced Research and Development, 2(1), 64-68. [14] AbuEloun, N. N., & Abu Naser, S. S. (2017). Mathematics intelligent tutoring system. International Journal of Advanced Scientific Research, 2(1), 11-16. [15] Bakeer, H. M. S., & Naser, S. S. A. (2017). Photo Copier Maintenance Expert System V. 01 Using SL5 Object Language. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 116-124. [16] Nabahin, A., Abou Eloun, A., & Abu Naser, S. S. (2017). Expert System for Hair Loss Diagnosis and Treatment. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 160-169. [17] Al-Nakhal, M. A., & Abu Naser, S. S. (2017). Adaptive Intelligent Tutoring System for learning Computer Theory. EUROPEAN ACADEMIC RESEARCH, 6(10), 8770-8782. [18] Abu Hasanein, H. A., & Abu Naser, S. S. (2017). An intelligent tutoring system for cloud computing. International Journal of Academic Research and Development, 2(1), 76-80. [19] Alhabbash, M. I., Mahdi, A. O., & Abu Naser, S. S. (2016). An Intelligent Tutoring System for Teaching Grammar English Tenses. EUROPEAN ACADEMIC RESEARCH, 6(9), 7743-7757. [20] Alawar, M. W., & Abu Naser, S. S. (2017). CSS-Tutor: An intelligent tutoring system for CSS and HTML. International Journal of Academic Research and Development, 2(1), 94-98. [21] Al-Bastami, B. G., & Abu Naser, S. S. (2017). Design and Development of an Intelligent Tutoring System for C# Language. EUROPEAN ACADEMIC RESEARCH, 6(10), 87-95. [22] Hilles, M. M., & Abu Naser, S. S. (2017). Knowledgebased Intelligent Tutoring System for Teaching Mongo Database. EUROPEAN ACADEMIC RESEARCH, 6(10), 8783-8794. [23] Al-Hanjori, M. M., Shaath, M. Z., & Abu Naser, S. S. (2017). Learning computer networks using intelligent tutoring system. International Journal of Advanced Research and Development (2), 1. [24] Aldahdooh, R., & Abu Naser, S. S. (2017). Development and Evaluation of the Oracle Intelligent Tutoring System (OITS). EUROPEAN ACADEMIC RESEARCH, 6(10), 8711-8721. [25] Shaath, M. Z., Al-Hanjouri, M., Abu Naser, S. S., & Aldahdooh, R. (2017). Photoshop (CS6) intelligent tutoring system. International Journal of Academic Research and Development, 2(1), 81-87. [26] Mrouf, A., Albatish, I., Mosa, M., & Abu Naser, S. S. (2017). Knowledge Based System for Long-term Abdominal Pain (Stomach Pain) Diagnosis and Treatment. International Journal of Engineering and Information Systems (IJEAIS), 1(4), 71-88. [27] Naser, S. (2009). Evaluating the effectiveness of the CPP-Tutor an intelligent tutoring system for students learning to program in C++. Journal of Applied Sciences Research, 5(1), 109-114. [28] Mahdi, A. O., Alhabbash, M. I., & Abu Naser, S. S. (2016). An intelligent tutoring system for teaching advanced topics in information security. World Wide Journal of Multidisciplinary Research and Development, 2(12), 1-9. [29] Al Rekhawi, H. A., & Abu Naser, S. (2018). An Intelligent Tutoring System for Learning Android Applications Ui Development. International Journal of Engineering and Information Systems (IJEAIS), 2(1), 114. [30] Albatish, I., Mosa, M. J., & Abu-Naser, S. S. (2018). ARDUINO Tutor: An Intelligent Tutoring System for Training on ARDUINO. International Journal of Engineering and Information Systems (IJEAIS), 2(1), 236-245. [31] Mosa, M. J., Albatish, I., & Abu-Naser, S. S. (2018). ASP. NET-Tutor: Intelligent Tutoring System for leaning ASP. NET. International Journal of Academic Pedagogical Research (IJAPR), 2(2), 1-8. [32] AbuEl-Reesh, J. Y., & Abu-Naser, S. S. (2018). An Intelligent Tutoring System for Learning Classical Cryptography Algorithms (CCAITS). International Journal of Academic and Applied Research (IJAAR), 2(2), 1-11. [33] Abu Ghali, M., Abu Ayyad, A., Abu-Naser, S. S., & Abu Laban M. (2018). An Intelligent Tutoring System for Teaching English Grammar. International Journal of Academic Engineering Research (IJAER), 2(2), 1-6. [34] Marouf, A., Abu Yousef, M. K., Mukhaimer, M. N., & Abu-Naser, S. S. (2018). An Intelligent Tutoring System International Journal of Academic Information Systems Research (IJAISR) ISSN: 2000-002X Vol. 2 Issue 2, February – 2018, Pages: 1-7 www.ijeais.org/ijaisr 7 for Learning Introduction to Computer Science. International Journal of Academic Multidisciplinary Research (IJAMR), 2(2), 1-8. [35] Abu Naser, S. (2008). An Agent Based Intelligent Tutoring System For Parameter Passing In Java Programming. Journal of Theoretical & Applied Information Technology, 4(7). [36] Abu Naser, S. (2008). JEE-Tutor: An Intelligent Tutoring System for Java Expression Evaluation. Information Technology Journal, Scialert, 7(3), 528532. [37] Abu Naser, S. S. (2001). A comparative study between animated intelligent tutoring systems AITS and videobased intelligent tutoring systems VITS. Al-Aqsa Univ. J, 5(1), 72-96. [38] Abu Naser, S. S. (2006). Intelligent tutoring system for teaching database to sophomore students in Gaza and its effect on their performance. Information Technology Journal, 5(5), 916-922. [39] Abu Naser, S. S. (2008). Developing an intelligent tutoring system for students learning to program in C++. Information Technology Journal, 7(7), 1055-1060. [40] Abu Naser, S. S. (2008). Developing visualization tool for teaching AI searching algorithms. Information Technology Journal, Scialert, 7(2), 350-355. [41] Abu Naser, S. S. (2012). Predicting learners performance using artificial neural networks in linear programming intelligent tutoring system. International Journal of Artificial Intelligence & Applications, 3(2), 65. [42] Abu Naser, S. S. (2012). A Qualitative Study of LPITS: Linear Programming Intelligent Tutoring System. International Journal of Computer Science & Information Technology, 4(1), 209. [43] Mahmoud, Ahmed Y and Chefranov, Alexander G. (2009). Hill cipher modification based on eigenvalues hcm-EE,Proceedings of the 2nd international conference on Security of information and networks ACM, pp. 164167 [44] Ahmed, Y Mahmoud and Chefranov, Alexander. (2011). Hill cipher modification based on pseudorandom Eigen values HCM-PRE, journal of Applied Mathematics and Information Sciences (SCI-E), vol (8:2), pp. 505-516 [45] Mahmoud, Ahmed Y and Chefranov, Alexander G. (2010). Secure Hill cipher modifications and key exchange protocol, Automation Quality and Testing Robotics (AQTR), 2010 IEEE International Conference, vol 2, pp.1-6 [46] Doukhnitch, Evgueni and Chefranov, Alexander G and Mahmoud, Ahmed. (2013). Encryption Schemes with Hyper-Complex Number Systems and Their HardwareOriented Implementation, Theory and Practice of Cryptography Solutions for Secure Information Systems},vol 110, IGI Global [47] Mahmoud, AY and Chefranov, Alexander G. (2012). Secure hill cipher modification based on generalized permutation matrix SHC-GPM, journal of Information Sciences Letters, pp. 91-102 [48] Chefranov, Alexander G and Mahmoud, Ahmed Y. (2013). Commutative Matrix-based Diffie-Hellman-Like Key-Exchange Protocol, Information Sciences and Systems 2013, pp. 317-324,Springer, Cham [49] Mahmoud, Ahmed Y and Chefranov, Alexander G. (2014). A Hill Cipher Modification Based on Eigenvalues Extension with Dynamic Key Size HCMEXDKS, International Journal of Computer Network and Information Security, vol 6:5, Modern Education and Computer Science Press [50] Chefranov, Alexander G and Mahmoud, Ahmed Y. (2010). Elgamal public key cryptosystem and signature scheme in GU (m, p, n), Proceedings of the 3rd international conference on Security of information and networks, pp. 164-167, ACM [51] Mahmoud, Ahmed Yehya Ahmed. (2012). Development of Matrix Cipher Modifications and Key Exchange Protocol, Ph.D thesis, Eastern Mediterranean University (EMU) [52] Mahmoud, Ahmed Y. and Mahdi, Ali Osama. (2016). Comments On Multi-window Against Mobile Application Lock, Journal of Multidisciplinary Engineering Science Studies (JMESS), Vol 2:5, May – 2016, pp. 494-497, JMESS [53] Abdelwahed, Ann S. and Mahmoud, Ahmed Y. and Bdair, Ramiz A. (2017). Information Security Policies and their Relationship with the Effectiveness of the Management Information Systems of Major Palestinian Universities in the Gaza Strip, International Journal of Information Science and Management, vol 15:1, pp. 126. [54] Anderson, J.R., A.T. Corbett, K.R. Koedinger and R. Pelletier, 1995. Cognitive tutors: Lessons learned. J. Learn. Sci., 4: 167-207. [55] Arnow, D. and O. Barshay, 1999. WebToTeach: An interactive focused programming exercise system. Proc. Annu. Frontiers Educ. Conf., 1: 12A9/39 12A9/44 [56] Carbonell, J., 1970. AI in CAI: An artificial-intelligence approach to computer- [57] Clancey, W., 1984. Methodology for Building an Intelligent Tutoring System. In: Methods and Tactics in Cognitive Sciences, Kintsch, W., J.R. Miller and P.G. Polson (Eds.). Lawrence Erlbaum Associates, Hillsdale, New Jersey, London, pp: 51-84 [58] Fournier-Viger, P., R. Nkambou and E. Mephu, 2010. Building Intelligent Tutoring Systems for Ill-Defined Domains. In: Advances in Intelligent Tutoring Systems, Nkambou, R., R. Mizoguchi, and J. Bourdeau (Eds.). Springer-Verlag, Berlin, Heidelberg, pp: 81-101. [59] Kashy, E., B.M. Sherrill, Y. Tsai, D. Thaler, D. Weinshank, M. Engelmann and D.J. Morrissey, 1993. CAPA-An integrated computer-assisted personalized assignment system. Am. J. Phys., 61: 1124-1130. [60] Kashy, E., M. Thoennessen, Y. Tsai, N.E. Davis and S.L. Wolfe, 1997. Using networked tools to enhance student success rates in large classes. Proc. Annu. Frontiers Educ. Conf. Teach. Learn. Era Change, 1: 233237 [61] Lelouche, R., 1999. Intelligent tutoring systems from birth to now. Kunstliche Intelligenz, 13: 5-11. [62] Tang, Y., 2005. Qualitative reasoning and articulate software. Inform. Technol. J., 4: 184-188. [63] Daniel Liang, Y., 2010, Introduction to Java Programming, Comprehensive (8th Edition), Prentice Hall. [64] Deitel, P. and H. Deitel, 2009, Java How to Program: Early Objects Version (8th Edition), Prentice Hall.