Objectives of a good Database Design

Good Database Design is what everyone wants to achieve to avoid the consequences of dealing with a bad design.

The following are the objectives of a good database design −

Avoid Redundant Data

The table in the database should be constructed following standards and with utmost dedication. It should have different fields and minimize redundant data. The table should always have a Primary Key that would be a unique id.

Faultless Information

The database should follow the standards and conventions and provide meaningful information useful to the organization.

Data Integrity

Integrity assists in guaranteeing that the values are valid and faultless. Data Integrity is set to tables, relationships, etc.

Modify

The database developed should be worked upon with the conventions and standards, so that it can be easily modified whenever the need arise.

Alex Onsman

Published on 03-Jul-2018 12:20:08

• Related Questions & Answers
• The benefits of good Database Design
• Database Design Methodologies
• Major Concerns with Database Design
• Importance of Entity-Relationship diagram in database design
• Understanding the Objectives of a Business Requirements Document
• Define financial objectives of an organisations.
• Explain the factors influencing physical database design
• What are some good tools to visualize MySQL database schema?
• What are the objectives and features of trial balances?
• List the non-financial performances objectives.
• What is financial management? Define objectives and scope of financial management.
• What is Design of Lexical Analysis in Compiler Design?
• Good example of functional testing a Python Tkinter application
• Usage of Responsive Web Design
• Design a Keylogger in Python