Talk:Functional dependency

Less jargon?

Can anyone explain this in a better way? I have an exam in Data management soon and I can't find one good explination of Full Functional Dependency because they all go into jargon la-la land using very specific database jargon, and understanding it is like trying to understand something in Arabic via Latin while your main language is Russian! Just a simple, (very plain) English explination of what all this means would be very much appreciated.

As far as I can tell/decypher, it full functional dependency is when you have two attributes, and one of them will only ever have one value for each of the other one, and partial dcependency is when there can be several values of that attribute at once for one value of the other. For example, if you have an Aircraft carrier, it will have one captain, so the relationship Aircraft Carrier -> Captain is fully functionally dependant, but the Aircraft Carrier will have many planes, so the relationship AC -> Planes is only partially dependent. Is this close to the mark? 81.129.82.108 06:21, 11 January 2007 (UTC)[reply]

Relation?

The link to the Relation disambiguation page doesn't seem to be relevant to this database-specific use of the term 'relation'. --VinceBowdren 15:53, 16 August 2006 (UTC)[reply]

The definition that 'each X value determines at most one Y value is incorrect. It should be 'each X value determines EXACTLY one Y value.

The test to detemine functional dependency: X->Y TEST: If t1[X]=t2[X] then t1[Y]=t2[Y] i.e. Whenever two tuples agree on their X values, they also agree on their Y values.