Introduction
Good schema design makes it easy and fast to get the data you want. Bad design can make using the database confusing and slow.
When planning a new app that needs to store and fetch data
When you want to make sure your data is easy to understand and use
When you want to avoid mistakes or slow queries in your app
When you want to help other developers work with your data easily