Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!in03.usenetserver.com!news.usenetserver.com!news.glorb.com!peer1.news.newnet.co.uk!194.159.246.34.MISMATCH!peer-uk.news.demon.net!kibo.news.demon.net!news.demon.co.uk!demon!not-for-mail From: "Tony Rogerson" Newsgroups: comp.databases.theory Subject: Re: Newbie question about db normalization theory: redundant keys OK? Date: Fri, 14 Dec 2007 18:55:36 -0000 Lines: 24 Message-ID: References: <15b312ea-1f66-4f22-abbb-63581e0eca73@x69g2000hsx.googlegroups.com> <6vOdnbLXmc7E3f_anZ2dnUVZ8qydnZ2d@pipex.net> <28068342-3712-4ea2-b0d3-697bfa018e51@i12g2000prf.googlegroups.com> <1065f96a-1f8e-4fc7-b1cc-53137ebd8b8f@s8g2000prg.googlegroups.com> NNTP-Posting-Host: torver-adsl.demon.co.uk Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Trace: news.demon.co.uk 1197658611 23199 80.177.180.177 (14 Dec 2007 18:56:51 GMT) X-Complaints-To: abuse@demon.net NNTP-Posting-Date: Fri, 14 Dec 2007 18:56:51 +0000 (UTC) In-Reply-To: <1065f96a-1f8e-4fc7-b1cc-53137ebd8b8f@s8g2000prg.googlegroups.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545 X-Priority: 3 X-Newsreader: Microsoft Windows Mail 6.0.6000.16480 X-MSMail-Priority: Normal Xref: usenetserver.com comp.databases.theory:168123 X-Received-Date: Fri, 14 Dec 2007 14:00:07 EST (text.usenetserver.com) "David Portas" wrote in message news:1065f96a-1f8e-4fc7-b1cc-53137ebd8b8f@s8g2000prg.googlegroups.com... > You are saying that this is a distributed database but that it lacks a > mechanism for accurately propagating changes out to all its nodes? Nope - it's a normal database you have simply done a query against the database - the result of SELECT and then return to the database to validate your data against it - think about it; your insurance company posts you a claim form and you then send it back in - you need to validate what's on the form (our equiv of time table) against the database. Also, please can you show me how you would simply put history in the table with celko's example. -- Tony Rogerson, SQL Server MVP http://sqlblogcasts.com/blogs/tonyrogerson [Ramblings from the field from a SQL consultant] http://sqlserverfaq.com [UK SQL User Community]