Quote:
Originally Posted by salmanmanekia
Should i make another History table for it such as AnswerHistory ??.
|
probably. almost surely. But it depends on what the requirements of the homerwork assignment are. In a real-world situation I would say absolutely "yes.".
Quote:
|
If also possible please explain in broader terms i mean taking into concerns all the table and also mention the design factor and queries whenever possible.
|
Really not sure what you are asking here. I do feel you are making a mountain out of a molehill.
What have you designed, so far, for the Questions and Answers tables? And do you also have a Students table and a StudentScores table? Or some other similar tables?