Feedback for SQL DB Design -


i'm trying design database application users can submit , take tests.

here got far:

http://i.stack.imgur.com/pgf7m.png

i'm particularly unsure relation between test_testee , questionanswer_testeeanswer. need way connect answers & questions & tests, i'm afraid solution came bit naive.

if can see wrong design, or if different please so, i'm looking general feedback.

thanks!

it feels little off.

the testee should take test (one or more times) - possibly shown in test_testee.

for each taking of test, testee should have 0 or 1 answers each question:

this link between test_testee , question includes given answer... 1 table.


Comments