Question
You are hired to design database to be used with an online survey tool. This tool can create questions of several types. Users can log
You are hired to design database to be used with an online survey tool. This tool can create questions of several types. Users can log in and take a survey. Survey can be anonymous or attach to a particular user. The requirements are given below. User information must be stored in the system. Username, password, name (first name and last name), email, gender, DOB, address, and joined date are the field that must be in the user entity. Survey information must be kept, that includes survey date, description, deadline, and status (open or closed). In addition, survey must have restrictions which specify if this is targeted to a specific group (age, area, or gender). The survey can have one or more of these restrictions. Each survey composed of several questions. Questions can be one of many types. Multiple choice, essay type, or true or false. This information is stored in the field type in the question entity. In addition, question entity must have target gender, target age group, or target area (city or zip code). The question can have one or more of these restrictions. Age group entity must include a unique id and the range of ages. Ex: For the id 1, the rage can be 12-20 Target gender can be Male, Female, or both When a survey is created, questions are selected based on above mentioned (age, area, and gender) restrictions to better match the target audience. If the question type is multiple choice, there must be a separate entity to keep the options of the question. Options mut be variable which means a particular question can have 4 options, 5 options, or any number of options. User responses must be stored as survey response. That must have survey ID, user ID and the date submitted along with the response for the question.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started