plan

User Table:
UserID(pk)

Survey Table:
SurveyID(pk)

Question Table:
QuestionID(pk)
SurveyID(fk)

Answer Table:
AnswerID(pk)
QuestionID(fk)
Mark

Result Table:
AnswerID(pk)
UserID(pk)

Role Table:
RoleID

UserRole Table:
RoleID(pk)
UserID(pk)


requirements:
1.send surveys to people who answered certain surveys
2.finish a question's sub-questions based on the choice
3.send questions to people who answered certain questions
4.send questions to people who answered certain answers
5.send questions to people who belongs to certain group
6.send questions to people who got certain marks for a certain survey

posted @ 2008-05-09 13:31  N/A2011  阅读(205)  评论(0编辑  收藏  举报