{"tags":[{"tag":"textarea","content":"In relational dbms, it is used to\n- Reduce redundancy \/ duplications\n- Increase speed of transactions\n- Improves integrity\n- mostly used 1NF, 2NF, 3NF\n\n1 NF:\n- First normal form\n- Each cell contains single value\n- Each row is unique\n\n2NF:\n- Second normal form\n- Database must be in 1NF\n- Separata table for values that occur frequently in multiple rows for same column\n- Make sure to connect the separate table with a foreign key\n\n3NF:\n- Third normal form\n- Database must be in 2NF\n- If a column in a table does not depend on that table's primary key, \n\tthen separate that unrelated column\n- Make sure to connect the separate table with a foreign key","code_language":"whatever"}]}

The process of organizing data to avoid any duplication of data and redundancy is known as Normalization.

{"tags":[{"tag":"p","content":"Grepper Recommends: <a href=\"https://www.grepper.com/api/view_product.php?pid=27\" target=\"_blank\">Fiverr</a>"},{"tag":"p","content":"Fiverr is a great place to find talented freelancers for all pretty much any type of work you can do behind a computer. They have a great selections of Logo Designers, Graphic Artists, Web Developers, Designers, Writers, Social Media Experts,&nbsp; Marketers etc..."},{"tag":"p","content":"If you need some help on your next project, Fiverr is the best place to find reasonably priced but still very skilled freelancers.&nbsp;"},{"tag":"p","content":"<a href=\"https://www.grepper.com/api/view_product.php?hl=1&amp;pid=27\" target=\"_blank\">Find Freelancers on Fiverr</a>"}]}

{"tags":[{"tag":"p","content":"You have reached your max daily Grepper answers. <a href=\"https://www.grepper.com/subscriptions.php\" target=\"_blank\" rel=\"nofollow\">Upgrade to professional </a>to view more Grepper answer today."},{"tag":"p","content":"<a href=\"https://www.grepper.com/api/view_product.php?hl=1&amp;pid=42\" target=\"_blank\" rel=\"nofollow\">Upgrade To Grepper Professional</a>"}]}

{"tags":[{"tag":"p","content":"normalization in dbms"},{"tag":"p","content":"<br>"}]}