Oracle PL/SQL Tutorial/Introduction/Database Normalization

Материал из SQL эксперт
Перейти к: навигация, поиск

Introducing database normalization

  1. Database normalization is useful for several reasons:
  2. It helps to build a structure that is logical and easy to maintain.
  3. Normalized databases are the industry standard.
  4. Retrieving data will be easier.
  1. First Normal Form means that the database doesn"t contain any repeating attributes.
  2. Violations of Second Normal Form occur when the table contains attributes that depend on a portion of the primary key.
  3. Second Normal Form violations can exist only when you have a multi-column primary key.
  4. Third Normal Form violations occur when a transitive dependency exists.
  5. All attributes in entities (columns in tables) must be dependent upon the primary key or one of the candidate keys and not on other attributes.

1. 10. Database Normalization 1. 10. 1. Introducing database normalization