Question

What is an anomaly? Explain which type of anomalies occurs and why we
required normalization?

Answer 1

Answer:

Anomalies are problems that can occur in poorly planned, un-normalised databases where all the data is stored in one table (a flat-file database). Insertion Anomaly - The nature of a database may be such that it is not possible to add a required piece of data unless another piece of unavailable data is also added.

The normalization process was created largely in order to reduce the negative effects of creating tables that will introduce anomalies into the database. There are three types of Data Anomalies: Update Anomalies, Insertion Anomalies, and Deletion Anomalies.

please mark me as the brainliest

Answer 2

Question:

What is an anomaly? Explain which type of anomalies occurs and why we required normalization?

Answer:

Q. What is an anomaly?

Ans. Something different, abnormal, peculiar, or not easily classified, something anomalous.

They regarded the test results as an anomaly, deviation from the common rule, irregularity.

${\fcolorbox{blue}{black}{\blue{\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:HumanIntelligence\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:\:}}}$