SchemaCheck: corretor automático de esquemas SQL.

Abstract

Fix and provide feedback on created SQL schemas by students of database courses can be a process long and arduous for teachers. This is due to the complexity schemas, which can be written in different ways, even with a roadmap, which contains the functional requirements on what should be implemented, requiring the teacher to have enough attention during schema correction to identify possible problems or errors in the student's scheme. Furthermore, the criteria for correcting schemes are usually quite specific, requiring the teacher to describe exactly what the student made a mistake in and what could have done better. Thus, it may be difficult for Database course teachers keep pace of delivery of the students' schemes and, consequently - to guarantee that each student receives feedback regarding the scheme created, No delays. In this work, a line application was developed command that aims to be a tool to help correct of the schemes created by the students, based on correction criteria to be defined by the teacher. The application is expected help database course professors with corrections of SQL schemas, making correction more automated and less manual.