Re: On Normalisation & the State of Normalisation
Date: Tue, 3 Feb 2015 05:23:15 -0800 (PST)
Message-ID: <13036d97-636c-4280-bd67-df34443d3844_at_googlegroups.com>
Op dinsdag 3 februari 2015 13:44:52 UTC+1 schreef com..._at_hotmail.com:
> On Tuesday, February 3, 2015 at 4:16:26 AM UTC-8, Erwin wrote:
> > (which is how the normalization procedure really goes)
>
> Interestingly for this application: An envelope gets to a particular address. Ids do not appear on an envelope. So after joining a correct set of tables and projecting out ids there must be a superkey among the remaining columns. The FKs correspond to FDs in the join. So there is a superkey from among Suburb Name, StreetName Name, StreetType Name and the non-id attributes of Address.
>
> philip
Your point being ?
Knowing of the existence of that superkey will not help in identifying the original FD, which is where the real issue is. Received on Tue Feb 03 2015 - 14:23:15 CET