I want to make MCQs Exam System on asp.net with C# and sqlserver. I really confuse that how to make database though i have designed plenty of tables(ERD attached ). I have to deploy this web application on local universities LAN environment not want to online (due to student monitory problems). In this system all work will do admin. Student can only attempt test (in specified day and time) and watch result. all the student info will be submit by admin. Student only need to select TEST CODE and enter his/her SEAT NO to attempt test and i also want to generate result automatically.
Please provide me a better way to do this job i have check on google but didnt find suitable answer