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 |
|
midi25
Starting Member
24 Posts |
 Posted - 2005-08-16 : 09:38:26
|
| Hi I am designing a db design. I have extracted Entity names from a use case. But I cant decide whether this is a one to many or many to many relation. How would you tackle this . Thanks. =======================================================My entitys are called Manufacturer and Supplier Supplier Entity. A supplier is realted to a manufacturer. Other suppliers may be related to the same manufacturer.eg supplier Dell sells HPsupplier Microsoft sells HP Manufacturer Entity. A manufacturer may have many different suppliers. HP is supplied by Dell HP is also supplied by Microsoft |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-16 : 09:50:11
|
| if one supplier can have many manufacturers and one manufacturer can have many suppliers, it s a many to many and you will need an intermediary table.====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
|
|
|
One to One or Many to Many please help