Re: Data Model

<
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?
>

With a lot of questions:

May two staff members have the same name ? May two staff members have the same phone number ? May two staff members have the same email? What identifies a staff member ? Social Security Number, State Employment ID ?

May a staff member not have a phone ? e.g. waiting for a phone to be installed or not yet known.
Same for question for staff email.

May a staff member exist that is not assigned to a judge ? May a staff member be shared between two judges ?

What are the attributes for Judges - do they have a name ? Phone ? email ?

When a Judge is no longer active (retires or not re-elected) , what happens to the staff ? Are they all assigned to the replacement Judge ?

Do you need a history of what staff members worked for what judge. Senario: Assistant Clerk is promoted to Clerk and is assigned to a new Judge. Do you need to know when they stopped working for the old judge ?

Is there a concept of Courts ? see
http://www.justex.net/civil/civilcrt/civil.htm

Are the Court Types ? Civil, Criminal, Family ...

Are staff assigned to Courts or to Judges ? Received on Fri Mar 03 2006 - 18:41:49 CST