Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.dougwise.org!nntpfeed.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.194.247.MISMATCH!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "David Segall" Subject: Designing a structure for Message-ID: X-Comment-To: comp.databases,comp.lang. Newsgroups: comp.lang.java.databases Content-Type: text/plain; charset=IBM437 Content-Transfer-Encoding: 8bit X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92] Lines: 30 Date: Wed, 27 Apr 2011 15:21:23 GMT NNTP-Posting-Host: 96.60.20.240 X-Complaints-To: news@tds.net X-Trace: newsreading01.news.tds.net 1303917683 96.60.20.240 (Wed, 27 Apr 2011 10:21:23 CDT) NNTP-Posting-Date: Wed, 27 Apr 2011 10:21:23 CDT Organization: TDS.net Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:36 To: comp.databases,comp.lang. I have decided to rewrite a couple of applications that use my personal information database and I'm looking for ideas on how to structure a new database for them. For most purposes I want to communicate with a family or business at its "home" address. For example, "Fred and Betty Bloggs" or "Acme Widgets" have a specified street address and telephone number. It is possible that the Bloggs family has a holiday house or I have to deal with Acme Widgets at more than one location. I also need information about individuals such as mobile phone numbers and birthdays but I don't want to duplicate shared home and business addresses and telephone numbers. For example, Betty Bloggs could work for Acme Widgets and share a town house and a country house with Fred. Please ignore any database structure implied in the preceding paragraph. I'm looking for the ideal PIM database structure and you probably understand the requirements better than I do. No doubt you have been frustrated by the address books in many applications that insist you supply all the details for every individual. My excuse for posting in comp.lang.java.databases is that I follow it and the applications will be written in Java and use Derby as the database. I confess that the reason is to canvas a wider audience but I refuse to admit the post is spam. --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24