28-02-2015, 09:45 PM
Hello,
I am developing an android app for online examination so, i need help on designing the database structure. Details of my project are as follows..
There are 3 levels, at the time of registration student will select one of the levels, & levels are :-
1)Entrance,
2)Intermediate,
3)Final.
After the registration student will be able to view and appear for examination only for which level he/she have selected at the time of registration.(For ex. if student select "Entrance" level at time of registration then he/she will be only able to view and appear to exam for Entrance Level only.)
There are different subjects for every level and each subject have different chapters and every chapter is having many questions(about 200+). So, the structure will be as :-
1)Entrance:-
......Subject 1:-
.............Chapter 1:-
.....................Question 1,
.....................Question 2,.....Question(n)...
.............Chapter 2:-
.....................Question 1,
.....................Question 2,.....Question(n)...
.............Chapter(n):-
.....................Question 1,.....Question(n)...
.......Subject 2:-
.............Chapter 1:-
.....................Question 1,.....Question(n)...
.............Chapter(n):-
.....................Question 1,.....Question(n)...
and the same for all levels.
Thanks in advance