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.
| 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 |
 |
|
|
|
|
|
Data Base Design Issue(Table Relationships)