Normalization helps in keeping data consistent by storing the data in one table and referencing it everywhere else. Why we need Normalization in DBMS?Įliminating redundant(useless) data, therefore handling data integrity, because if data is repeated it increases the chances of inconsistent data. It is a multi-step process that puts data into tabular form, removes duplicate data, and set up the relationship between tables. Normalization in DBMS is a technique using which you can organize the data in the database tables so that:Ī large set of data is structured into a bunch of smaller tables,Īnd the tables have a proper relationship between them.ĭBMS Normalization is a systematic approach to decompose (break down) tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion anomaly in DBMS, Update anomaly in DBMS, and Delete anomaly in DBMS. ER Model: Generalization and Specialization.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |