Ed Prochak <edprochak@[EMAIL PROTECTED]
> wrote:
>On Apr 28, 2:33 pm, David Segall <da...@[EMAIL PROTECTED]
> wrote:
>> Ed Prochak <edproc...@[EMAIL PROTECTED]
> wrote:
>> >On Apr 26, 9:33 am, David Segall <da...@[EMAIL PROTECTED]
> wrote:
>> >> I'm looking for the ideal PIM database structure and you
>> >> probably understand the requirements better than I do.
>>
>> >Sorry, but my crystal ball has been broken for quite some time. Only
>> >you know the requirements for your project.
>>
>> >Finally, to give you a hint, I would approach this by making
>> >addresses a separate entity, Then both person and business entities
>> >can reference the address entity (e.g. allows a home business) I'll
>> >let your discover the entity you'll need to allow multiple addresses.
>> >(it is not hard.)
>>
>> Thank you for the hint. Your hint indicates that you don't need a
>> crystal ball to understand my requirements and that you may have some
>> useful advice. Why are you so reluctant to give it to me?
>
>There is no ONE TRUE CORRECT SOLUTION.
That is a surprising statement for a contributor to this group. It is
probably true, but the relational database has dominated the industry
for over 30 years. It provides an excellent way of modeling real world
data and the alternatives have not (yet) been seen as a serious
challenge.
>It is a matter of balancing features (performance, data storage, code
>size, code functionality).
The history of computing has been about finding the "true correct"
data model or user interface and _then_ optimising features including
the ones you list. It is possible that an address book is an extremely
complicated application and there is no simple model for it that
minimises redundant information. I sought your help because, unless
the model is simple enough to think of in a few idle minutes, it is
probably too complicated for the average address book user. I am
confident that if you can produce an intuitive, simple, data model it
will become as ubiquitous as a user name and password logon.
>
>If you want a professional solution, then you need to learn
>professional skills. It will take more time and effort than can be
>done in a single newsgroup thread.
>
>Finally, we also get the occasional student postings here looking for
>solutions to their homework/project assignments. I try in my posts to
>generally lead toward solutions without supplying them
I believed my original post indicated that I had thought about the
problem, looked at other people's solutions and that I was coming to
you because I was not satisfied with anything I had seen so far. I
assumed that the post spoke for itself and, even if it did not, a
respondent would do a Google search before making assumptions about
the poster. Clearly, my post was not as lucid as it seemed to me
because this is the fourth response based on an elementary database
design course. I was seeking a breakthrough data model of a personal
address book that one of you had thought of in the shower this
morning.
|
