Why is the design of a database so important What are the ra

Why is the “design” of a database so important? What are the ramifications of a poor database design?

Solution

Design of a database is important because a good design helps in eliminating data redundancy, provdie high query performance , efficient execution of queries in a timly manner, and it also ensure data remain consistent with various operation taken on data. This also ease development effort as good design ensures easy acess and retrieval of information.

Poor database can result in huge amount of redundant data costing you extra memory and will effect performance. It may also damage stored procedures, views and function created on top of database.