Dell Technologies Interview Question

Explain the Normalization in DBMS in detail with relevant queries.