Database is one of the biggest bottleneck of a Web App performance now a days.

A poorly designed database can make your life hell as a dev while optimizing an app.

On the other hand, A good design can speedup your development process along with the performance of the app.

I'm also learning the basics of database design, in that process here listing some basic tips.

As I always say, Database design is almost 30% of whole development process for me. With a solid design I can write code very confidently. So think before the design, don't be upset later.

If you have any other point, please let me know via comment. I'm eagerly waiting to learn something new.

What's on your mind?