relationship between area table

[ofir0803]

Hi

I am trying to design db to coupon site
my problem:
item can be in several areas.
like : chair in South and North
for that I have created the extra categorytoarea table but i dont know how the relationship should be with other tables

[ofir0803]

Hi

I am trying to design db to coupon site
my problem:
item can be in several areas.
like : chair in South and North
for that I have created the extra categorytoarea table but i dont know how the relationship should be with other tables

please help...

[ChrisPadgham]

if you are saying that the item is to be available in multiple but not necessarily all areas then you need to create a new table call ItemArea, for example.

ItemArea (ItemAreaId, AreaId, ItemId)

then change the relationship to insert this table between Item and Area in you model.