Partial dependency

  • A partial dependency occurs when fields are indirectly or partially reliant on the main key but are also dependent on other keys that depend on the primary so that if the field on which another field depends is deleted, that field will still exist owing to its dependence on the primary key. I'm not sure if that's right. I scoured the internet and read several articles (Wikipedia, scaler topics &, etc), yet each definition seemed to be deceptive. Is my definition right, and if not, what should it be?

  • You might want to read up on Foreign Keys

    😎

  • It's funny how such articles never use the word "partial".

    Dependecies:

    1. Grown children , working spouses, other relatives, and some "friends".

    2. Old people with occasional bladder control issues.  It's part of the reason they're called "Depends".

    3. Performance of the SQL Server.  See the perceived Kruger-Dunning curve.

    4. Data predictions.  Figures can lie and liars figure.

    5. Salary Increases.  Depends on whether the boss bought a new car or bigger house or just got divorced.

    6. Discretionary Funds:  The real reason why you have friends or not.

    That's just a partial definition but should be enough to get you started. 😀

     

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Getting back on track, I agree with the simple definition expressed at the top of the article in the following link...

    https://www.reference.com/world-view/partial-dependency-91beb2fa8c8354c5

    That also means that the previous partial list of dependencies wasn't that far off.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply