Best_design_out_of2? [message #369191] |
Thu, 06 April 2000 15:29 |
Manish Shah
Messages: 1 Registered: April 2000
|
Junior Member |
|
|
I've an implementation question for creating tables. Their are 2 design which one is best?
Design1:
MasterTable1(Key p11,p12, p13, p14);
MasterTable2(Key p21,p22, p23);
ChildTable1(c11,c12,FKey p11,p12,p13,p14,p21,p22,p23);
childtable2(c21,c22,FKey p11,p12,p13,p14,p21,p22,p23);
Design2:
MasterTable1(p11,p12, p13, p14,Key UniqID1 );
MasterTable2(p21,p22, p23,Key UniqID2 );
ChildTable1(c11,c12,FKey UniqID1,UniqID2);
childtable2(cc21,cc22,FKey UniqID1,UniqID2);
My basic question is should I carry over entire list of common column to set of tables or just one uniqID.
I'll appreciate if any one can reply in this matter.
Thanks,
Manish Shah
mshah@xybion.com
|
|
|