What is the most important thing in a good database design?

Question

If a database is properly designed, you should be able to understand how a business operates by looking at nothing more then the schema. In other words, the database is the business. If the database isn't reflecting how the business is run, either the database is wrong or the business is wrong. 24 февр. 2009 г.

What is the most important element of database design?

The table is the most fundamental element found in a database schema. Columns and rows are associated with tables. Tables, columns, and rows are discussed in the following subsections.

What is important to design a database?

A good database design is, therefore, one that: Divides your information into subject-based tables to reduce redundant data. Provides Access with the information it requires to join the information in the tables together as needed. Helps support and ensure the accuracy and integrity of your information.

What is the most important part of a database?

DBMS exists to collect, store, process and access data, the most important component. The database contains both the actual or operational data and the metadata.

What are the features of a good database design?

Review: Qualities of a Good Database DesignReflects real-world structure of the problem.Can represent all expected data over time.Avoids redundant storage of data items.Provides efficient access to data.Supports the maintenance of data integrity over time.Clean, consistent, and easy to understand.Relational Database Design - Massachusetts Institute of Technology

Expert · Answer