BorlandTalk.com

Stijn Verrept · Guest

I need to create a program for elderly homes, that has a table with people
in it, and another table with codes.

Some codes happen dayly, some weekly and others monthly. The codes can be
assigned to the people. For example: one code will be for a days stay.
People can check out (for a few days, for example due to hospital transfer)
and back in. At the end of the month I need an overview of all the days
that someone stayed, and of course the other codes.

The program will be a multi-user C/S program.

1) What would be ideal design for something like this?
2) Do I record every day??? (this will create a lot of data and I would
like to keep the databse below 2 GB)
3) Do I only record the entry and exit days? (this will be a lot less data
but it will be more difficult to calculate totals)
4) Where do I do the transfer of one day to the next one? At the end of a
day some of the codes will need to get saved to the people that have them
assigned, this has to be done automatically so I guess it's a bad idea to do
this at client level??? Should I use jobs with stored procedures for this?

Ok that's about it, any input is greatly appreciated. Also if you could
think of some other stuff that could be interested please let me know.

Thanks in advance,

Stijn Verrept.

Stijn Verrept · Guest

Thanks for the reply,
yes but then I will have to do the calculations, because in one month people
can check out and in several times Smile

.

"Dell Stinnett" <my.name (AT) zcsterling (DOT) com> wrote

Eric Hill · Guest