Introduction and Goals#

Requirements Overview#

What is SQL-Train?#

  • SQL-Train is a web-based tool for practicing SQL statements in your own database.

  • It serves as an easily accessible means of expanding your own knowledge in the field of databases.

  • As a replacement for the older System “repDB”, it strives to it improve on the concept of its predecessor.

Essential Features:#

  • User friendly interface

  • Open Source

  • Extensibility

  • Internationalization

  • Automatic checking of all SQL-Statement-Types

  • Maintainable

Quality Goals#

Quality Goal

Motivation and explanation

Didactic Value

Building upon the highly beneficial concept of RepDB, SQL Train aims to enhance and improve upon this concept.

User-friendly UI

For motivating students a modern and nice user interface is highly important.

Quick Responses

The Website has to respond quickly to any User operation.

Easy Login

As opposed to its predecessor, we want to simplify authentication while also staying secure.

Internationalization

For other universities and English-speaking students in Augsburg we strive to use i18n.

Straightforward Deployment

The deployment should be possible for all universities

Security

Security is crucial to protect sensitive data and maintain the privacy of users.

Maintainability

As this project is later handed over to Mr. Kolonko it needs to be easily maintainable.

Accessibility

SQL-Train should be designed to be accessible to users with disabilities, adhering to accessibility guidelines and standards.

Stakeholders#

Role/Name

Contact

Expectations

project supervisor

Prof. Matthias Kolonko

Modern SQL learning tool to use in parallel with the lecture

Developer

-

Interesting project for intensifying web development and project working skills

Students

-

Easy to use platform for practising SQL

Extern Lecturers

-

Easy integration of the Tool in their lecture and university