-
Database Design issue
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 ???