Home » RDBMS Server » Server Administration » Best_design_out_of2?
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
Previous Topic: Date formats
Next Topic: Creating a procedure in a different schema..Pls Help !!!Urgent !!!
Goto Forum:
  


Current Time: Thu Oct 22 03:51:59 CDT 2020