Re: Multiple tables refer to one -To use foreign keys or not?

On May 30, 2:10 pm, Bob Badour <bbad...@xxxxxxxxxxxxxxxx> wrote:
Adriano Varoli Piazza wrote:
On 29 mayo, 22:11, Bob Badour <bbad...@xxxxxxxxxxxxxxxx> wrote:

Gene Wirchenko wrote:

Adriano Varoli Piazza <mora...@xxxxxxxxx> wrote:

On 29 mayo, 18:38, Bob Badour <bbad...@xxxxxxxxxxxxxxxx> wrote:

I will cite Date's _Principle of Incoherence_ and ask whether you are
re-inventing EAV, yet again?

Readinghttp://en.wikipedia.org/wiki/Entity-Attribute-Value_model,
but this doesn't look like the same problem at first glance. I'll try
to wrap my head around the concept.
Though it does seem to be an awful lot of work for this particular
task.

Thanks for the readup anyway, if it's the right solution, good, and if
it's not, I'll avoid reinventing stuff in the future.

    It is not the right solution.  It is a hideous way to do it.

And I want to make clear I wasn't accusing the OP of anything hideous. I
could not make enough sense of his post to tell what he was doing, and
some of it seemed suggestive of yet another reinvention of EAV. Not
enough to say for sure, though.

A simple "Your post is very confusing, please clarify X, Y and Z"
would have been better.

No, actually, it wouldn't have. You might have preferred it, but it
would have done you a lot more harm than good.

Ok, then this was a better reply than your original one. Though I
don't understand how asking me to rephrase my problem (thus rethinking
it) would do more harm.

The only really useful and helpful thing I can say is: You need to learn
the fundamentals before you start designing databases. And learning the
fundamentals has nothing to do with learning the SQL language.

Yes, this is clear. I have the impression, though, that learning some
of the fundamentals implies a bit of experience in most real-life
cases. I could be wrong.

Saludos
Adriano
.

Relevant Pages

  • Re: total begginer
    ... > You can't assume that everyone has the same passion and drive to copy ... > vocabulary in one's head. ... > different learning styles. ... Hopefully we agree on these fundamentals at ...
    (alt.guitar.beginner)
  • Re: Multiple tables refer to one -To use foreign keys or not?
    ... re-inventing EAV, yet again? ... but this doesn't look like the same problem at first glance. ... fundamentals has nothing to do with learning the SQL language. ... In fact, the former abound. ...
    (comp.databases.theory)
  • Re: Career advice for a young PC enthusiast.
    ... as you are knowledgeable in the fundamentals of a particular system, ... But, as you say, it does need "long hours and a desire to learn" from time to time. ... Different learning paradigms work for different people. ...
    (uk.adverts.computer)
  • Re: Ricky???
    ... Lets see, me, three months experience, learning the ME fundamentals of ... because youve been posing all your life being the second mouse. ...
    (rec.sport.jetski)
  • ANN: simpleJ 1.0 released
    ... Learning how to write software is hard. ... concepts that a beginner has to assimilate. ... teaching teenagers the fundamentals of computer programming by allowing ...
    (rec.games.video.classic)