Database considerations for students tests application

I need to refactor system, where students are watching slides, lectures and doing tests, where their knowledge is being check.