Schema design is an important part of any application design. It can affect performance, the development process and even your SQL queries. Thinking about design in advance is very important as design is not something we can easily change down the road. Yet, sometimes we get fixated on a specific design without thoroughly considering other, potentially better, options.
In this session I hope to challenge your design mindset by discussing a few design challenges and a few ways to solve them. What are the implications of each solution? Which way is the best? Is there even a “best” way to solve these cases?