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 |
|
Nick
Posting Yak Master
155 Posts |
 Posted - 2001-12-13 : 15:35:25
|
| OK,I'm creating a database whose most important table will be a parts table. I have a small design question. Each part has x number of holes. Each hole has a particular minimum and maximum capacitance level. Some parts have only one range for all holes, some parts have as many as 5 different levels, based on the hold number.I'm at a loss at how I should store this data in the db. My inital thought was to have a parts table and then a separate table that stored the minimum and maximum level for each hold of the part. It would be associated with the parts table by putting the part number in the second table. Is this the best way to do it? Would there be a better way? |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2001-12-13 : 16:07:16
|
Unless there is something you arent telling us you're method sounds fine.Parts-----PartID (PK) PartHoles---------HoleNumPartID (FK)MaxCapMinCap(HoleNum, PartID PriKey) m2c,JustinEdited by - justinbigelow on 12/13/2001 16:08:13 |
 |
|
|
|
|
|
Database Design Question