Pergunta de entrevista da empresa Infosys

One key question they asked me was: “Explain normalization in DBMS and its different normal forms.”

Resposta da entrevista

Sigiloso

23 de fev. de 2026

I explained that normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. I briefly described the normal forms — 1NF (removing repeating groups and ensuring atomic values), 2NF (eliminating partial dependency), and 3NF (removing transitive dependency). I also gave a small example to show how splitting tables helps in maintaining consistency and avoiding anomalies.