| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Data Model
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 Thu Mar 02 2006 - 17:22:53 CST
![]() |
![]() |