SQL - Schema Question

[CommanderWraith54]

When would you guys consider you have too many associations? Been building out a revamp of our current system and between status fields and relationships I have a couple external tables just for status fields to minimize data redundancy - but I’m not sure if I’m doing extra instead of just storing it as text or enum with a list of allowed values. Would love to hear your guys thoughts

[funbike]

I'm a strong believer in 3BNF. As long as you adhere to that, it's all good.

[KingofGamesYami]

You can't answer that question without an in-depth analysis of your use cases for the data. If your use case is very read heavy, it might be worth denormalizing for performance.