Skip to main content

Possibilities for Correcting SQL Exercises Automatically

  • Conference paper
  • First Online:
The Impact of the 4th Industrial Revolution on Engineering Education (ICL 2019)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 1135))

Included in the following conference series:

  • 1133 Accesses

Abstract

In this study, we will present a method for evaluating DDL exercises in an exam situation. In relational database systems, we have not just our data in the database but the metadata about our objects as well in so-called data dictionary tables and views. If we give DDL exercises in an exam and students have to run their statements in a system, not just write them, then we can check the objects they made.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 229.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 299.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Baksa-Haskó, G.: Self-correcting test bank for SQL basics, in OGIK 2018 VÁLOGATOTT KÖZLEMÉNYEK, Alexander Alapítvány a Jövő Értelmiségéért (2018)

    Google Scholar 

  2. Date, C.J.: An Introduction to Database Systems, 8th edn. Pearson/Addison Wesley (2004)

    Google Scholar 

  3. Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 6th edn. Addison-Wesley Publishing Company, Boston (2010)

    MATH  Google Scholar 

  4. ISO/IEC JTC 1/SC 32: Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation), The United States of America (ANSI) (2006)

    Google Scholar 

  5. Oracle: Oracle Database Online Documentation 12c Release 1 (12.1). https://docs.oracle.com/database/121/index.htm

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Gabriella Baksa-Haskó .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2020 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Baksa-Haskó, G. (2020). Possibilities for Correcting SQL Exercises Automatically. In: Auer, M., Hortsch, H., Sethakul, P. (eds) The Impact of the 4th Industrial Revolution on Engineering Education. ICL 2019. Advances in Intelligent Systems and Computing, vol 1135. Springer, Cham. https://doi.org/10.1007/978-3-030-40271-6_58

Download citation

Publish with us

Policies and ethics