Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Data Base Design Issue(Table Relationships)

Author  Topic 

rohaandba
Starting Member

33 Posts

Posted - 2011-01-25 : 10:11:55
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.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-01-25 : 10:21:14
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=155649
Go to Top of Page
   

- Advertisement -