Data Model
From: <matthewdavis1980_at_hotmail.com>
Date: 2 Mar 2006 14:56:16 -0800
Message-ID: <1141340176.804681.132300_at_v46g2000cwv.googlegroups.com>
I have a situation:
Date: 2 Mar 2006 14:56:16 -0800
Message-ID: <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. Received on Thu Mar 02 2006 - 23:56:16 CET