Home Forums Database Design Design Ideas and Questions Second normal form or third normal form? RE: Second normal form or third normal form?

  • August 17, 2013 at 12:53 am

    #1642376

    1. If a table was in 1NF and had non-key attributes with trivial transitive dependencies on candidate keys, could it be in 3NF? I think it could if the non-key attributes were not dependent on a subset of any candidate key.

    2. Assuming the non-key attributes were not dependent on a candidate key, nor any subset of the candidate key, what is the highest normal form the table could be in?