DB-Coach

Backend | Frontend | Team

Project name: DB-Coach
Client: University of Applied Sciences Kaiserslautern
Technologies: Docker, Vue.js, Spring, Ajax, Maven
Languages: Java, Javascript, HTML, CSS

During my studies at the University of Applied Sciences Kaiserslautern, I had a student job at the faculty of Computer Sciences and Microsystems Technology. Along with other students and my professor, Prof. Dr. Bastian Beggel, I worked on a web application that allowed students to learn SQL. The application allowed students to solve exercises that contained ‚SELECT‘, ‚CREATE TABLE‘, ‚UPDATE‘, and ‚DELETE‘ statements. A bonus point and achievement system were implemented to motivate students to complete their exercises.

The DB-Coach is a single-page application programmed with Vue.js and a Java backend based on the Spring framework

I developed the following parts of the project:

Achievement and bonus point system (backend)
Automatic achievement description generator (backend)
Global achievement ranking between users (backend)
Achievement editor (frontend & backend)
Exercise, scenario, and group editor
User request WebSocket refactoring
Vue-router for exercises
Exam evaluation system (including encryption of all data that belongs to an exam and decryption per password)
Query-rule system to ensure that students couldn’t solve specific exercises using another method than the expected one (backend)
External registration and verification system (frontend & backend)
Create table exercises (backend)
Performance improvements by delegating multiple tasks to different threads (backend)

Images:

Links & downloads:
DBCoach: click