Multiple Survey Database for a Beginner
I have recently created several separate databases, each centered on a particular survey/test. However, what I really need is a multiple survey database, but I'm not really sure how to go about it. I have done some planning/research before starting, and here is what I've come up with:
Surveys <Survey ID> Questions < Question ID> Responses <User ID> Subjects
Would this be a logical way to go about it? I found a "How to" article for creating a survey database, but it was for Filemaker 3.X and didn't use a structure that made sense to me.
The intent, in the end, would be for me to be able to input a User ID, and I will see all the tests they have done. Also, I would like to be able to analyze averages scores and the like.
Also, am I correct in assuming that you would only have 4 records in the Survey table, assuming there were 4 different surveys that could be taken?
Furthermore, what will actually go into the Survey table when all the questions will be in the Questions table (1 record for every question/survey combination)?
Once again, thanks for the help!
P.S. Although I could attempt to merge the databases I have already made, I don't think it would be worth it. Each database I've made has been different, as I have been learning more logical ways to structure my database and analyze my data.