Normalization aims to achieve data integrity by organizing data to reduce redundancy and improve data consistency.

The main advantage of normalization is improved data integrity by reducing data redundancy and ensuring that data dependencies are properly enforced.

Three-tier architecture is commonly used in a client-server database environment, separating the presentation, application logic, and data storage layers.