Skip to main content
Top

2016 | OriginalPaper | Chapter

Database Engineering Game

Author : Markus Siepermann

Published in: Games and Learning Alliance

Publisher: Springer International Publishing

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

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.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference 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)CrossRef 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)CrossRef
2.
go back to reference 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 19 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 19
3.
go back to reference Chen, P.P.S.: The entity-relationship model—toward a unified view of data. ACM Trans. Database Syst. (TODS) 1(1), 9–36 (1976)CrossRef Chen, P.P.S.: The entity-relationship model—toward a unified view of data. ACM Trans. Database Syst. (TODS) 1(1), 9–36 (1976)CrossRef
4.
go back to reference Cigas, J., Kushan, B.: Experiences with online SQL environments. J. Comput. Sci. Coll. 25(5), 251–257 (2010) Cigas, J., Kushan, B.: Experiences with online SQL environments. J. Comput. Sci. Coll. 25(5), 251–257 (2010)
5.
go back to reference Date, C.J.: An Introduction to Database Systems, 8th edn. Addison-Wesley Educational Publishers Inc., Reading (2003)MATH Date, C.J.: An Introduction to Database Systems, 8th edn. Addison-Wesley Educational Publishers Inc., Reading (2003)MATH
6.
go back to reference 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) 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)
7.
go back to reference Dietrich, S.W., Eckert, E., Piscator, K.: WinRDBI: a windows-based relational database educational tool. ACM SIGCSE Bull. 29(1), 126–130 (1997)CrossRef Dietrich, S.W., Eckert, E., Piscator, K.: WinRDBI: a windows-based relational database educational tool. ACM SIGCSE Bull. 29(1), 126–130 (1997)CrossRef
8.
go back to reference Ferstl, O.K., Sinz, E.J.: Grundlagen der Wirtschaftsinformatik. Band 1, 7. Aufl., De Gruyter Oldenbourg, München (2013) Ferstl, O.K., Sinz, E.J.: Grundlagen der Wirtschaftsinformatik. Band 1, 7. Aufl., De Gruyter Oldenbourg, München (2013)
9.
go back to reference 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) 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)
10.
go back to reference 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) 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)
11.
go back to reference 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) 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)
13.
go back to reference Mitrovic, A.: An intelligent SQL tutor on the web. Int. J. Artif. Intell. Educ. 13(2), 173–197 (2003) Mitrovic, A.: An intelligent SQL tutor on the web. Int. J. Artif. Intell. Educ. 13(2), 173–197 (2003)
14.
go back to reference 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 CrossRef 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 CrossRef
15.
go back to reference Prior, J., Lister, R.: The backwash effect on SQL skills grading. In: Proceedings of ITiCSE 2004, Leeds, UK, pp. 32–36 (2004) Prior, J., Lister, R.: The backwash effect on SQL skills grading. In: Proceedings of ITiCSE 2004, Leeds, UK, pp. 32–36 (2004)
16.
go back to reference Rob, P., Coronel, C., Morris, S.: Database Systems - Design, Implementation, and Management, 10th edn. Cengage Learning, Boston (2012)MATH Rob, P., Coronel, C., Morris, S.: Database Systems - Design, Implementation, and Management, 10th edn. Cengage Learning, Boston (2012)MATH
17.
go back to reference Sadiq, S., Orlowska, M., Sadiq, W., Lin, J.: SQLator: an online SQL learning workbench. ACM SIGCSE Bull. 36(3), 223–227 (2004)CrossRef Sadiq, S., Orlowska, M., Sadiq, W., Lin, J.: SQLator: an online SQL learning workbench. ACM SIGCSE Bull. 36(3), 223–227 (2004)CrossRef
18.
go back to reference 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) 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)
19.
go back to reference 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) 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)
20.
go back to reference Thomas, P.: Grading diagrams automatically. Technical report, Computing Department, Open University, UK (2003) Thomas, P.: Grading diagrams automatically. Technical report, Computing Department, Open University, UK (2003)
21.
go back to reference Thomas, P., Smith, N., Waugh, K.: Automatic assessment of sequence diagrams. In: 12th International CAA Conference: Research into e-Assessment, Loughborough University, UK (2008) Thomas, P., Smith, N., Waugh, K.: Automatic assessment of sequence diagrams. In: 12th International CAA Conference: Research into e-Assessment, Loughborough University, UK (2008)
22.
go back to reference 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) 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)
23.
go back to reference 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) 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)
25.
go back to reference 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) 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)
Metadata
Title
Database Engineering Game
Author
Markus Siepermann
Copyright Year
2016
DOI
https://doi.org/10.1007/978-3-319-50182-6_7

Premium Partner