Third Normal Form

• A relation is said to be in Third Normal Form if there is no transitive functional dependency between nonkey attributes

  • When one nonkey attribute can be determined with one or more nonkey attributes there is said to be a transitive functional dependency.

• The side effect column in the Surgery table is determined by the drug administered

  • Side effect is transitively functionally dependent on drug so Surgery is not 3NF

Previous slide

Next slide

Back to first slide

View graphic version