What Is The Importance Of A Good Database Design?


3 Answers

Naureen Khan Profile
Naureen Khan answered
Database design is a very crucial part of development. It is the first step after requirement gathering and before coding even begins. Taking time to design the database can save a lot of time and frustration during development.

The importance of a good database design is:

1) Data is in consistent form: - When the database is designed only relevant and required data will be stored. The layout of the table allows the data to be consistent.
Other ways to keep the data consistent are through implementation of primary keys and unique key constraints.

Cascading also allows for data consistency. By implementing cascading on a parent/child table it is ensured that only those child records exist with a valid parent record.

2) Elimination of redundant data: - A good database design should be normalized. When normalization is done data redundancy (or repetition) is reduced, and so is the size of the database.

3) Simpler queries: - If the database is well designed the queries will be simple, and their execution will be fast.

4) Performance: - The overall performance of the application is also dependent on the design of the database.

5) Maintenance: - This is by far the most important issue. A database should be well-designed so that it is easy to maintain. If it is not, a small change down the road could cause a lot of stored procedures, functions, views to be effected.
Ifiok Idiang Profile
Ifiok Idiang answered
Database Design is the database structure that will be used as plan to store and manage data while DBMS is the software used to implement a database design.
Database design is important because;
• Bad database designs ruin good application programs.
• A DBMS does not promise good data management, and it does not ensure that the database will be able to generate accurate information.
• The end user and the designer decide what data will be stored in the database.
Chips Ters Profile
Chips Ters answered

Hi, I suppose you are a beginner and want to learn more about SQL? To do this, use the resources and the view sql server transaction log blog, where you will find a lot of useful information for working with databases and this programming language.

Answer Question