Analyzing data to go into a DB

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

PVD2003

Thread Starter
Joined
Aug 22, 2003
Messages
34
right, im a total novice at this.. ive been given a little homework should we say. a questionaire regarding the topic about travel to, and from school ie walk cycle, car etc, that is issued to parents to fill in.

this questionaire has now got to be converted to a database..how do u go about extracting the data/information and convert them to tables and attributes...

i realise this is quite a vague question and prob not easy to answer so if anyone has any websites that show u basics of table design i would be grateful.

My mind cant get round the concepts of entities and relationships either!
 
Joined
Aug 13, 2003
Messages
832
You will need to set the tables up first and then import the data. What platform are you using?
 

PVD2003

Thread Starter
Joined
Aug 22, 2003
Messages
34
perhaps i wasnt entirely clear... i have a paper questionaire with around 10 questions on it that will be issued to parents.. when i mean extract i mean take out the information that is important and think about how that information would be represented in a db. (Access).

so at the moment this is a paper excercise. anyone that has done any Entity relationship modeling at school/college would prob know more what im talking about...

or systems analysts...
 
Joined
Feb 12, 2001
Messages
3,420
I just have a hard time helping you with "a little homework should we say". How about you tell us what you think, put some effort into it, and then maybe we can help you figure it out.
 
Joined
Aug 13, 2003
Messages
832
PVD2003,
I understand what you are asking about. Seems like you are putting a lot of thought into a very simple database. I'm not sure what version of Access you are using since you are not very forth coming with that info but there should be a sample database that will more than cover your needs. Also, check the Access 'help' file for detailed info.
 
Joined
Oct 9, 2003
Messages
252
Hi:

I have quite a bit of experience in setting up databases. I must admit I am not a fan of Access. I use FileMaker. But the concept is the same.

If you have a copy of one of the questionnaires, post it here and I can make you a simple database. Some quick planning would be involved, but I don't think an E-R diagram is necessary, as this would only need one table (I think)

Ken
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top