Talk:Functional dependency
From Wikipedia, the free encyclopedia
Contents |
[edit] 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)
[edit] 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)
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.
[edit] Examples?
This could really use a specific example or two. —The preceding unsigned comment was added by 209.208.140.194 (talk) 22:41, 26 February 2007 (UTC).
Yes, please add some examples. I think that the Aircraft Carrier -> Captain example is correct but the AC -> Planes example misses the mark. AC-> Planes is just a 1:M (one to many) relationship between two separate entities (the Aircraft Carrier and the Plane are two separate entities). Functional dependency has something to do with data within a given table (basically a synonym for "Relation"). But I am running out of steam here and can't quite get all the way to a good example. Can someone please help?
[edit] Small suggestion
Might it be worth putting in a redirect from Functional Dependency for people like me who get confused when that comes up with no page? (86.20.35.62 12:43, 28 March 2007 (UTC))
