SQL Server Performance

Data Base Disign Issue (Table Relationships)

Discussion in 'SQL Server 2008 General DBA Questions' started by rohaandba, Jan 25, 2011.

  1. rohaandba New Member

    I have a 'Root' table with 8 columns.
    First 5 columns in 'Root table ' are used in all 10 child tables of that root table.
    I first wanted to make the first 5 columns of the 'root' table as Composite Primary key ,
    But the data thats going to come into the 5 columns will not be unique (like a column may have same hospital name with different patient numbers starting from 1,2,3----n in the patient column, When the hospital name changes in the 'Hospital column' then the 'Patient number' again starts from 1,2,3----n ).

    Note: Both the 'Hospiatal Name' & 'Patient number' are 2 columns among the 5 columns of the root table.
    So as per my requirement ,Client wants to use all the first 5 columns of the root table in other 10 child tables also.

    I am not able to do that as per the nomalization criteria.
    Can anyone please suggest me how to design.
  2. FrankKalis Moderator

    You don't need to start another thread on the same question. Let's keep the discussion here:
    http://sql-server-performance.com/Community/forums/t/32432.aspx

Share This Page