摘要 |
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.
|