Chapter 4. Understanding Database Design Concepts
When it comes to designing a database, it is very important that we understand database design concepts first. Having less understanding or having some doubts, can lead to a bad database design, which can give rise to a number of problems for users, some of which are as follows:
- Inability to fulfill report requirement
- Loss of data integrity over time
- Redundancy
- Bad performance
- Primary key on multiple fields
Basic design rules
There are some basic design rules which help us to build a good database. Let us discuss on those:
The ability to solve the problem
The main reason for designing a database is to solve a problem. So, it's very important to understand the problem and build the database so that it ...
Get PostgreSQL Development Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
