Re: Database performance while choosing no of tables

Harsh_forC wrote:
> Hi,
>
> I have got 3 subjects namely Maths, Physics and Chemistry.
> I have multiple choice questions in each subject.
>
>
> I want to create columns 6 columns namely Question, Choice 1, Choice
> 2, Choice 3, Choice 4 and Answer.
> But each subject has got the same table structure( same columns).
>
>
> Now what should I do?
>
>
> Should I maintain one large table inserting all questions into it
> having a distinction
> for each subject( by adding another column which relates question to
> subject) ??
>
>
> Or should I maintain 3 tables for each subject, each table having 6
> columns?
>
>
> Will the performance increase if I maintain 3 tables instead of 1
> large table?
> Or it has got the same effect?
>
>
> What if I got many subjects, say 100?
>
>
> Please someone solve my problem!
>
>
> Thanks

This is schoolwork and you need to solve the problem yourself.

But here's a hint to help you make the right decision: http://www.psoug.org/reference/normalization.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org