Database Design Help

[cactuar]

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,10 0 radio button)? Need help on how to design this. Thanks.

[michaelb]

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.

[MMcCarthy]

Check out this tutorial

Normalisation and Table structures

Mary