Ask Question
12 May, 17:13

Contrast the following terms (provide examples) : Partial dependency; transitive dependency

+1
Answers (1)
  1. 12 May, 19:04
    0
    Transitive dependency

    In this case, we have three fields, where field 2 depends on field 1, and field three depends on field 2.

    For example:

    Date of birth - -> age - -> vote

    Partial dependency

    It is a partial functional dependency if the removal of any attribute Y from X, and the dependency always is valid

    For example:

    Course and student these tables have a partial dependency, but if we have the field registration date, this date will depend on the course and student completely, we must create another table with the field registration date to remove this complete dependency.

    If we remove or update the table registration date, neither course nor student must not change.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Contrast the following terms (provide examples) : Partial dependency; transitive dependency ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers