I am building a database for a small project. I don't have much experience so I am unsure, but I get the feeling I am not approaching this correctly.
I have a system which allows users to create courses, which contain sections of questions which they answer. I have separated out courses, sections and questions as separate entities, but the questions table requires foreign keys from:
- The Users table to know who created it.
- The Courses table to know what course it is part of.
- The Sections table to know what section of the course it is in.
Question: In terms of the Questions table requiring foreign keys from everywhere, is this layout acceptable? Is there any improvements that could be made?
Thanks for any help.