Back to the Data Model
The Statement of Requirements from the Users is as follows :-
There are records in Children's Aid, with Cases dating back to 1800's.
This are the Record File Numbering Systems.
Old Case Record Files were numbered with prefixes and all have a corresponding roll number (microfilm).
The various types of Case Record files look something like this :-
-- FH1 through to FH17100
-- YC1 "" YC17000
we also have in the same format
-- WD, IH, BH, etc...
Then we have the files of today (two types - neither of these use prefixes) :-
They both should have Access Autonumber fields as the primary key.
Then the last of the bunch is the Children files, which use a district number followed by a suffix.
This sums up the File numbering systems.
Now we also Need to highlight many other specifics:
-- Role of person
-- Cancelled and correct numbers (files)
-- Workers, branch, date of file opening
-- Flagging of Restriction, scanned, abuse.
User Draft Database contains :-
1) A table for The older files as case number type I used text.
2) A table for Districts (autonumber)
3) A table for FH (autonumber)
4) A childrens table (text)
5) A person table with all the file types on this table (keys)
B. The Things of Interest are :-
C. How are they related ?
C.1 A Children can have zero, one or many ...
4th. December 2004