Welcome New User! ( Create Account | Sign In )

Answer Questions and Earn Money! Join Us

Start earning today!


This Question has not been awarded yet.

Post your answer now!


Submitted 1729 days ago...



New User (1)

What is the difference between partial dependency and transitive dependency?

Share | Abuse |
Answer 1 / 1 - Submitted 1523 days ago...



New User (3)

Let's start by nailing down the concept of dependency. We will construct a primitive database using pencil and paper. Our table will be called "Cars". It will have 3 fields: a key, called car-name; and fields called color and brand. Let's walk through the process of creating a record to represent Fred's car. This in fact will be the key: the car-name is "Fred's car". With pencil in hand I ask you what I should write for "color". "I don't know", you reply. "It depends on Fred's car. What color is it?". This "depends" is what we mean by dependency: the value of a column depends on which item in the real world is being described. What is it that identifies this item? The primary key ("Fred's car"). So we say that the column is dependent on the primary key.

Now suppose a table has a 2-segment-key, say a transaction table, with customer number and transaction number. If this table were to have a field called customer name, it would be dependent only on the customer number; that is, it would be dependent on part of the key. This is called a partial-key dependency.

Say that our table is for a grocery store; and every transaction is for one item. Suppose a given record had a item value of banana. Suppose another field were item-family, with a value of fruit. The item-family is dependent on item; item itself is dependent on the primary key; so the dependency makes a transit from key to field, and field to another field: a transitive dependency.

Both types of dependency are considerd violations of normalization rules. Both are resolved by breaking out the dependent value and storing it somewhere else, once only, so it doesn't have to be repeated on row after row. We record the customer's name in the customer table, not the transaction table; and we record bananas' membership in the fruit family by creating one record in, say, a grocery-type table.

Share | Link | Abuse

Answer This Question Now

What is the difference between partial dependency and transitive dependency?

If your Answer is chosen as the “accepted” answer, you will earn ongoing royalties on this thread.
Simply type your Answer in the box below and post your answer.

Email Subscriptions

Author adds clarification

All new responses

Related Questions