If you have “rivers” of blank cells that flow across columns, that is a sign that you should consider a base re-design to normalize your data. However, blank cells themselves are not bad. Often that simply means you don’t have that information yet.
You might be confusing the idea of having as few tables as possible with the idea of not repeating data. Sometimes a base re-design will involve combining multiple tables into a single table with multiple views. Sometimes a base re-design will involve creating more tables to reduce storing duplicate data in multiple records.
If you have “rivers” of blank cells that flow across columns, that is a sign that you should consider a base re-design to normalize your data. However, blank cells themselves are not bad. Often that simply means you don’t have that information yet.
You might be confusing the idea of having as few tables as possible with the idea of not repeating data. Sometimes a base re-design will involve combining multiple tables into a single table with multiple views. Sometimes a base re-design will involve creating more tables to reduce storing duplicate data in multiple records.
Thank you very much for the clarification @kuovonne, this in particular was very helpful.
You might be confusing the idea of having as few tables as possible with the idea of not repeating data.
Sometimes a base re-design will involve creating more tables to reduce storing duplicate data in multiple records.
It all makes so sense now