Member Avatar for get2tk

hiya ,pls where can i get an explanatory note on normalization?I will also need an example for each form starting from the 1NF to
4NF.

  • 3 Contributors
  • 2 Replies
  • 102 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by Grn Xtrm

Dani AI

Generated

Following 's request and building on 's pointer and 's brief outline, below is a compact, practical walk-through of 1NF→4NF with concrete, easy-to-apply examples and when to stop normalizing.

1NF — remove repeating or multi-valued fields (make values atomic). Example before:

Contacts(ContactID, Name, Phones)
Row: (1, "Alice", "555-111,555-222")

Fix by creating a child table so each phone is one row:

Contacts(ContactID, Name)
ContactPhones(ContactID, Phone)

2NF — eliminate partial dependencies on a composite key. Example before:

OrderItems(OrderID, ProductID, OrderDate, Quantity)
PK = (OrderID,ProductID) but OrderDate depends only on OrderID

Fix by moving order-level attributes into Orders:

Orders(OrderID, OrderDate, CustomerID)
OrderItems(OrderID, ProductID, Quantity)

3NF — remove transitive dependencies (non-key -> non-key). Example before:

Employees(EmpID, DeptID, DeptName)
DeptName depends on DeptID, not directly on EmpID

Fix by creating Departments(DeptID, DeptName) and Employees(EmpID, DeptID,...).

4NF — remove independent multi-valued facts about the same key. If a person has many phones and many languages and those lists are independent, split:

PersonPhones(PersonID, Phone)
PersonLanguages(PersonID, Language)

Practical notes: normalize to 3NF for most OLTP designs; use BCNF if candidate-key anomalies appear; apply 4NF only when true independent multi-valued dependencies exist. Balance normalization against query performance—denormalize selectively, add proper foreign keys and indexes, and migrate data carefully when splitting tables.

Recommended Answers

All 2 Replies

Member Avatar for Grn Xtrm

1NF- There must be a unique primary key and no repeating groups
2NF- No partial dependencies and in 1NF
3NF- No transitive dependencies and in 2NF

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.