database-design - 创建关系数据库来存储问题及其选项

Question

我想创建数据库来存储问题及其正确答案的选项。我应该如何设计数据库，这样我才能得到所有问题的正确答案和选项。

I have created 2 tables
1.Questions(tablename):
   Columns are:
   1.QuestionID uniqueidentifier(PK)
   2.QuestionText nvarchar(500)
   3.IsActiveQuestion bit
   4.CorrectAnswerID uniqueidentifier(FK)
   5.UploadedBy uniqueidentifier(FK)

2.AnswerDetails(tablename):
   Columns are:
   1.AnswerID uniqueidentifier(PK)
   2.QuestionId uniqueidentifier(FK)
   3.Answertext nvarchar(200)
   4.IsCorrectAnswer bit

I want 
1. Question
2. It's options(Answers)
3. CorrectAnswer
4. IsActive

as a output

.

标签： database-design