A denormalized database has a master student table having records containing
fields
last name, first name and a unique identifier corresponding to each student, related
data tables linked to the master student table have records containing a field
having the unique identifier, and test results tables individually linking the
master student table having test results for each student and a unique identifier.
Related data tables may link through the linking table to the master student table
via a concatenated identification code corresponding to each student identification
code. A special student table containing historical data of all entries, a status
data table/field having fields containing enrollment status and the unique identifier
code. Primary no-duplication keys operate to indicate that a table having such
a key will accept only unique new entries. Related data tables may be linked through
an intermediate linking table having a field containing a concatenated identification
code corresponding to each student identification code and linked to another related
data table.
