I have a simple Application In which i have users and these users are associated with some Villages mean that while creating their account they have been assigned some villages the rule is simple (one user can have one or many villages )
in my Application I have a questionnaire and there are many many question Each question Has a target value as well as achieved value (the target value is set by the supervisor of the person) and the achieved value is what the user achieved
The DB I have created is like that
Users(userID(P),UserNAme,Email,)
Villages(villageID(P),VillageName)
District(DistrictID(P),DistrictNAme)
Questions(questionID(P),Question_Text)
QuestionTarget(REcordID(P),QuestionID(F),TargetValue ,DistrictID(F))
Answers(AnswerID(P),Question_ID(F),Achieved,VillageID(F))
Check the Attached image and tell this db is correct the details is in image availble
below the url to see the attached picture of my DB desing
http://tinypic.com/r/1hcjye/8[
^]