SImple DB Design Question

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 

August 29th, 2015 1:15pm

My question is totally about Database design not the Standard its simple question and i need assistance in that regards
Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2015 2:52am

Hi Danish,

Seems your DB structure looks good. But still your question is not clear here. what i understand, when you are creating a report then getting 100 records for each questions, right?

Have you verified all records are same in report or some columns are different ?

Could you please share your report generating query for verification ?

September 2nd, 2015 3:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics