Re: Data Model

<matthewdavis1980_at_hotmail.com> wrote in message news:1141340176.804681.132300_at_v46g2000cwv.googlegroups.com...
> I have a situation:
>
> There are many Judges.
> There are many Buildings.
> There are many Locations inside buildings( such as floors ).
> Each judge must reside at exactly one location.
> A staff member has a name, phone number, and email.
> Each judge has 6 staff members, one of each type: Clerk, Assistant
> Clerk, Coordinator, Bailiff, and Court Reporter.
>
> How would you model this scenario?
>
> Thanks, I'm looking forward to seeing the different results.
>

I'll cut you a little slack, and believe you when you insist that this is NOT an academic exercise.

First, go to www.databaseanswers.org and see if there's a model in there for court scheduling.

Second, the above "scenario" doesn't say what the data is for. The above sets the scene, but dioesn't really state the scenario. I apologize for nitpicking about language, but I think the distinction is worth it in this case.

Third, I have seen a package sold for this sort of thing, and it uses SQL Server to make the data permanent. This package, when I looked at it, had made the logical structure of the data so opaque that trying to use the data for another purpose, via SQL server, was worse than hopeless. I didn't bid.

Fourth, why do you want to use a database? Are you trying to solve a problem that files won't solve? Received on Fri Mar 03 2006 - 21:22:28 CET