> > design 1 is normalized and better > > design 2 is denormalized and a bad approach no matter the RDBMS > > How is design 1 denormalized? It isn't :)...he said it is normalized. Design 2 may or may not be de-normalized (IMO there is not enough information to make that determination) but as stated it's a good idea to split the table on practical grounds. merlin
