The interview process was typical, having the first aptitude round, which was of medium to hard difficulty – 90 minutes, 60 questions. Questions ranged from ratio and proportions, mixtures, sequence, trigonometry, data interpretation, C, C++, DBMS, software engineering, OS, computer networks, and DS. This was the main filtering round, as only 15 were selected out of approximately 400+ candidates. The next day was the technical round. The questions were generic, ranging from DS, OS, CN, basic computer hardware, and some puzzles. I was asked to write some code in C and queries in DBMS involving normalization, etc. Questions relating to the project which I had done were also asked in detail. The next round was the HR round, which had basic questions, nothing out of the ordinary. Overall, it was a great experience. The hiring team was great. Good luck!

Explain the normalization in DBMS in detail with relevant queries.