I have created table Question with 3 types : (FindBug, Fillblank, MultiChoice ) but each of type has a different answer type and question type .
In Database I save a question and answer for each type questions like this:
- Find Bug Question : answer (width, height, top, left by a bug)
- Fillblank : question (ListChoiceA, ListChoiceB, ListChoiceC) Answer (correct A, CorrectB, correct C)
- Multichoice : question (ListChoice) Answer (answer A)
I don't know how to normal my database with SQL 2008, I have created a big table with saving all of this attribute and I attach images for table Question
CREATE TABLE [dbo].[tblQuestion](
[QuestionID] [int] NOT NULL,
[QuestionDif] [int] NULL,
[QuestionSrc] [nvarchar](50) NULL,
[Type] [nchar](10) NULL,
[Positionwidth] [nchar](10) NULL,
[Positionheight] [nchar](10) NULL,
[PositionTop] [nchar](10) NULL,
[PositionLeft] [nchar](10) NULL,
[ListA] [nvarchar](50) NULL,
[ListB] [nvarchar](50) NULL,
[ListC] [nvarchar](50) NULL,
[A] [nchar](50) NULL,
[B] [nchar](50) NULL,
[C] [nchar](50) NULL,
[ListAnswer] [nvarchar](100) NULL,
[Answer] [nchar](50) NULL,
and this is image of this table
<img>https://fbcdn-sphotos-a-a.akamaihd.net/hphotos-ak-prn2/t1.0-9/10004017_272448229590981_2128351427_n.jpg</img>
Could you please help me make this data more clearly and be logical