Database Answers Puss in Boots (my wife's favorite) comes to the Aid of the Children

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Children's Aid
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) :-
1) FH 
2) Districts

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 :-
B.1 Children


C. How are they related ?
C.1 A Children can have zero, one or many ...


Barry Williams
4th. December 2004
Principal Consultant
Database Answers

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map