By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,874 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

Database Design Help

P: 1
Hi to all,

i am currently doing a web application. I have a form that contains about 100 radio button and 100 checkboxes. my question is, how do you design it in the database table? should i make 200 columns (100checkbox,100 radio button)? Need help on how to design this. Thanks.
Apr 29 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 534
Your database design should not depend on what you have on the GUI.
Having said that I admit that sometimes we make decisions based on convenience (but this comes much later in the game, when we de-normalize our perfect design :)
In the beginning you have to think about organizing and normalizing your data. In the end these 200 inputs may be saved in one, or two, or any number of tables.

Get a book on the database design, or Google this topic, there are plenty helpful articles on the web.
Once you have some ideas we can talk about your options and solutions.
Apr 30 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Check out this tutorial

Normalisation and Table structures

Mary
May 3 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.