Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.68.MISMATCH!feeder.news-service.com!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Gene Wirchenko Newsgroups: comp.databases.theory Subject: Re: Designing DB in accordance with the relational model Date: Thu, 11 Nov 2010 13:25:19 -0800 Organization: A noiseless patient Spider Lines: 34 Message-ID: <9onod61vfji5jthair5h0jv4qrdonvlk5b@4ax.com> References: <0cc6a410-1d21-4d9c-b6c2-f765bf666d5f@r29g2000yqj.googlegroups.com> <103c675a-f7d6-4c51-a4b2-e04bd06c9a64@y23g2000yqd.googlegroups.com> <383ee2a6-1142-4f42-a548-bebe99b43c55@v20g2000yqb.googlegroups.com> <3ueod616gdl6245e4lbcj5ad45hkeoniuk@4ax.com> <40103c07-eae4-40e6-958c-d2a282d250d8@e26g2000vbz.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Injection-Info: mx01.eternal-september.org; posting-host="7Qrvczazr82YckO5XW8Vtw"; logging-data="32092"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19X38IHcHIgAUajfAh5ryy9bY6lScwzgXU=" X-Newsreader: Forte Agent 4.2/32.1118 Cancel-Lock: sha1:gClN+79Z9Vk2ptiNhDwoKra9Ys0= Xref: news.cambrium.nl On Thu, 11 Nov 2010 12:29:08 -0800 (PST), Kentauros wrote: >On Nov 11, 10:32 pm, Hugo Kornelis > wrote: >> On Wed, 10 Nov 2010 15:54:26 -0800 (PST), Kentauros >> >> wrote: >> >On Nov 11, 12:39 am, Hugo Kornelis >> > 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