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 |
|
russray
Starting Member
27 Posts |
 Posted - 2008-02-26 : 16:01:02
|
| I am new to SQL Server 2005. I have tried to be a good student and learn on my own about designing the database. However, I am facing a blockage of getting data into the database. I want to verify I have setup the relationships correctly. Here is the tables.1. A Manufacture has an Address.2. A Manufacturer has one or more Distribution Points.3. A Distribution Point has an Address.The Manufacturer --> Address is a one-to-one relationship.The Distribution Point --> Address is a one-to-one relationship.The Manufacturer --> Distribution Point is a one-to-many relationship.The manufacturer table has a FK to the address id (PK).The distribution table has a FK to the address id (PK).The distribution table has a FK to the Manufacturer id (PK).Address has several other FK, but not used in this scenario.The INSERT and UPDATE Specification for the Delete Rule and Update Rule is set to "No Action" for the Manufacturer and Address tables. In the Distribution Point table, the relationship for the update rule involving the relationship with the Address and Manufacturer tables is set to CASCADE. What this tells me is SQL Server 2005 will update the table should changes occur in Address and Manufacturer table.Is there anything else I can check to be sure the issue I am facing is NOT the deisgn of the database?Thanks for taking the time to read my post.Russ |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-27 : 01:26:41
|
| How are you handling the "A Manufacturer has one or more Distribution Points" , I would have thought there is a 4th table "Manufacturers_DistributionPoints" , basically a join table between ManufacturerID and DistributionIDJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
Relationships Correctly Designed?