Email me if you would like an Access Database.
The Specifications have been drafted.
This Data Model is based on the typical Life Cycle of a Student.
The first thing a Student does is to register at a School, then sign up for Classes, followed by completion of Assignments, taking Exams and finally leaving the Schoool (or transferring) and taking his or her Transcripts.
The way in which these separate Models are related is defined in the Information Catalog.
A Data Mart might be created to help with Enquiries and Reports.
Wikipedia has very interesting articles on a
Student Information System
a Schools_Interoperability_Framework (SIF) which has been established to help in exchanging data through a standard approach to Student Information.
The SIF has been implemented in the United States, for example in Wyoming, which has launched the
WISE Project, to "collect, certify, and transform school district data into standardized data sets".
It is increasingly being implemented in the Australia, India, UK and elsewhere.
Visual Software, with offices in the USA, the UK and Australia, is one of the companies playing a significant role in advancing the adoption of SIF.
This is a very simple and flexible 'Kick Start' Data Model.
Separate Data Models have been designed for each of these activities :-
Athletes and Teams
Registration (with Parents and Guardians)