What are you looking for today?

Nelson, David, McGarry, Kenneth and Proud, Mark (2023) USING ORACLE QUERY PLAN FOR AUTOMATED ASSESSMENT OF SQL. In: 17th International Technology, Education and Development Conference, 6-8 March 2023, Valencia, Spain.

Document

Abstract

Official URL: https://iated.org/inted/

Abstract

In our second-year undergraduate database foundations module students are exposed to using the Oracle cloud environment for developing SQL (Structured Query Language) queries. Their first summative assessment for the module is of a problem-solving nature, whereby they are expected to repair a partially developed SQL schema for a given scenario, before subsequently developing SQL queries based on the scenario. Marking this work can be laborious, error prone and time consuming, as well as requiring multiple sample solutions for each query which cater for all potential solutions that the students could produce. The aim of this paper is therefore to describe an early-stage prototype automated assessment system for marking the SQL queries developed by the students.

Item Type: Conference or Workshop Item (Paper)
Additional Information: Extended abstract was accepted and referred. Document uploaded is final submitted version.
Uncontrolled Keywords: SQL, automated marking, assessment
Related URLs:
Depositing User: David Nelson
URI: https://sure.sunderland.ac.uk/id/eprint/15882

Further Details

More Information

Additional Information
Extended abstract was accepted and referred. Document uploaded is final submitted version.
Uncontrolled Keywords
SQL, automated marking, assessment
Depositing User

Identifiers

Item ID
15882

Users with ORCIDS

ORCID for David Nelson
ORCID for Kenneth McGarry

Catalogue record

Date Deposited
03 Apr 2023 12:52
Last Modified
04 Jun 2025 14:58

Actions (login required)

View Item (Repository Staff Only)

Downloads per month over past year