Normalization

  1. Each column should contain atomic values. Entries like X, Y, and W, X violate this rule.
  2. A Column should contain values that are of the same type. Do not intermix different types of values in any column.
  3. A Column should have a unique name. Same names lead to confusion at the time of data retrieval.
  4. The order in which data is saved does not matter. Using the SQL query, you can easily fetch data in any order from a table.

--

--

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