database design - psychometric testing layout
Based on your information, let have a draft ERD like below:

TEST 
+ ID (PK)
+ NAME (UK)
+ ...

TEST_QUESTION
+ TEST_ID (PK)
+ QUESTION_ORDER (PK)
+ QUESTION_CONTENT
+ ...

INDIVIDUAL
+ ID (PK)
+ MEDICAL_ID
+ ...

TEST_LOG
+ ID (PK)
+ INDIVIDUAL_ID (FK to INDIVIDUAL)
+ TEST_ID (FK to TEST)
+ ...


If we're talking about to optimize the reporting, we should denormalize the database structure, that means to accept the data redundancy.
In that case, we can merge TEST and TEST_QUESTION into one table.

Hope this help for an idea.