Data Model

From: <matthewdavis1980_at_hotmail.com>
Date: 2 Mar 2006 14:56:16 -0800
Message-ID: <1141340176.804681.132300@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 - 16:56:16 CST