create table response (
  -- models a possible response
  id	integer primary key,
  text	varchar
);

create table question (
  -- models a possible question
  id	integer primary key,
  text	varchar
);

create table offered_choice (
  -- models the offered choices to a question
  id		integer primary key,
  question	integer,
  choice        integer -- fk into response
);


create table questionnaire (
  id		integer primary key,
  position	integer,
  choice_set	integer, -- fk into offered_choice
  correct	integer -- fk into response
);

create table answer (
  -- models a given answer
  id		integer primary key,
  subject	integer,
  questionlet	integer,
  response	integer
);

create table subject (
  -- models a person taking a test
  id		integer primary key,
  name		varchar()
);