Hai frnds.

I started doing a project for my college online Examination
This project is exclusively for college for conducting Aptitude and Reasoning test.
There are 2 groups MBA MCA and these 2 are divided as
MCA I yr
MCA II yr
MCA III yr
MBA I yr
MBA IIyr

Our aim is to conduct exam for these 5 groups.
we need to store the questions in database and retrieve them randomly and keep track of the previous exam questions i.e., once if we conduct exam for MCA I yr with 20 questions those questions shloud not be given to them again and those questions can be given to remaining groups

So for Example if there r 100 questions in database we can conduct 5 exams eaxh with 20 questions

Can anyone please tell me how to design the database
The management should get student wise reports class wise reports

Suppose if we have questions like say giving a paragraph and asking 5 questions related to that para how can we store such type of questions

Can anyone Help me complete this project