Normalization and its Types in DBMS

Fig-a
  • It should satisfy the first normal form.
  • No non-prime attribute is dependent on the proper subset of any candidate key in a table
  • It should satisfy the second normal form.
  • At least one of the functional dependencies between X and Y (X ->Y) should be happening.
    -> X is a super key of the table.
    -> Y is a prime attribute of the table.
  • It should satisfy the third normal form.
  • It should be in functional dependency X ->Y which is X should be the super key of the table ”.
  • It should satisfy the Boyce-Codd normal form.
  • It should not contain more than one multivalued dependency.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store