Database design - relationships

D

Darren

I am trying to construct a database to house survey questions that are
imported via excel.

The data from excel comes with the following column headings

SurveyID Location Date Q1 Q2 ....... to Q60

My question is how to link these question answers to the actual survey
questions in another table.

My problem is that I need the structure of this table to have the following
column headings:

Question# Questiontext

Because these questions get grouped by larger measures.. ie. the first 5
questions are for one goal.

How can I link these tables without having an individual table for each
question?

Any help would be greatly apreciated.

Darren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

table design and relationships for housing survey questions 9
set up tables relationship 12
database design for survey 10
A many-to-many challenge 1
DB design help 3
can someone please tell me if my table design will work? 0
Table field length limit alternative 8
Database design question - best practice to store survey answers 2

Top