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 |
|
de4ever@gmail.com
Starting Member
36 Posts |
 Posted - 2010-03-19 : 01:35:35
|
| Hi All,I am having difficulty in designing some table.Scenario is : I have some matterials and theier specification.Each matterial has differenct types of specifications .Eg . Matterial1 has Spec1,Spec2,Spec3..SpecN specification ,Mattrerial2 may have n diferent specifications. So how can we design tables for these objects.Waiting for reply thanks |
|
|
bhaskarvarada
Starting Member
8 Posts |
Posted - 2010-03-23 : 08:39:37
|
| Hi de4ever, you can create the many-many relationship 1.Create the materials table for storing material realted details. 2.Create the Specification table for storing Spec realted details.3.create another table where you store the Primary key's of material table and Spec table |
 |
|
|
|
|
|
Database design probs