Ask HN: What are some examples of good database schema designs?
I'd highly recommend reading SQL Antipatterns. It's a very approachable book that illustrates how to design a database schema by taking commonly encountered scenarios and first showing you the naive approach. After explaining why this is bad, it then shows you the recommended way of doing it and why this way works better.I think 'learning from how not to do something' is a really powerful pedagogical technique that should be more widespread.