Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Referential integrity
Andreas Moroder wrote:
> Hello,
>
> i have a big table with 25 fields that should be checked for their
> contents. Because I also need the description of this values I should
> build 25 table and activate referential integrity.
>
> When I go on this way I will end with hundreds of very small tables.
Shouldn't this be at MOST 25 tables??
>
> Is there another way to guarantee referential integrity ?
better database modelling.
>
> I tried with functional indices on one single lookup table, but they can
> not be used a foreign key.
>
> Bye
> Andreas
Go back to fundamental DB modelling. What entity does this table represent? What attributes do those 25 columns represent?
You give no descriptions for these 25 columns. Please provide at least an example of 3 or 4 of these fields. Are they merely 25 instances of the same type of data? maybe your table with these 25 fields needs to be normalized into multiple tables. With a little more information, your problem can likely be solved easily. having many tables is not necessarily a problem if they represent distinct entities.
ed Received on Thu Jun 01 2006 - 10:27:01 CDT