Hi,
I am new to programming. I have dbms subject in my syllabus. Last week our sir had teach us normalization. But I still unclear about this concept. So any one there who know anything about this concept please share with me. Thanks.
Hi,
I am new to programming. I have dbms subject in my syllabus. Last week our sir had teach us normalization. But I still unclear about this concept. So any one there who know anything about this concept please share with me. Thanks.
Normalization is a mechanism through which we systematically arranged data in database. It helps in reducing redundancy of data and to make sure that all tables are properly dependent. With normalization we can reduce the unnecessary amount of space in database.
There are three normalization rule as follows:
1.1NF
2.2NF
3.3NF
We use normalization process to make our database more efficient and allow us to access data more quickly. If database keep in normal form it will be easy to add or delete some data easily without affecting database. In normalization we simplify data by reducing redundancy of data.
There are following stages of Normalization:
1NF-> 2NF-> 3NF-> BC NF->5NF
Normalization is the process through which data is stored in different tables to improve the efficiency of database. If we properly normalize data then you can find that there is only one table for one field. In this process you can find one table for particular data. Through normalization we can reduce redundancies and increase efficiency. One of the disadvantage of normalization is that it will reduce database performance because of many tables.
Following are the stages of normalization
1.1NF:discard duplicative columns
2.2NF:create separate table for specific data
3.3NF:delete the columns that are independent.
Bookmarks