search

Bonfire / OptiGrader

OptiGrader is an optical mark recognition (OMR) application that serves as both a scantron grader and an online gradebook.
http://opti-grade.to.us/
13 stars 7 forks source link

Design Database #1

Open rsbmatt opened 6 years ago

anisomorphic commented 6 years ago

create.txt erd_v1

anisomorphic commented 6 years ago

v1 of the simplified database

anisomorphic commented 6 years ago

erd_v2 create.txt

anisomorphic commented 6 years ago

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

anisomorphic commented 6 years ago

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

anisomorphic commented 6 years ago

create.txt erd

anisomorphic commented 6 years ago

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

anisomorphic commented 6 years ago

create.txt erd

anisomorphic commented 6 years ago

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 commented 6 years ago

erd create.txt test data.txt