School system database

Details School system database School system database

2005-05-24

2005-05-24

Robinson, Greta (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

06898590

ABSTRACT:
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.

REFERENCES:
patent: 5369761 (1994-11-01), Conley et al.
patent: 5615367 (1997-03-01), Bennett et al.
patent: 5991776 (1999-11-01), Bennett et al.
patent: 6505031 (2003-01-01), Slider et al.
patent: 6643493 (2003-11-01), Kilgore
patent: 6651216 (2003-11-01), Sullivan et al.
patent: 6675160 (2004-01-01), Hara et al.
patent: 6685482 (2004-02-01), Hopp et al.
patent: 6688891 (2004-02-01), Sanford

Affiliated with

Also associated with

Rating

School system database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with School system database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and School system database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3391094