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

The purpose of the online exam is to provide a good online test and save time for document verification. The main purpose of the online exam is to efficiently evaluate the applicant completely with the help of an automated system that not only saves time, but also provide the results quickly. In this way help students to present their role according to their convenience and utility of paper and pen.


The main purpose of the online exam is to efficiently evaluate the applicant completely with the help of an automated system that not only saves time, but also provide the results quickly. In this way help students to present their role according to their convenience and utility of paper and pen. The scope of the online exam project is so great in terms of manually taking exams. Some of them are listed below: It can be used in education as well as in the world of business. There is facility to use it anywhere and anytime because it is a web-based application. The location of the user does not affect the application. There is no restriction that the controller or examiner has to be present when the assessment is doing the exam. FEATURES: 1. Safety 2. Easy to use 3. No controller or examiner need.