Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Conceptual Database Design An Entity Relationship Approach

Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe

1st Edition

0805302441, 978-0805302448

More Books

Students also viewed these Databases questions

Question

describe the main employment rights as stated in the law

Answered: 1 week ago