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.
It is a matter of balancing features (performance, data storage, code
size, code functionality).
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.
If you are just looking to develop a toy database for yourself, then
at least have a brief understanding of ERDs will help. In this case
you should happily play with the database an application code, adding
features here, deleting features there. As long as you are happy with
how it works in this case, my suggestions of normalizing tables and
structured code will be irrelevant.
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 (unless the
person is asking something specific like why a certain SELECT
statement fails and gives enough context to make sense of it).
Ed
|
