mysql - Database design — how granular do I need to be?

Question

Closed. This question is opinion-based. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65887737/database-design-how-granular-do-i-need-to-be

Answer 1

Option 1 would only allow 1 author and 1 publisher per contract where as option 2 allows multiple authors and or publishers per contract. Clearly option 2 is more flexible, but do you need it?

If you don't need multiple authors or publishers per contract for the foreseeable future, then I would opt for option 1, otherwise go for option 2.