Skip to content

Latest commit

 

History

History
11 lines (9 loc) · 341 Bytes

File metadata and controls

11 lines (9 loc) · 341 Bytes

Normalization in DBMS

What is Normalization?

  • Process of organizing data to reduce redundancy.
  • Improves efficiency and avoids anomalies.

Forms of Normalization:

  • 1NF: No repeating groups, atomic values.
  • 2NF: 1NF + no partial dependency.
  • 3NF: 2NF + no transitive dependency.
  • BCNF: Stronger version of 3NF.