
December 10th, 2012, 04:01 PM
|
|
|
|
Database design questions
I have few questions that i would like to ask:
1. If i am creating a system whereby there is a hierarchy of users (i.e. students, teachers, manager). should I store this in one table or three? avoids having to self join again and again to get relevant info?
2. if i need a system whereby I can set some questions and answers, or questions with multi-choice answers. How best should I store them?
Class_id, question_id,question,answer (for Q&A)
class_id,question_id,question,answer (for multiple choice Questions)
question_id,choice
|