[Smp-developers] Some Ideas

[Jeff W. <jef...@ha...>]

Hi Andreas and James

I have some ideas for this project and just wanted to give you both the =
information I have collected over the last 13 years supporting Student =
Administration Systems

1.  A school admin system has to work as a Standalone (one PC), LAN ( =
Network within a School), WAN ( Wide Area - Across a state or country).

2.  Some unusual things to consider.  A school may be on one site or on =
many sites ie ( main site and one on the other side of the town).

3.  People (staff) may work at many schools and still need to access =
data at their other schools.

4.  The system may be used by a state school system where the data needs =
to be centralised, or in a region.


Here is what I believe is needed.

Each table will need to have a field that identifies a unique ID for the =
site.  A simple example is for the students name.

site id:  0678
Student id: 1234567890
Student name: Williams
Given: Jeffrey
Preferred: Jeff

I look forward to any comments.

regards

Jeff