Kriativ-tech Volume 1, Issue 7, April 2018, Pages: xxx Received: Dec. 28, 2019; Accepted: Feb. 25, 2020. Published: Jul. 30, 2020.


João Carneiro , Assistant Professor at ISTEC



To cite this article

João Carneiro, A Review on Tools for Teaching Database Systems Online DOI: 10.31112/kriativ-tech-2020-08-42


Database Systems is a core discipline in undergraduate Computer Science and Engineering programs. The discipline includes learning a large range of different theoretical and practical topics such as data modeling, database design or SQL. Studies have identified that students find the topic complex and have difficulties in learning such topics in traditional face-to-face setting. This article presents state-of-the-art tools that are found in the literature and how they could be used to overcome some of the existing difficulties.


Online Learning, Learning Database Systems, Database Tools


[1]Connolly, T., & Begg, C. (2006). A constructivist-based approach to teaching database analysis and design. Journal of Information Systems Education, 17(1), 43.[2]Douglas, D. E., & Van Der Vyver, G. (2004). Effectiveness of E-learning course materials for learning database management systems: An experimental investigation. Journal of Computer Information Systems, 44(4), 41–48.[3]Davis, K. C. (2018). Teaching Physical Database Design. Lecture Notes in Computer Science (Including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). doi: 10.1007/978-3-030-01391-2_22[4]Topi, H., Valacich, J. S., Wright, R. T., Kaiser, K., Nunamaker, J. F., Sipior, J. C., & de Vreede, G. J. (2010). IS 2010: Curriculum guidelines for undergraduate degree programs in information systems. Communications of the Association for Information Systems. doi: 10.17705/1cais.02618[5]Fang, A., Chen, G., Cai, Z., Cui, L., Harn, L. (2017). Research on Blending Learning Flipped Class Model in Colleges and Universities Based on Computational Thinking — “Database Principles” for Example. Eurasia Journal of Mathematics, Science and Technology Education, 13(8), 5747-5755.[6] Murray, M., & Guimaraes, M. (2009). Animated Courseware Support for Teaching Database Design. Issues in Informing Science & Information Technology, 6, 201-211.[7] Connolly, T., & Begg, C,. (2007). Teaching Database Analysis and Design in a Web Based Constructivist Learning Environment. Web Information Systems and Technologies, 343-354. doi: 10.1007/978-3-540-74063-6_27[8] Cavus, N. (2015). Distance Learning and Learning Management Systems. Procedia – Social and Behavioral Sciences, 191, 872-877.[9]Yining Chen, Hao Lou & Wenhong Luo (2002) Distance Learning Technology Adoption: A Motivation Perspective, Journal of Computer Information Systems, 42:2, 38-43. doi: 10.1080/08874417.2002.11647485[10] Boling, E. C., Hough, M., Krinsky, H., Saleem, H., & Stevens, M. (2012). Cutting the distance in distance education: Perspectives on what promotes online learning experiences. Internet and Higher Education, 15, 118–126. doi: 10.1016/j.iheduc.2011.11.006[11] Napier, N. P., Dekhane, S., & Smith, S. (2011). Transitioning to blended learning: Understanding student and faculty perceptions. Journal of Asynchronous Learning Networks, 15(1), 20–32.[12] Schmidt, S. W., Tschida, C. M., & Hodge, E. M. (2016). How faculty learn to teach online: What administrators need to know. Online Journal of Distance Learning Administration.[13] Gregory, J., & Salmon, G. (2013). Professional development for online university teaching. Distance Education, 34(3), 256–270. doi: 10.1080/01587919.2013.835771[14] Jaques, D., & Salmon, G. (2007). Learning in groups: A handbook for face-to-face and online environments. Abingdon, UK: Routledge.[15] Kirkwood, A., & Price, L. (2014). Technology-enhanced learning and teaching in higher education: What is ‘enhanced’ and how do we know? A critical literature review. Learning, Media and Technology, 39(1), 6–36. doi:10.1080/17439884.2013.770404[16]Gillett-Swan, J. (2017). The Challenges of Online Learning: Supporting and Engaging the Isolated Learner. Journal of Learning Design. doi: 10.5204/jld.v9i3.293[17] Rashid, T. (2015). Investigation of Instructing Reforms in Databases. International Journal of Scientific & Engineering Research, 6(8), 64-72.[18] Mason, R., Seton, C., & Cooper, G. (2016). Applying cognitive load theory to the redesign of a conventional database systems course. Computer Science Education, 1-20. doi: 10.1080/08993408.2016.1160597.[19] Saeed, S., Aamir, R., & Mahmood, Z. (2011). Reflections on teaching database management systems to undergraduate students. International Journal of Education Economics and Development, 2(4), 398– 411. doi: 10.1504/IJEED.2011.043834[20] Dunn, D. (2005). Database Systems and Oracle: Experiences and Lessons Learned. Proceedings of the 2005 ASCUE Conference, 99-104.[21] Ying, F. (2016). Research on Blended Learning Mode Based on the Micro-Lecture in Database Application. Review Of Computer Engineering Studies, 3(3), 62-66.[22] Wang, N., & Ma, C. (2017). Teaching Reform on Database Course for Science Laboratory Class. The 12th International Conference on Computer Science & Education (ICCSE 2017) August 22-25 , 2017, University of Houston, USA.[23] Rashid, T., & AlRadhy, R. (2014). Transformations to Issues in Teaching, Learning, and Assessing Methods in Databases Courses. 2014 IEEE International Conference on Teaching, Assessment and Learning for Engineering (TALE).[24] Folorunso, O., & Akinwale, A. (2010). Developing Visualization Support System For Teaching/Learning Database Normalization. Campus-Wide Information Systems, 27 (1), 25 – 39. doi: 10.11 08/10650741011011264[25] Poščić, P., Subotić, D., & IvašićKos, M. (2012). Developing the course Database systems to respond to market requirements. 2012 Proceedings of the 35th International Convention MIPRO.[26] Wang, J., & Chen, H. (2014).Research and Practice on the Teaching Reform of Database Course. International Conference on Education Reform and Modern Management, 229-231.[27] Cvetanovic, M., Radivojevic, Z., Blagojevic, V., & Bojovic, M. (2011). ADVICE— Educational System for Teaching Database Courses. IEEE Transactions On Education, 54(3), 398-409. doi: 10.1109/TE.2010.2063431[28] Mitrovic, A., & Suraweera, P. (2015). Teaching Database Design with Constraint-Based Tutors. International Artificial Intelligence in Education Society, 26(1), 448-456. doi: 10.1007/s40593-0150084-6[29] Sok, S., & Scharff, C. (2006). Work in Progress: Database Design With TabletERD. 36th ASEE/IEEE Frontiers in Education Conference, 2006, M2F-19.[30] Wang, J., Davis, T., Westall, M., & Srimani, P. (2009). Work in Progress - MeTube: A Novel way to teach Database to Undergraduates. 39th ASEE/IEEE Frontiers in Education Conference T2C-1.[31]Fang, A. D., Chen, G. L., Cai, Z. R., Cui, L., & Harn, L. (2017). Research on blending learning flipped class model in colleges and universities based on computational thinking - “Database principles” for example. Eurasia Journal of Mathematics, Science and Technology Education, 13(8), 5747–5755. doi: 10.12973/eurasia.2017.01024a[32]Martinez, A. (2012). Using JiTT in a Database Course. SIGCSE’12.