In my Online Exam project, user creates a test,
Test contains different different subjects,
each and every subject having percent easy,percent medium,percent hard no of questions.
Test also have total no of questions. All Subject's total no of questions must equal to Test's total no of questions.
No worries if my above conditions are unable to understand.
I just want the most smart way to do it.
If it should do with multiple queries and check that query results in program and again do query if required?
Is it possible with procedures? if so give me sample.
Any other way?