A piece of paper sheets (test ID, student ID, status 0 is not take an examination of, 1 is already tested)
A student table, a collection table (the test ID and student ID)
Students query their own collection of examination, if the collection table has the student ID and to determine the test table to have the student ID, if there are shows that the state has to take an examination of, didn't appear already collection module, if there are no students table inside the paper ID, shows that there is no test, only collect the display in the collection module,
SSM framework, MySQL database
I also how to write the query?
