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 |
|
ashokghr
Starting Member
5 Posts |
 Posted - 2001-07-12 : 12:44:35
|
| The Tables involved are "CityClass"(CityClassCode(PK), Description) and "CityParams"(CityClassCode(FK),RuleCode(FK), Amount). PK(CityCLassCode,RuleCode)Amount would be selected based on the rule assigned against each CityClassCode. Till this point there is no issue in terms of Table design. But the problem is that we need to store a Amount for "OTHERS" Category. What I mean by "OTHERES" is that if for some cityclasscode, there is no rule and amount is defined in the CityParams table, then use the Amount defined for "OTHERS" category. This others category is not defined any where. We are not able to figuer out as to how tables should be modeled(designed) in order to store a Amount for All CityClassCode not defnied in the CityParam table.Any Suggestion ?Thanks in advance |
|
|
|
|
|
Design Issue