Database Design query

Question

1.00/5 (1 vote)

See more:

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[^]

Posted 29-Aug-15 9:05am

Malikdanish

Add a Solution

Comments

jgakenhe 29-Aug-15 15:25pm

The design is probably right, but you aren't showing the relationships or cardinality.

Malikdanish 29-Aug-15 15:47pm

check the link for Relationship , this gives incorrect record set may be due to the reason for one row of question target table i have many rows in answersnew table
http://tinypic.com/r/206iipv/8

jgakenhe 29-Aug-15 16:09pm

It looks correct. The only thing that looks a bit off is the QuestionTarget. If a user has 1 to Many QuestionTargets and a QuestionTarget has 1 to Many Questions, and each Question has 1 to Many Answers, then it is correct.

You'll know if there is a problem when you start testing it. If you can't get the data out accurately through a query, then you'll need to make revisions.

Malikdanish 30-Aug-15 0:12am

There is one questionTarget and for this questionTarget there are many Answers that is the rule so
see the picture
calculate the sum of QuestionTarget column from QuestionTarget table and calculate the sum of QTotal Column from the AnswersNew table see the picture for tables data
link of picture is http://tinypic.com/r/2cxys2f/8

Jörgen Andersson 8-Sep-15 1:53am

I'm wondering over the connection between District and village, they are both usually geographical entities and should normally have a direct relation, and not via a user.

Malikdanish 8-Sep-15 3:10am

they have there direct relation in their own table , this table is secondary table and the district and village id is foreign key here and primary key in their own table

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2015-08-30T06:47:00

Database design completely depends on your understanding of the requirements. We can't say something is right or wrong.

Because one thing can be designed using one table and that thing again can be designed using 100 tables. Depends exactly on your perception and requirements.

I thing you have designed it well. But I think the two tables can be combined. The only thing which is different is the target value and achieved value, which can be two columns in one table. See if you can do that.