Advertisement

Database Engineering Game

  • Markus SiepermannEmail author
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 10056)

Abstract

Database engineering consists of several tasks like database modelling and SQL. Usually, these tasks are taught and practiced separately. This paper presents a game based e-learning system that combines these tasks of database engineering so that students can experience the later consequences of their work in earlier steps. Several tools are provided that check the students’ solutions and give hints what is done well and what has to be improved.

Keywords

Database engineering Data modelling SQL 

References

  1. 1.
    Brusilovsky, P., Sosnovsky, S., Lee, D.H., Yudelson, M., Zadorozhny, V., Zhou, X.: An open integrated exploratorium for database courses. ACM SIGCSE Bull. 40(3), 22–26 (2008)CrossRefGoogle Scholar
  2. 2.
    Brusilovsky, P., Sosnovsky, S., Yudelson, M.V., Lee, D.H., Zadorozhny, V., Zhou, X.: Learning SQL programming with interactive tools: from integration to personalization. ACM Trans. Comput. Educ. TOCE, 9(4) (2010). Article 19Google Scholar
  3. 3.
    Chen, P.P.S.: The entity-relationship model—toward a unified view of data. ACM Trans. Database Syst. (TODS) 1(1), 9–36 (1976)CrossRefGoogle Scholar
  4. 4.
    Cigas, J., Kushan, B.: Experiences with online SQL environments. J. Comput. Sci. Coll. 25(5), 251–257 (2010)Google Scholar
  5. 5.
    Date, C.J.: An Introduction to Database Systems, 8th edn. Addison-Wesley Educational Publishers Inc., Reading (2003)zbMATHGoogle Scholar
  6. 6.
    Dekeyser, S., de Raadt, M., Lee, T.Y.: Computer assisted assessment of SQL query skills. In: Proceedings of the Eighteenth Conference on Australasian Database, vol. 63, pp. 53–62. Australian Computer Society Inc. (2007)Google Scholar
  7. 7.
    Dietrich, S.W., Eckert, E., Piscator, K.: WinRDBI: a windows-based relational database educational tool. ACM SIGCSE Bull. 29(1), 126–130 (1997)CrossRefGoogle Scholar
  8. 8.
    Ferstl, O.K., Sinz, E.J.: Grundlagen der Wirtschaftsinformatik. Band 1, 7. Aufl., De Gruyter Oldenbourg, München (2013)Google Scholar
  9. 9.
    Grillenberger, A. Brinda, T.: eledSQL: a new web-based learning environment for teaching databases and SQL at secondary school level. In: Proceedings of the 7th Workshop in Primary and Secondary Computing Education. ACM, pp. 101–104 (2012)Google Scholar
  10. 10.
    Kearns, R., Shead, S., Fekete, A.: A teaching system for SQL. In: Proceedings of the 2nd Australasian Conference on Computer Science Education, pp. 224–231. ACM (1997)Google Scholar
  11. 11.
    Kerres, M., Jechle, T.: Didaktische Konzeption des Telelernens. In: Issing, L.J., Klimsa, P. (eds.) Information und Lernen mit Multimedia und Internet, pp. 267–281. BeltzPVU, Weinheim (2002)Google Scholar
  12. 12.
    Mitrovic, A.: Learning SQL with a computerized tutor. ACM SIGCSE Bull. 30(1), 307–311 (1998)MathSciNetCrossRefGoogle Scholar
  13. 13.
    Mitrovic, A.: An intelligent SQL tutor on the web. Int. J. Artif. Intell. Educ. 13(2), 173–197 (2003)Google Scholar
  14. 14.
    Prados, F., Boada, I., Soler, J., Poch, J.: A web-based tool for entity-relationship modeling. In: Gavrilova, M., Gervasi, O., Kumar, V., Tan, C.J.K., Taniar, D., Laganá, A., Mun, Y., Choo, H. (eds.) ICCSA 2006. LNCS, vol. 3980, pp. 364–372. Springer, Heidelberg (2006). doi: 10.1007/11751540_39 CrossRefGoogle Scholar
  15. 15.
    Prior, J., Lister, R.: The backwash effect on SQL skills grading. In: Proceedings of ITiCSE 2004, Leeds, UK, pp. 32–36 (2004)Google Scholar
  16. 16.
    Rob, P., Coronel, C., Morris, S.: Database Systems - Design, Implementation, and Management, 10th edn. Cengage Learning, Boston (2012)zbMATHGoogle Scholar
  17. 17.
    Sadiq, S., Orlowska, M., Sadiq, W., Lin, J.: SQLator: an online SQL learning workbench. ACM SIGCSE Bull. 36(3), 223–227 (2004)CrossRefGoogle Scholar
  18. 18.
    Siepermann, M.: Lecture accompanying E-learning exercises with automatic marking. In: Richards, G. (Ed.). Proceedings of E-Learn 2005, Chesapeake, USA, pp. 1750–1755 (2005)Google Scholar
  19. 19.
    Siepermann, M., Lackes, R., Börgermann, C.: Using model checking to automatically mark graphical E-learning exercises. In: Luca, J.; Weippl, E.R. (Eds.), Proceedings of ED-MEDIA 2008 World Conference on Educational Media, Multimedia, Hypermedia and Telecommunications, Chesapeake, pp. 5302–5307 (2008)Google Scholar
  20. 20.
    Thomas, P.: Grading diagrams automatically. Technical report, Computing Department, Open University, UK (2003)Google Scholar
  21. 21.
    Thomas, P., Smith, N., Waugh, K.: Automatic assessment of sequence diagrams. In: 12th International CAA Conference: Research into e-Assessment, Loughborough University, UK (2008)Google Scholar
  22. 22.
    Thomas, P., Waugh, K., Smith, N.: Experiments in the automatic marking of ERDiagrams. In: 10th Annual Conference on Innovation and Technology in Computer Science Education, Monte de Caparica, Portugal, pp. 27–29 (2005)Google Scholar
  23. 23.
    Thomas, P., Waugh, K., Smith, N.: Using patterns in the automatic marking of ERDiagrams. In: 11th Annual Conference on Innovation and Technology in Computer Science Education, Bologna, Italy, pp. 26–28 (2006)Google Scholar
  24. 24.
    Tsintsifas, A.: A framework for the computer based assessment of diagram based coursework. Doctoral thesis, Nottingham (2002). http://www.cs.nott.ac.uk/~cah/pdf/azt-phd.pdf
  25. 25.
    Waugh, K., Thomas, P., Smith, N.: Toward the automated assessment of entity-relationship diagrams. In: Second Workshop of the Learning and Teaching Support Network - Information and Computer Science) TLAD (Teaching, Learning and Assessment of Databases), Edinburgh, Scotland (2004)Google Scholar

Copyright information

© Springer International Publishing AG 2016

Authors and Affiliations

  1. 1.Technische Universität DortmundDortmundGermany

Personalised recommendations