Design Database

[rsbmatt]

No description provided.

[anisomorphic]

v1 of the simplified database

[anisomorphic]

v2 of the simplified database with sessions table, collapsed student+teacher functionality into users table

[anisomorphic]

inserts 2 teachers, 2 tests, and 2 students who have each completed an assessment.
test data.txt

[anisomorphic]

v3 database, complete with history table to store results of each student's test

[anisomorphic]

version 4 of the database, this introduces a courseID field to tests table. introduced courses table to map courseID to a teacher and course name. each teacher will now need to have at least one 'courses' item created and associated when signing up. functionality will need to be added so that teachers can at the very least add another course.

[anisomorphic]

create.txt
test data.txt