Computer Science & IT – B.Tech, BCA, BBA, MCA, M.Tech Best Online Coaching Institute

Normalization in Database Management System

INTRODUCTION

This process was developed by E.F.Codd. Normalization is basically used to improve performance by reducing redundant information from the database. In other words normalization is used to reduce the table in normal forms. But the problem occur in normalization is anomalies.

ANOMALIES

There are various types of anomalies in database.

  • Deletion Anomaly
  • Insertion Anomaly
  • Updation Anomaly

Consider the Student Relation. The attribute of the Student relation are SID, Fee, Activity

Example of Anomaly

Example of Anomaly

Deletion Anomaly

Suppose that each student activity has a fixed fee that is same for all students. If we delete the row for the student table sid (100), we lose a whole tuple related to that row.

Insertion Anomaly

Suppose we want to enter information in Student Table and we have information only sid (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me