Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > Designing a str...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 29 Topic 3147 of 3212
Post > Topic >>

Designing a structure for a personal database

by David Segall <david@[EMAIL PROTECTED] > Apr 26, 2008 at 02:33 PM

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.
 




 29 Posts in Topic:
Designing a structure for a personal database
David Segall <david@[E  2008-04-26 14:33:00 
Re: Designing a structure for a personal database
Ed Prochak <edprochak@  2008-04-28 05:46:06 
Re: Designing a structure for a personal database
David Segall <david@[E  2008-04-28 18:33:58 
Re: Designing a structure for a personal database
Martin Gregorie <marti  2008-04-28 21:01:13 
Re: Designing a structure for a personal database
David Segall <david@[E  2008-04-29 13:35:54 
Re: Designing a structure for a personal database
"Arved Sandstrom&quo  2008-04-30 19:25:17 
Re: Designing a structure for a personal database
Ed Prochak <edprochak@  2008-04-30 10:21:09 
Re: Designing a structure for a personal database
David Segall <david@[E  2008-05-02 15:06:55 
Re: Designing a structure for a personal database
Lew <lew@[EMAIL PROTEC  2008-05-02 20:45:39 
Re: Designing a structure for a personal database
David Segall <david@[E  2008-05-03 12:59:57 
Re: Designing a structure for a personal database
"David Cressey"  2008-05-03 13:42:09 
Re: Designing a structure for a personal database
David Segall <david@[E  2008-05-03 15:59:18 
Re: Designing a structure for a personal database
Lew <lew@[EMAIL PROTEC  2008-05-03 09:57:13 
Re: Designing a structure for a personal database
David Segall <david@[E  2008-05-07 15:53:35 
Re: Designing a structure for a personal database
Lew <lew@[EMAIL PROTEC  2008-05-07 19:54:49 
Re: Designing a structure for a personal database
David Segall <david@[E  2008-05-09 08:36:55 
Re: Designing a structure for a personal database
Gene Wirchenko <genew@  2008-05-04 17:45:01 
Re: Designing a structure for a personal database
Roedy Green <see_websi  2008-05-08 19:25:07 
Re: Designing a structure for a personal database
Ed Prochak <edprochak@  2008-04-30 10:27:53 
Re: Designing a structure for a personal database
Ed Prochak <edprochak@  2008-05-07 11:06:18 
Re: Designing a structure for a personal database
ram@[EMAIL PROTECTED] (S  2008-05-03 16:09:12 
Re: Designing a structure for a personal database
"Arved Sandstrom&quo  2008-05-05 13:46:03 
Re: Designing a structure for a personal database
ram@[EMAIL PROTECTED] (S  2008-05-05 14:00:17 
Re: Designing a structure for a personal database
"Arved Sandstrom&quo  2008-05-05 15:50:20 
Re: Designing a structure for a personal database
Lew <lew@[EMAIL PROTEC  2008-05-05 20:14:54 
Re: Designing a structure for a personal database
David Segall <david@[E  2008-05-06 15:22:07 
Re: Designing a structure for a personal database
Marco <zakmck@[EMAIL P  2008-05-07 07:46:12 
Re: Designing a structure for a personal database
Arved Sandstrom <asand  2008-05-08 12:13:34 
Re: Designing a structure for a personal database
Marco <zakmck@[EMAIL P  2008-05-06 02:12:43 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Tue Jul 8 22:51:13 CDT 2008.