Skip to main content

2016 | OriginalPaper | Buchkapitel

Database Engineering Game

verfasst von : Markus Siepermann

Erschienen in: Games and Learning Alliance

Verlag: Springer International Publishing

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

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!

Literatur
1.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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)
Metadaten
Titel
Database Engineering Game
verfasst von
Markus Siepermann
Copyright-Jahr
2016
DOI
https://doi.org/10.1007/978-3-319-50182-6_7