Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> A normalisation issue

A normalisation issue

From: Stratos <seb6_at_bton.ac.uk>
Date: 11 Aug 2003 05:14:20 -0700
Message-ID: <6d926bff.0308110414.98c0e4a@posting.google.com> 





Hello,


I want to ask you a question about normalisation.
I have got a long table with 8 fields(mandatory) that always store a
value, and 20 fields(optional) than can either get a NULL or non-NULL
value.



Is it better to split this table up into two tables, one having all
the


mandatory fields and the other one having all the optional fields? Or
is


it fine to leave this table as it is?


Thank you.
Received on Mon Aug 11 2003 - 07:14:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US