4 15 Points Using Example Explain Common Anomalies Normalization Helps Avoid Databases Q37223844

4. (15 points) Using an example, explain the common anomalies that normalization helps to avoid in databases Show transcribed image text 4. (15 points) Using an example, explain the common anomalies that normalization helps to avoid in databases

Answer

`Hey,

Note: Brother in case of any queries, just comment inbox I would be very happy to assist all your queries

We normalize tables to get rid of anomalies. Anomalies if occurcan lead to inconsistent data. Three type of anomalies are:

Insertion Anomaly

StudentCourse(StudentID,CourseID,StudentName,CourseName,CourseDuration)

You cannot

OR

 

OR