RSS Forums RSS
Please support our Database Design advertiser: Programming Forums

Best way to develop db for survey?

Join Date: Apr 2004
Posts: 321
Reputation: bentkey is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 8
bentkey bentkey is offline Offline
Posting Whiz

Re: Best way to develop db for survey?

  #2  
Jul 22nd, 2004
Assuming you are not keeping any information about the person taking the survey, it sounds like a 3 table relational database. The first column would be your survey questions. The 2nd table would be your possible answers to all questions. Your 3rd table would only hold a field relating to the primary key of your question table and a field relating to the primary key of your answer table and a quantity field. I would probably give it a primary key also, because I always do. Make these primary key fields auto generated. When a person makes a selection, a new record is added that links the question to the answer along with quantity. You add a lot of very small records, but that's much more efficient than having huge records. And I'd find something other than Access if you plan to have very many people take the survey.
bentkey MCSE,CCNA

SupportWindow Remote Desktop Software
Bytewiser Data Systems
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 6:18 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC