Multi Choice Database Task

Database Setup

You have been contacted by the school to develop a database solution for a new Multi Choice Testing System.

You task is to design and develop a database using libre office.

Your database should provide for the following functionality

  1. Store Questions including the fields: Question Text, OptionA, OptionB, OptionC, OptionD, CorrectAnswer, SyllabusTopicNumber
  2. Store Answers including the fields: StudentID, QuestionID, StudentAnswer, Mark
  3. Store Students including the fields: FirstName, LastName, YearLevel