Normalization is a Rule
Normalization is a rule, and like any other rule, is made to be broken in certain cases. If you are responsible for changing a table's
structure and applying the normalization approach, you should only take it as far as it makes sense.
There will be times when it simply does not help to break apart a table into separate related tables.
You will have to use your best judgement to determine when these cases come up.
Normalization is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies—that could lead to a loss of data integrity.
E.F. Codd, the inventor of the relational model, introduced the concept of normalization and what we now know as the first normal form in 1970.
There will be times when it simply does not help to break apart a table into separate related tables.
You will have to use your best judgement to determine when these cases come up.
Normalization is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies—that could lead to a loss of data integrity.
E.F. Codd, the inventor of the relational model, introduced the concept of normalization and what we now know as the first normal form in 1970.