Re: Database Design

I suspect that "Benefit1", "Benefit2", etc. have actual names. I recommend you use something approaching the actual title of the benefit for your column title, i.e., OpticalBenefit, DentalBenefit, etc.

I also STRONGLY recommend you read a book on database design before starting this project. It will save you hundreds of hours (not to mention the education received).

"Mohan" <mohantrkm_at_yahoo.com> wrote in message news:95ff6b66.0212301428.f911cfc_at_posting.google.com...
> 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 Tue Dec 31 2002 - 13:54:08 CST