![]() ![]() Normalization helps to achieve followings: reduce the amount of space a database consumes by eliminating data redundancy make the relational model more informative to users reduce the chance of going to an inconsistent state after any operation The Normal Forms The database community has developed a series of guidelines for ensuring that databases are normalized. ![]() In this process we successively decompose the tables to reach tables with fewer columns with proper relationship which will make data retrieval and insert, update and delete operations more efficient and eliminate data redundancy and reduce the change of going to an inconsistent state after any operation. 1 to BCNF – Prepared by Kamal Podder What is Normalization? Normalization is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics - insertion, update, and deletion anomalies - that could lead to a loss of data integrity. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |