The Data Model Resource Book [1] is a good resource how to design database. It is a kind of reference book

[1] https://www.wiley.com/en-us/The+Data+Model+Resource+Book%2C+...