Home Forums Database Design Design Ideas and Questions What normal form would this be considered? 2NF or 3NF? RE: What normal form would this be considered? 2NF or 3NF?

  • June 2, 2013 at 8:28 pm

    #1620361

    Golfer22 (6/2/2013)

    Lets say I have a table with four columns named PersonID1, PersonID2, JobTitle, and PreviousJobTitle. There is a composite primary key on PersonID1 and PersonID2. In all instances PreviousJobTitle can be derived on JobTitle. Let's say PreviousJobTitle is dependent on JobTitle but not the primary key. Please assume PreviousJobTitle is 0% dependent on the primary key and 100% dependent on a non-key attribute. JobTitle is 100% dependent on the composite primary key.

    What normal form is such a table in?

    I'd say that it doesn't meet any of the requirements for any level of normal form.

    --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)