(Populate Quiz table) Create a table named Quiz as follows:

(Populate Quiz table) Create a table named Quiz as follows:

create table Quiz(
 questionId int,
 question varchar(4000),
 choicea varchar(1000),
choiceb varchar(1000),
 choicec varchar(1000),
 choiced varchar(1000),
 answer varchar(5));

The Quiz table stores multiple-choice questions. Suppose the multiple-choice questions are stored in a text file accessible from www.cs.armstrong.edu/liang/data/ Quiz.txt in the following format:

1. question1

a. choice a

b. choice b

c. choice c

d. choice d

Answer:cd

2. question2

a. choice a

b. choice b

c. choice c

d. choice d

Answer:a

...

Write a program that reads the data from the file and populate it into the Quiz table.