Normal Forms

GATE NOTES
Normal Forms in DBMS

Steps to find Normal Forms-

  1. Find Candidates key
  2. Find Prime attributes and Non prime attributes
  3. Check for Normal Forms, from starting from 1NF to higher order.
1NF- Relational DBMS does not allow multi-valued or composite attribute.
2NF- Relational DBMS does not allow partial dependency.
3NF- Either LHS of an FD should be super key or RHS should be prime attribute.

Partial Dependency – Partial dependency means that a non-prime attribute is functionally dependent on part of a candidate key.
Prime attribute – All candidate keys.
Non prime attribute – All non candidate keys.