|
Title: Describe what partial and transitive dependencies are. Post by: bla32104 on Feb 16, 2018 Describe what partial and transitive dependencies are.
What will be an ideal response? Title: Describe what partial and transitive dependencies are. Post by: SarahSureShot on Feb 16, 2018 A partial dependency is when the field only depends on one part of a composite or concatenated key. In other words, the field is determined by only one piece of a multi-field key. A transitive dependency is when a field depends on another field in the table which then that field depends on a candidate key, AB and BC, thus A implies C. If C is a candidate key and B is not a candidate key, this is a transitive dependency.
|