what is advantage of modified table design
Answers
Answer:
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