What major problem can occur if we do not normalize a relation-01375
This subjective question is related to the book/course
vu eng301 Business Communication.
It can also be found in
vu eng301 Mid Term Solved Past Paper No. 1.
Question 1: What major problem can occur if we do not normalize a relation into the first normal form?
Answer:
Normal Forms
Normalization is basically; a process of efficiently organizing data in a database. There are two goals of the normalization process: eliminate redundant data (for example, storing the same data in more than one table) and ensure data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored. We will now study the first normal form.There are four anomalies , redundancy ,Inset anomaliy ,delete anomaly and update anomaly.
