Database Design

Hi All,

I am a VB developer developing a new client server application using VB and Oracle 8i.

Please help me in designing database table for the following screen where the user will select the required benefits. The benefits are grouped and listed under different categories  

For example Under Category 1 there will be Benefit1, Benefit 2, Benefit3,...., Benefit 8 and Other Benefit. For each benefit a checkbox will be provided and user can select as many as benefits. If the user selects "Other Benefit" checkbox user have to enter a new benefit inside a textbox.

Like this there will be some more 7 or 8 categories.

The table will get atleast 1000 rows a day

In this scenario
1. I proposed a design with one column in table for each checkbox in the screen. If a checkbox is selected "1" will be stored in the corresponding column else "0" will be stored. For the checkboxes with caption "Other" the text entered in the text box will be stored

2. My colleague suggests to use nested table for each category

3. Is there anyother good solution?

4. What are the pros and cons in using nested table for VB app?

Can anyone please suggest me a solution which will be good for programming and reporting

Thanks in advance
Mohan Received on Mon Dec 30 2002 - 16:28:51 CST