CREATE TABLE respondent (
    id unsigned int not null auto_increment primary key
   ,name varchar(20)
#  , etc ...
);

CREATE TABLE response (
    id unsigned int not null auto_increment primary key
   ,name varchar(20)
);

CREATE TABLE responses (
    respondent unsigned int
   ,response   unsigned int
   ,PRIMARY KEY (respondent, response)
);