Table design for Option button form

Question

Hello Friends I have a form with many fields with yes/No anddetails as follows..Please suggest how i can go for table design Cultural : Yes(Option Button) No(Option Button) . Details........... Spiritual: Yes(Option Button) No(Option Button) . Details........... Others: Yes(Option Button) No(Option Button) . Details........... Please suggest. I want to store option button value and Details in saperate table. Thanks.

Nilesh Shah · Answer

simplest design is to have columns named Cultural Spiritual and Others as bit which allows only 1 or 0 and Details as text/varchar. Column Name Data Type Comments AutoID int auto-generated PK Cultural Bit Spiritual Bit Others Bit Details text

Nitin Sontakke · Answer

I don't think I quite understand your question but here is a generic thing to keep in mind. There have to be ABSOLUTELY NO RELATIONSHIP between how the data is stored and how it is represented on the screen. You can perform all the required transformation you need after it leaves the storage engine and before it reaches the UI. While storing the data all you worry about is integrity normalization performance minimum storage accommodating future enhancements etc.

Kailash Salvi · Answer

Hi Niilesh Thanks for the answer. but with the same table structure if we want to bind this table data to view in MVC then to bind this we have to add condition on every textbox. how we can do that then?