Introduction
Relational database design helps to create a set of relations and tables, which are connected with each other through some defined relationships. The main purpose of relational database design is to preserve the information and minimize data redundancy.
We need to follow some design guidelines for relational schemas to maintain the quality of the database. Also, a formal methodology is required for verifying and improving the quality of the relation schemas.
Let us first have a discussion on Data Redundancy and Update Anomalies.
Data Redundancy
When the same set of data is present multiple times in the database, then