I am started doing a project :- Online Exam in ASP.NET with C#, database:- SQL Server
The exam consists of different sections such as Reasoning, Quantitative Aptitude & Numerical ability, English and Mathematics.
The exam is of objective type like fill in the blacks, option type and passage type.
The question table consist of the following columns:
Qid,Question,Option1,Option2,Option3,Option4,correctAnswer
The problem is how do I store passage type questions and answers in table??Because it will contain one long passage and based on that more than one questions will be asked with multiple choice options.