Re: Help: Design the database for a school

emdproduction_at_hotmail.com wrote:
> Brian,
>
> Thanks for your reply. I think what I asking is like this:
> Will it be OK for a table has a huge number of columns as long as long
> as I follow the 1st, 2nd, and 3rd normalization? Or should I make this
> huge-column table into several tables with less columns?
>
> Thanks

Oracle does have a limit to the number of columns a table can have. That limit varies depending on your version. In reality, most people do not reach this large limit.

As a general rule of thumb, follow 3rd Normal Form when doing your design. This will help ensure you do not have data anomalies. I only de-normalize to 1NF or 2NF if I have a specific reason to do so, but that is very rare.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown