My friends and I are building a database for statistical research. So we have a user that answers 10 questions in a row. The questions are face-images, one is mirrored and the other one is the original, and the user should answer what the original is. From the images we know, where it lies (URL) the id and the sex.
He can participate as many times as he wants, so we need to save all his answered questions.
We want to save how many things he got right, how many he got wrong, and see if it is easier for the user to differentiate between women or men faces.
We want to store as many information as possible, without a lot being redundant.
Here is our current ER -Modell and we are not really sure if it is correct.
I would appreciate any help