Even if a database is to be used mostly for querying data,with little or no change to the data,the highest degree of normalization should still be implemented.

Question

Quizplus · Accepted Answer

Normalization primarily aims to reduce redundancy and improve data integrity, but the highest degree of normalization (e.g., going to 5th Normal Form) can lead to increased complexity and potentially slower query performance. For databases focused on querying, a balance between normalization and performance needs is often sought, sometimes accepting some denormalization for faster read operations.

Even If a Database Is to Be Used Mostly for Querying