System and Context#
Business Context#
C4Context
title SQL-Train Business Context
Person(student, "Student")
System_Ext(lms, "LMS of University", "Moodle")
System(sql-train-server, "SQL-Train-Server")
SystemDb_Ext(pg-stud, "PG-Stud of University", "Database for all students")
System(sql-train-client, "SQL-Train-Client")
Person(lecturer, "Lecturer")
Rel(sql-train-server, pg-stud, "Uses", "host trust")
Rel(student, lms, "Login")
Rel(lms, sql-train-server, "login data")
Rel(student, sql-train-client, "Uses App")
BiRel(sql-train-client, sql-train-server, "")
Rel(sql-train-client, lecturer, "Analytics of course")
Rel(lecturer, sql-train-server, "Creates exercises")
Student (user)#
Students use tool (run queries and check their answers).
Lecturer (admin)#
The Lecturer can add exercises to SQL-Train and get an overview of the students usage of the tool.
LMS (Moodle)#
The LMS has to transmit the pg-stud username of the student.
PG-Stud#
SQL-Train enables the student to directly execute statements on the training server pg-stud, made specifically for the students.
Technical Context#
We have already provided a detailed description of the technical context in the deployment view and have further elaborated on it in the runtime view. Therefore, we will not reiterate that information here.
For security information see the separate section.