Pros and cons of normalizing data in a 3NF form
The main goal of normalization is to reduce data redundancy and avoid inconsistent data. Normalization leads to the separation of unrelated entities into separate entities. In effect, normalization leads to a clean database design. Since we do not store redundant data, we save storage space and save resources to maintain (update, delete) redundant data.But there are cases where we don't need to...