Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. Let’s discuss about anomalies first then we will discuss normal forms with examples.Update anomaly: In the above table we have two rows for employee Rick as he belongs to two departments of the company. If we want to update the address of Rick then we have to update the same in two rows or the data will become inconsistent. If somehow, the correct address gets updated in one department but not in other then as per the database, Rick would be having two different addresses, which is not correct and would lead to inconsistent data.Insert anomaly: Suppose a new employee joins the company, who is under training and currently not assigned to any department then we would not be able to insert the data into the table if emp_dept field doesn’t allow nulls.Delete anomaly: Suppose, if at a point of time the company closes the department D890 then deleting the rows that are having emp_dept as D890 would also delete the information of employee Maggie since she is assigned only to this department.To overcome these anomalies we need to normalize the data. In the next section we will discuss about normalization.

Question

Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. Let’s discuss about anomalies first then we will discuss normal forms with examples.Update anomaly: In the above table we have two rows for employee Rick as he belongs to two departments of the company. If we want to update the address of Rick then we have to update the same in two rows or the data will become inconsistent. If somehow, the correct address gets updated in one department but not in other then as per the database, Rick would be having two different addresses, which is not correct and would lead to inconsistent data.Insert anomaly: Suppose a new employee joins the company, who is under training and currently not assigned to any department then we would not be able to insert the data into the table if emp_dept field doesn’t allow nulls.Delete anomaly: Suppose, if at a point of time the company closes the department D890 then deleting the rows that are having emp_dept as D890 would also delete the information of employee Maggie since she is assigned only to this department.To overcome these anomalies we need to normalize the data. In the next section we will discuss about normalization.

Lalitesh sharma · Accepted Answer

Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. Let’s discuss about anomalies first then we will discuss normal forms with examples.Update anomaly: In the above table we have two rows for employee Rick as he belongs to two departments of the company. If we want to update the address of Rick then we have to update the same in two rows or the data will become inconsistent. If somehow, the correct address gets updated in one department but not in other then as per the database, Rick would be having two different addresses, which is not correct and would lead to inconsistent data.Insert anomaly: Suppose a new employee joins the company, who is under training and currently not assigned to any department then we would not be able to insert the data into the table if emp_dept field doesn’t allow nulls.Delete anomaly: Suppose, if at a point of time the company closes the department D890 then deleting the rows that are having emp_dept as D890 would also delete the information of employee Maggie since she is assigned only to this department.To overcome these anomalies we need to normalize the data. In the next section we will discuss about normalization.

Login

In the context of neural networks, what is batch normalization, and why is it used?

A relational database consists of a collection of

A ________ in a table represents a relationship among a set of values

The term _______ is used to refer to a row.

The term attribute refers to a ___________ of a table.

CRUD stands for?

The problem of finding hidden structure in unlabeled data is called

Task of inferring a model from labeled training data is called

Relational calculas is a

The view of totel database content is

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

Study24x7

Henry Harvin

CBSE Study Materials

Digital Marketing - Learn SEO, PPC, SMO,...

Defence

UPSC & State PSC

SSC Preparation Strategies & Study Mater...

Banking/IRDA

DEFENCE EXAM PREPARATION

Get the App

LoadRunner to JMeter which one should prefer as a Performanc...

Youtube Marketing

Why did you choose Software Testing as a career?

Benefits of Learning DATABASE MANAGEMENT

Types of Database and its Uses

RELATIONAL DATABASE MANAGEMENT SYSTEM

OBJECT ORIENTED DATABASE

TO CREATE RELATIONAL DATABASE FEW STEPS TO FOLLOW

Popular Database Software : A Brief Introduction

Different Steps to improve your Database Performance