Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Dec 21, 2011 11:07 AM|LINK
Im doing a multiple choice online test project. It needs to be well structured. At the moment, Im in the very early stages of the project life time. I have designed a database structure but unsure if it is a solid desgin.
Single exam can consist of multiple sections.
Allow for different language versions of single exam.
Allow for unlimited number of answers.
Allow for specifc ordering of answers - eg, to allow for "1,2,3, all of the above"
Ensure that correct answer cannot be identified by viewing source (eg lowest ID is correct)
Maintain details of all users' attempts.
My initial design:
TestID FK from tbl_Tests
TestSectionID FK from tbl_TestSections
QuestionID FK from tbl_Questions
Note: tables tbl_Users (stores users with their UserID) and tbl_Locales (stores locale languages with their LocalLangID) already exist.