Home Forums SQL Server 2005 T-SQL (SS2K5) Database Design question regarding Normalized Tables RE: Database Design question regarding Normalized Tables

  • First step is to be certain about whther the relationship is 1:1 or not.

    If you are certain the relationship is 1:1 and you are wondering about the benefits of splitting them into another table, the name for this is 'vertical partitioning'. If you do some research on vertical partitioning you may find some ideas to help you.

    If you are not certain the relationship is 1:1.... then do some anlysis and business process modelling to work this out for certain.