Re: implications of merging 17 tables into 1...

Here is one possible scenario that describes to an extent, the changes: Say that there are 5 tables and they are related by 4 referential constraints (I am taking 4 as just one number, there could be more relations, but for example say 4). Now when we compress these 5 tables into one table, how is does the ref. integrity is taken care of? Does the data get exposed to some risk of corruption?

Perhaps in the same table, there can be ref. keys referring to the same table (like mgr referring to empno in the emp table of scott schema) but in that case, when we do that for more than 10 relations, wouldn't that introduce much complexity? Can you please share your views on this.

Thanks,
Nirav Received on Wed Jun 27 2007 - 08:48:59 CDT