Explain why it is important to normalize data to third norma

Explain why it is important to normalize data to third normal form (3NF) and why it’s sometimes necessary to achieve even higher normal forms in some situations

Solution

When ever we design database and use we want that there should be no redundancies in data and third normal form gove solution to this problem because of it way of depending on just a key where each non-key attribute needs to put fact about a key. Third normal form helps in removing transistive dependencies.

The database is required to achieve higher normal forms in order to make the database more organised and less complex to get the data rather than putting everything in one table and get the DBA to think about all the colums while inserting value to just one colum , higher normal forms improves performance and reduces time of running a query.