Thursday, 1 February 2018

Normal Forms

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.

Related topics

Professor Jayesh video tutorial

Please use contact page in this website if you find anything incorrect or you want to share more information about the topic discussed above.