Questionnaire Database Design

June 23, 2011

Questionnaire database design gives a general guideline as to how the database can be created for purposes of storing data. The most commonly used design is the horizontal approach which allows users to insert new data records as table columns that are presented horizontally. The structure is predetermined and it allows easy access to stored data.

The questionnaire database design can also assume a vertical approach even though most people find it difficult to work with.

The questionnaire database design helps one to enter and store data more easily.

Below is a sample questionnaire database design.

Sample Questionnaire Database Design

Respondent ID —————————————

Primary Key     —————————————

Questionnaire ID ————————————-

Question type

———————————————————-

Question options

———————————————————

Field Name: Question one

————————————————————

Field Name: Question two

————————————————————

Field Name: Question three

————————————————————

Field Name: Question four

————————————————————

Field Name: Question five

————————————————————

Table : Table one

Field: Respondent ID

———————————————–

Field : Question ID

———————————————-

Field Response

———————————————–

Table : Table two

Field: Respondent ID

———————————————–

Field: Question ID

———————————————-

Field Response

———————————————–

Table: Table three

Column Name ——————————

Respondent ID ——————————

Data type ————————————-

Integer —————————————–

Column name ———————————-

Question ID ————————————-

Data type text —————————————————————————

Column Name —————————————-

Response ———————————————-

Data type: Yes or No

—————————————————

Respondent ID ———————————-

Question ID ————————————–

Query one ——————————————–

Respondent ID —————————————

Response ———————————————-

Query two ——————————————–

Respondent ID —————————————

Response ———————————————-

Query results

—————————————————————————

Question ID

—————————————————————————

Group by

—————————————————————————

Procedure notes

———————————————————————————————————————————————————————————————————————–

Question ID

————————————–

Response

————————————–

Index

—————————————-

Download Questionnaire Database Design in Word Format

 

Top Sample Questionnaire:

Leave a Comment

Previous post:

Next post: