Data Analysis for Database Design

• Data Analysis

  • Normalization is a three-step technique that places the data model into first normal form, second normal form, and third normal form.
    • An entity is in first normal form (1NF) if there are no attributes that can have more than one value for a single instance of the entity.
    • An entity is in second normal form (2NF) if it is already in 1NF, and if the values of all non-primary key attributes are dependent on the full primary key – not just part of it.
    • An entity is in third normal form (3NF) if it is already in 2NF, and if the values of its non-primary key attributes are not dependent on any other non-primary key attributes.

Previous slide

Next slide

Back to first slide

View graphic version