What are the objectives for the design of a data storage Sol

What are the objectives for the design of a data storage

Solution

Database design helps in

1. Eliminating transitive dependencies in a set of data which helps in avoiding duplication of data.

2. Explains the use case of each table and relation between them. It basically helps in defining the business use case.

3. Scalability. Database design should be scalable enough to inculcate requirements in future. It should not be constrained to current requirements only.

4. Performance. Data base design will impact performance if not designed carefully. It directly impacts no. of reads, and in turn slows the read operation.

5. Indexing. Boost performance for certain data intensive queries.