Re: Data Model
From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Thu, 02 Mar 2006 15:22:53 -0800
Message-ID: <rhve02lk41e6lrqiha7fqaqb21h9egeghu_at_4ax.com>
Date: Thu, 02 Mar 2006 15:22:53 -0800
Message-ID: <rhve02lk41e6lrqiha7fqaqb21h9egeghu_at_4ax.com>
On 2 Mar 2006 14:56:16 -0800, matthewdavis1980_at_hotmail.com wrote:
>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.
So is your instructor.
Sincerely,
Gene Wirchenko Received on Fri Mar 03 2006 - 00:22:53 CET