TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Danish Habib
NA
694
241.3k
Database Query
Dec 20 2014 11:16 AM
Hi , I have a database design question ,the sceniro is given below i want to ask how the database design would be which tables and columns and their relationship is .
1-I have users into the system and each user have assigned some question for which he/she has to answer .
2-Question are of two type one is single values and other is multi values
i.e. Number of schools established in villages
1)for boys _______(some value) 2) for girls _____(Some values)
the above question type is multivalue
Now the single value question is
i.e. No of hospitals established in villages
______(some number) this is single value
The user has to give answer about them
how to create database tables and their design and schema
I already knew the total question and their type and as a bad approach i made a table of carrying all question
below are the table information which i made
Question table:
1-Question01,Question01Forboy,Question01Forgirl,Question2,question3 ETC
Answer Table
AnswerID,QuestionID,ForBoy,Forgirl (this table contains four columns if even the question is not of type multivalue then these columns contains nulls )
Reply
Answers (
1
)
How to create word document in read only mode programmatical
how to stop url printing data in mvc 4 ?