Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
5 / 108
What are the conditions to achieve the normalization?
Answer:
There are few conditions to achieve the normalization:
* There should be a unique row identifier.
* A table should store only data for a single type of entity. For e.g. details for book’s publisher and book’s author should be saved under different table.
* A table should avoid columns which can be null-able.
* A table should avoid duplication of data and columns.
Asked In ::
Priyanka Singh
23 Feb, 2019 5:07 AM
There are few conditions to achieve the normalization:
* There should be a unique row identifier.
* A table should store only data for a single type of entity. For e.g. details for book’s publisher and book’s author should be saved under different table.
* A table should avoid columns which can be null-able.
* A table should avoid duplication of data and columns.
* There should be a unique row identifier.
* A table should store only data for a single type of entity. For e.g. details for book’s publisher and book’s author should be saved under different table.
* A table should avoid columns which can be null-able.
* A table should avoid duplication of data and columns.