D
Dorian
I've been wrestling with this design for a while and would appreciate some
input.
This is a database that handles audits of determinations made by remote
offices.
Each year, a new review series is set up to audit several sites.
Each review series targets up to 3 areas of determinations (e.g. citizenship
or income level). So for each review in the series the target areas are
predetermined.
Each individual review relates to a review series and to a site.
Each review handles the 1-3 target areas and each target area has a number
of cases (determinations about individual people). Each target area may have
different cases or the same cases.
The question is: do I have reviews related to cases and then cases related
to target areas or do I have reviews related to target areas and then target
areas related to cases?
Also, since the review series predetermines the target areas, how do I
relate the target areas to reviews. I need to keep several data items
relating to a case separated out by target area.
If it makes any difference, the users say that when conducting a review they
process by case and audit each target area for that case before moving on to
the next case.
I'm trying to normalize this but will happily denormalize if it make the
application easier to develop.
Thanks for any input.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
input.
This is a database that handles audits of determinations made by remote
offices.
Each year, a new review series is set up to audit several sites.
Each review series targets up to 3 areas of determinations (e.g. citizenship
or income level). So for each review in the series the target areas are
predetermined.
Each individual review relates to a review series and to a site.
Each review handles the 1-3 target areas and each target area has a number
of cases (determinations about individual people). Each target area may have
different cases or the same cases.
The question is: do I have reviews related to cases and then cases related
to target areas or do I have reviews related to target areas and then target
areas related to cases?
Also, since the review series predetermines the target areas, how do I
relate the target areas to reviews. I need to keep several data items
relating to a case separated out by target area.
If it makes any difference, the users say that when conducting a review they
process by case and audit each target area for that case before moving on to
the next case.
I'm trying to normalize this but will happily denormalize if it make the
application easier to develop.
Thanks for any input.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".