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
244.1k
Database Design Requirements
Dec 31 2014 5:01 AM
I have a business Application in which I have Users and There are two types of users (admin,Basic)
There are questions into the system and Questions have types like,single value question,Twovalue Question,FourValue question, the admin role is to assigned targets to these questions like below example
Q#01:No of Schools build into the village
1) ForBoys_______ 2)for Girls_______
The above example shows that it is two value question
for example the admin assign target to above question he set the target value of 40 schools for boys and 45 for girls so the target of first question is 40 for boys and 45 for girls .
Below is the example of four value question types
Q#02:Number of hospitals build into the city
1)For Boy ______ 2) For Girl 3) For Men ___ 4) for women
This is the four value type questions
For example the admin set the target for boy(22) for girl(88) for Men(50) for Women(67)
Now the Basic users have to answer these question means they have to answer each question against its target value
please let me know about the database structure its table and relationship
Reply
Answers (
1
)
primary key and unique key in sql which is better
I have a stored procedure with a select query