Show simple item record

dc.contributor.authorStanger, Nigel
dc.contributor.editorYang, Jie Chi
dc.contributor.editorChang, Maiga
dc.contributor.editorWong, Lung-Hsiang
dc.contributor.editorRodrigo, Ma. Mercedes T.
dc.date.available2019-10-21T20:20:33Z
dc.date.copyright2018-11-24
dc.identifier.citationStanger, N. (2018). Semi-automated assessment of SQL schemas via database unit testing. In J. C. Yang, M. Chang, L.-H. Wong, & M. M. T. Rodrigo (Eds.), Proceeedings of the 26th International Conference on Computers in Education (ICCE 2018) (pp. 237–246). Presented at the International Conference on Computers in Education (ICCE), Asia-Pacific Society for Computers in Education (APSCE).en
dc.identifier.isbn978-98694012-8-9
dc.identifier.urihttp://hdl.handle.net/10523/9694
dc.description.abstractA key skill for students learning relational database concepts is how to design and implement a database schema in SQL. This skill is often tested in an assignment where students derive a schema from a natural language specification. Grading of such assignments can be complex and time consuming, and novice database students often lack the skills to evaluate whether their implementation accurately reflects the specified requirements. In this paper we describe a novel semi-automated system for grading student-created SQL schemas, based on a unit testing model. The system verifies whether a schema conforms to a machine-readable specification and runs in two modes: a staff mode for grading, and a reduced functionality student mode that enables students to check that their schema meets specified minimum requirements. Analysis of student performance over the period this system was in use shows evidence of improved grades as a result of students using the system.en_NZ
dc.format.mimetypeapplication/pdf
dc.language.isoenen_NZ
dc.publisherAsia-Pacific Society for Computers in Education (APSCE)en_NZ
dc.relation.ispartofProceeedings of the 26th International Conference on Computers in Education (ICCE 2018)en_NZ
dc.subjectautomated assessmenten_NZ
dc.subjectSQLen_NZ
dc.subjectdatabase schemaen_NZ
dc.subjectdata definition language (DDL)en_NZ
dc.subjectstudent performanceen_NZ
dc.subjectunit testingen_NZ
dc.titleSemi-automated assessment of SQL schemas via database unit testingen_NZ
dc.typeConference or Workshop Item (Paper published in proceedings)en_NZ
dc.date.updated2019-10-20T23:49:10Z
otago.schoolInformation Scienceen_NZ
otago.bitstream.endpage246en_NZ
otago.bitstream.startpage237en_NZ
otago.openaccessOpenen_NZ
dc.rights.statementCopyright 2018 Asia-Pacific Society for Computers in Education. All rights reserved. No part of this book may be reproduced, stored in a retrieval system, transmitted, in any forms or any means, without the prior permission of the Asia-Pacific Society for Computers in Education. Individual papers may be uploaded on to institutional repositories or other academic sites for self-archival purposes.en_NZ
dc.description.refereedPeer Revieweden_NZ
otago.event.placeManila, Philippinesen_NZ
otago.event.titleInternational Conference on Computers in Education (ICCE)en_NZ
 Find in your library

Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record