GATE NOTES
Normal Forms in DBMS
Normal Forms in DBMS
Steps to find Normal Forms-
- Find Candidates key
- Find Prime attributes and Non prime attributes
- 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.