Question d’entretien chez Salesforce

What is normalization in a database, and why is it important?

Réponse à la question d'entretien

Utilisateur anonyme

23 oct. 2024

Normalization is the process of organizing data in a database to minimize redundancy and improve data integrity. It involves dividing large tables into smaller, related tables and defining relationships between them. Importance: Reduces data duplication: Ensures that each piece of data is stored only once. Improves consistency: Reduces anomalies during data operations like insertion, deletion, and updating. Enhances query performance: Optimized data structure can improve query efficiency.