Re: Designing DB in accordance with the relational model

From: Gene Wirchenko <genew_at_ocis.net>
Date: Thu, 11 Nov 2010 13:25:19 -0800
Message-ID: <9onod61vfji5jthair5h0jv4qrdonvlk5b_at_4ax.com>


On Thu, 11 Nov 2010 12:29:08 -0800 (PST), Kentauros <joker.vd_at_gmail.com> wrote:

>On Nov 11, 10:32 pm, Hugo Kornelis
><h..._at_perFact.REMOVETHIS.info.INVALID> wrote:
>> On Wed, 10 Nov 2010 15:54:26 -0800 (PST), Kentauros
>>
>> <joker..._at_gmail.com> wrote:
>> >On Nov 11, 12:39 am, Hugo Kornelis
>> ><h..._at_perFact.REMOVETHIS.info.INVALID> wrote:
>>
>
>> >The problem is, many characteristics never change at all.
>>
>> But why is that a problem?
>> "Wario has defense 17 in Super Mario World"
>> "Wario has defense 17 in Super Mario World 2"
>> "Wario has defense 17 in Super Mario World 3D"
>> "Wario has defense 17 in Super Mario World - the last part"
>> "Wario has defense 17 in Super Mario World - the sequel to the last
>> part"
>>
>> There is nothing wrong with this extension. The candidate key for this
>> relvar is (Character, Game), and there are no violations of this key,
>> or of any other constraint.
>The redundancy. That is what wrong.

     It sounds as if you are getting into premature optimisation.

[snip]

Sincerely,

Gene Wirchenko Received on Thu Nov 11 2010 - 22:25:19 CET

Original text of this message