Part II:
1. Create a database named javabook in MySQL.
2. Use MySQL to create two tables as follows:
create table Question (
questionId int not null,
question varchar(250),
constraint pkQuestion primary key (questionId));
create table Survey (
questionId int not null,
ipAddress varchar(40) not null,
answer bit, /* bit is a MySQL boolean value */
time date,
constraint pkSurvey primary key (questionId, ipAddress));
2. Write a JSP that displays the questions. Each question
accompanied by two radio buttons for the user to select as
Yes or No. When the user clicks the Submit button, the
answers will be stored in the Survey table and the current
survey result will be displayed.