Thanks for your answer. I am a DB novice and I still have questions, I would like you to explain a bit more about the following:
" I'd generally question a design that uses 5 foreign keys on a matching table"
Does this mean that my table with 5 foreign keys should have fewer foreign keys? How could I achieve this goal if such a table depends on 5 other tables? Maybe a must take into account a redesign of this precise table.
Regards.