Re: satisfies algorithm

On 26 juil, 10:31, "David Portas"
<REMOVE_BEFORE_REPLYING_dpor...@xxxxxxx> wrote:
"Brian Selzer" <br...@xxxxxxxxxxxxxxxxxxx> wrote in message

news:92kik.14667$cW3.1512@xxxxxxxxxxxxxxxxxxxxxxx



Yes.  Normalize.  A schema that is in BCNF does not have any nontrivial
functional dependencies where the determinant is not also a key.  Where
there is a key, there should also be a unique index of some sort, making
it impossible for there to be two tuples with the same determinant.

Unique indexes have nothing to do with keys. A key is a logical construct
whereas an index is merely one possible physical structure used by some
DBMSs. A key does not require an index.
Typical confusion between logical layer and physical layer.
Algorhythmics has more to do with physical encoding scheme and
implementation computing model. Direct image systems do create that
kind of confusion as well as the normative ignorance of RM.

David Portas

.