Re: Ordering dependency problem

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 18 Jan 2002 11:02:45 -0800
Message-ID: <c0d87ec0.0201181102.856689e_at_posting.google.com>


The reason I say that the adjacency list model (i.e. (employee, boss)) is not normalized is that when an employee changes, the change can affect more than one row wher he is a boss. A normalized database stored one fact, one way, one place, one time.

Better example of a cyclic problem would be voting paradoxes, or the hand game "Sissors, Paper, Stone" where Sissors beat paper, paper beats stone, stone beats sissors. There is a good reason it is a two player game and not a "three or more" player game. Received on Fri Jan 18 2002 - 20:02:45 CET

Original text of this message