Dear , I am developing a web application In which i have users , the user have the following information
User(ID(P),Name,EMail,Password,SecutiryQuestion,SecurityANswer,District,TEhsil,UCS,Villages)
Now All other infromation is simpler one but the district ,tehsil,ucs,villages are cascade in nature mean that one district can have many Tehsil,one tehsil can have many UCS, and one ucs can have many villages they are cascade in nature ,
I have placed checkboxlist item for all of them and created four tables first for district(Districtid(P),DistrictName)
Tehsil(TehsilID(P),TEhsilName,DistrictID(F))
UC(UCID(P),UCNAME,TehsilID(F))
VILAGES(VILLAGEIF(P),VIllageNAme,UCID(F))
and i am populating them based on there checkboxlist value selection Now for saving a single user i have these rules
1-One user must have one or more districts
2-one user can have no or many TEhsils
3-One user can have no or many UCs
4-One user can have no or many Village
For user information I have created a table (userid(P),Name,EMail,Password,SecurityQuestion,SecurityAnswer,DistrictID)
and another details table where i have userid as foreign key
UserDetails(Userid(F),RecordID(P),Districtid(F),(TEHSILID(F),UCID(F),VIllageID(F))
tell me this structure is good for inserting and showing checkbos list on edit as well or not