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.