Can anybody tell me do i need to maintain CMR in following scenario... This is the table structure I have:-
divisioncode (Unique code)
$$A Division has many regions and a region belongs to a single Division
regioncode (Unique code)
$$A Region has many Units and a Unit belong to single Region
unitcode (Unique code)
$$ An Unit has many Dealers and a dealer belong to a single Unit
dealercode (Unique code)
$$ An Unit has many Service Centers and a Service Center belong to a single Unit
Table Service Center:-
sccode (Unique code)
And also tell me, for example, in table Region, is divisioncode a foregionKey or CompoundKey?
same is the question for other tables...
pls help as soon as possible..
Am waiting for your replies,