The benefits of good Database Design

A good database design has many benefits and is a goal to achieve for every DBA −

Easy Retrieval of Information

If the design is developed properly, then it would be easier to retrieve information. Correct design means the tables, constraints, and relationships created are flawless.

Easier Modification

Changes that you make to the value of a given field will not adversely affect the values of other fields within the table.

Easy to Maintain

The database structure should be easy to maintain. The design is perfect if changes in one field is not affecting changes in another field.

Information

With a good design, you can enhance the quality and consistency of information.

Well-designed Database

If the database is well defined, then the flaws and issues of a poorly designed database will not need to be addressed.