Reddit reviews Database Design and Relational Theory: Normal Forms And All That Jazz (Theory In Practice)
We found 2 Reddit comments about Database Design and Relational Theory: Normal Forms And All That Jazz (Theory In Practice). Here are the top ones, ranked by their Reddit score.
O Reilly Media
I'm assuming you are interested in designing schemas for relational databases, and not writing relational databases.
I really like CJ Date's SQL and Relational Theory and Database Design and Relational Theory. Use The Index, Luke is a nice site, too, with generally less formal information than Date's books, but more practical info about day-to-day problems.
If you'd like to dig under the covers, I'd start with Principles of Transaction Processing. Philip Bernstein knows what he is talking about, and is active in database research. Gray and Reuter's Transaction Processing is a classic, but is less approachable.
PostgreSQL and MySQL are your open source go tos.
If you are going enterprise stick with MSSQL over Oracle.
For Database design how far do you want to dig into theory?
https://www.amazon.com/Database-Design-Relational-Theory-Practice/dp/1449328016 dives pretty deep but stays useful.
But, you could get away with just the intuitive understanding of what a 'Star Schema' and 'Snow Flake' schema is for a project like yours.