NORMAL FORM
NORMAL FORM Normalization of Database Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like insertion, updates and deletion Anomalies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables. Normalization is used for mainly two purposes. Eliminating redundant (useless) data Ensuring data dependencies make sense i.e. data is logically stored. Problem without Normalization becomes difficult to handle and update the database without facing data loss. Insertion, updation and deletion anomalies are very frequent if database is not normalized. To understand those anomalies, let us take an example of student table. S_ID S_Name S_Address Subject_opted 401 Adam 402 Alex 403 Smith 404 Adam Updation Anomaly: To update address of a student who occurs twice or more than twice in a table,… Read More »NORMAL FORM