Dear all I have hierarchical database the database structure is below I have users into my application and these users are associated with different locations and these locations are cascade in nature ....

District----->populates------>Tehsils

Tehsils------>populates----->UC

UC------->populates------>villages

For that purpose I have created 5 tables

User(userid(P),UserName)

DistrictAssociation(districtID(P),DistrictName,UserID(F))

TehsilAssociation(TehsilID(P),TehsilName,DistrictID(F),UserID(F))

UCAssociation(UCID(P),UCNAME,UserID(F),TehsilID(F))

VillageAssociation(VillageID(P),VIllageName,UCID(F),UserID(F))


This is good enough for population of records for saving what i have to do should i have to create a single table or what ???