One key question they asked me was: “Explain normalization in DBMS and its different normal forms.”
Sigiloso
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.