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 8, 2013 at 4:29 pm

    #1622255

    PreviousJobTitle is 0% dependent on the primary key in my example. Was that not clear?

    If the table were changed and PreviousJobTitle were dependent on PersonID2 (instead of JobTitle) would it be in 1NF?

    If PreviousJobTitle were dependent on PersonID1 and PersonID2 (and not on JobTitle), would the table be in 3NF?

    JobTitle could be a candidate key in a different table. I guess the normal form only looks at the scope of one table.

    Please confirm the following:

    If a non-key attribute is dependent on one of 1,000 columns (when the primary key is composed of 1,000 columns), the table is in 1NF or lower. But if the non-key attributes are all dependent on either the primary key (all 1,000 columns) except that one non-key attribute is dependent another non-key attribute, the table is in 2NF. If the non-key attribute that is dependent on a different non-key attribute is removed from the table, then the table is in 3NF.