Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xt-sjc-15!sn-xt-sjc-09!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Gene Wirchenko Newsgroups: comp.databases.theory Subject: Re: Data Model Date: Thu, 02 Mar 2006 15:22:53 -0800 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: Gene Wirchenko References: <1141340176.804681.132300@v46g2000cwv.googlegroups.com> X-Newsreader: Forte Free Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 22 Xref: dp-news.maxwell.syr.edu comp.databases.theory:37146 On 2 Mar 2006 14:56:16 -0800, matthewdavis1980@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