Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd7cy2so!shaw.ca!elnk-pas-nf1!elnk-nf2-pas!newsfeed.earthlink.net!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!peernews3.colt.net!newsfeed.stueberl.de!peer01.cox.net!cox.net!border3.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.golden.net!news.golden.net.POSTED!not-for-mail NNTP-Posting-Date: Tue, 11 Nov 2003 16:00:54 -0600 From: "Bob Badour" Newsgroups: comp.databases.theory References: Subject: Re: LM structure question Date: Tue, 11 Nov 2003 17:00:19 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Lines: 20 NNTP-Posting-Host: 207.35.145.168 X-Trace: sv3-69iw59qLmU3Inkcu/DiiTE8CFDq4vwG3WGBrCCSrzEala1P2CXSECvyRdYC1BoyDtrGeA5stfJcLjOh!lAbvCg8E5C3PNFodK/b/OZiGTCJMv60y2E2PnDxANC8cMZatekzlfZ/wxRljn7T0S22Pm/DzVw== X-Complaints-To: abuse@golden.net X-DMCA-Complaints-To: abuse@golden.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Xref: newssvr20.news.prodigy.com comp.databases.theory:22641 "Lee Johnson" wrote in message news:Tjcsb.28913$jy.5958@clgrps13... > I have a table called MEMBER, VOLUNTEER, DONOR. > > Members coud be volunteers and/or donors or simply a member. Conversely, a > volunteer and/or donor does not have to be a member. what is the best way > to structure this? Each item in the table will have phone numbers and > addresses attached to it as well as activities. Would an entity entitled > PERSON which is then identified (not sure how) as being a member and/or a > volunteer and/or a donor be appropriate? keeping in mind of course that a > person who is member and a donor would have things like membership number, a > donor history and such whereas if he was just a donor he would only have a > donor id or something. I suggest you locate a copy of Fabian Pascal's _Practical Issues..._ book and read it.