Question

Please create few tables that meet the following requirements.

Will definitely thumb up and appreciate that!!!

Requirements:

1. Support an arbitrary number of quizzes, not just 1
2. Support quizzes with a varying number of questions. (All quizzes do not have to have the same number of questions.)
3. It will be possible to add or remove a question from a quiz
4. It will be possible to print a quiz with a particular student's answers (a finished quiz), or without the answers (a blank quiz for someone to take)
5. It will be possible to answer each question with a single answer or list of answer (such as types of music, or operating systems)_
6. It will be possible to store information about a student (such as name and academic level), and about a quiz (such as the date of the quiz)

Answer 1

Below are the required tables and their schemas:

1. student: To store student information like name and academic level.

Column	Type	Description
student_id	Integer	Primary key
name	Varchar	Name of student
academic_level	Varchar	Academic level of student

2. quiz: To store quiz information like date and subject. Any number of records can be entered to this table which means arbitrary number of quizes is supported.

Column	Type	Description
quiz_id	Integer	Primary key
date	Date	Date of quiz
subject	Varchar	Subject of quiz

3. question: To store questions and their mapping with quiz table, i.e. which quiz each question belongs to. For a particular quiz_id, any number of question records can be inserted or deleted which means for a particular quiz questions can be added or deleted.

Column	Type	Description
question_id	Integer	Primar key
quiz_id	Integer	Foreign key to quiz table
q_content	Varchar	Content of the question
marks	Integer	Marks that the question carries

4. answer: To store information of which student answered which question and what was the answer. One student can have multiple answer records for the same question to answer questions like list of operating systems etc. Once can look up all the question_id for a particular quiz from "question" table and then look up their answers for a particular student_id from this "answer" table to get all the answers of a particular student for a particular quiz.

Column	Type	Description
student_id	Integer	Foreign key to student table
question_id	Integer	Foreign key to question table
a_content	Varchar	Content of the answer