Re: Little design mistakes that can be easily avoided (2): Listenning to CELKO (and CELKO alikes)

David Cressey wrote:
"Matthias Klaey" <mpky@xxxxxxxxxxx> wrote in message
news:5bsi53h8bt88nf7iaj0tpk6e3rbjkv9mh8@xxxxxxxxxx
1. In the Relational Model, the key is part of the definition of a
relation (= table in practice). You don't have a relation if it
doesn't have a key.

I differ with the wording above. Here's an alternate wording: if you have
a relation, the tuples will be distinct, by definition. This means that the
entire tuple is either a candidate key or a super key.

It is /always/ a superkey. It might be "candidate" (i.e. irreducible) as
well; if not, it is a /proper superkey/. (Also, a tuple is not a key,
but I'll quibble about that some other time:)
--
Jon
.

Relevant Pages

  • Re: How bout that Chief Justice?
    ... throwing the timing off. ... up the wording. ... Seems to me that Roberts didn't practice. ...
    (rec.music.gdead)
  • Re: How bout that Chief Justice?
    ... throwing the timing off. ... up the wording. ...  Seems to me that Roberts didn't practice. ...
    (rec.music.gdead)
  • Re: How bout that Chief Justice?
    ... throwing the timing off. ... up the wording. ... Seems to me that Roberts didn't practice. ...
    (rec.music.gdead)
  • Re: washington post ultimate press
    ... I agree with the wording of the article but do players that practice ... and train 4-7 days per week and spend thousands of dollars travelling ...
    (rec.sport.disc)
  • Re: Opening
    ... Jonathan L Cunningham writes ... in spending half an hour practising long division when ... How can you practice something you ... It's not what you meant to say, but it was too close to the wording I and others have heard many times and so your true meaning was lost. ...
    (rec.arts.sf.composition)