X'inhu d-database normalization?

Question

Accepted Answer

**Normalization** hija l-proċess ta' organizzazzjoni ta' data biex **tnaqqas ir-redundancy** u jtejjeb l-integrità billi ssassi d-data f'tabelli relatati, wara serje ta' "normal forms". L-għan: kull biċċa ta' data tinħażan **darba waħda**, u tinkwa d-duplikazzjoni u l-anomaliji li ticċaġġna.

## Il-problema: tabella denormalized (redundant)

Problems (anomalies):
  ✗ UPDATE anomaly — change Ann's email → must update EVERY one of her orders
  ✗ INSERT anomaly — can't add a customer without an order
  ✗ DELETE anomaly — deleting Ann's last order loses her info entirely
  ✗ Wasted storage and inconsistency risk
```

## Is-soluzzjoni: ssassi f'tabelli relatati

Normalization ssassi d-data biex kull fatt ikun f'post wieħed — informazzjoni tal-customer f'`customers`, prodotti f'`products`, u `orders` jirreferu għalihom permezz ta' key.

## Il-normal forms (progressivament aktar stretti)

```text
1NF → atomic values (no repeating groups / multi-valued columns), a primary key
2NF → 1NF + no partial dependency (non-key columns depend on the WHOLE primary key)
3NF → 2NF + no transitive dependency (non-key columns depend ONLY on the key, not
      on other non-key columns)
→ 3NF is the common practical target; BCNF, 4NF, 5NF exist for stricter cases.
```

## Normalization versus denormalization (it-trade-off)

```text
Normalized   → less redundancy, better integrity, but more JOINs (can be slower reads)
Denormalized → some duplication for FEWER joins → faster reads (e.g. analytics/reporting)
→ Normalize by default (integrity); selectively denormalize for read performance
  where justified (with care to keep duplicates consistent).
```

## Għaliex huwa importanti

Normalization hija kunċett fundamentali tal-design ta' database — hija kif tistruttura d-data biex tinkwa r-redundancy u tpreserva l-integrità, li huwa essenzjali għad-design ta' database relazjonali affidabbli, għalhekk l-fehim tiegħu huwa importanti.

Il-valur ewlieni hija l-prevenzjoni tal-**anomaliji** li d-data redundant (denormalized) icċaġġna: **update anomalies** (ibdil ta' data duplikata f'ħafna postijiet, b'riskju ta' inkonsistenza), **insert anomalies** (ma tistax tżid data mingħajr data mhux relatata), u **delete anomalies** (telf ta' data meta tħassru rekordi relatati) — li kollha jledu għal data inkonsistenti u corrotta.
"