Skip to Content
0
May 15, 2008 at 09:11 AM

Relationships between tables

8 Views

Hiii,

Can anybody tell me do i need to maintain CMR in following scenario... This is the table structure I have:-

Table Division:-

divisioncode (Unique code)

divisionname

$$A Division has many regions and a region belongs to a single Division

Table Region:-

regioncode (Unique code)

divisioncode

regionname

regionalmanagerID

$$A Region has many Units and a Unit belong to single Region

Table Unit:-

unitcode (Unique code)

regioncode

unitname

areamanagerID

salesofficerID

$$ An Unit has many Dealers and a dealer belong to a single Unit

Table Dealer:-

dealercode (Unique code)

unitcode

dealername

$$ An Unit has many Service Centers and a Service Center belong to a single Unit

Table Service Center:-

sccode (Unique code)

scname

scaddress

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,

reagards,

Amey