Jersey athletics has decided to put a periodic survey on their website to engage more users in brand and the opportunities the business has to offer. The marketing team of DBD Sports will provide the survey topics, questions, and multiple choices fi each question. As the web developer, you are tasked with loading the survey during a specified time period on the site. no need to track WHO answers the survey, but jersey athletics Marketing would like to track the responses to each question.
Create an ERD: entity relationship diagram for the situation below using the CROWS feet method
Jersey athletics has decided to put a periodic survey on their website to engage more users in brand and the opportunities the business has to offer. The marketing team of DBD Sports will provide the survey topics, questions, and multiple choices fi each question. As the web developer, you are tasked with loading the survey during a specified time period on the site. no need to track WHO answers the survey, but jersey athletics Marketing would like to track the responses to each question.
- A total of 6 surveys will initially loaded into the
database ranging from topics on personal health to team sports to nutrition. - Each survey will be related to a particular topic.
- Marketing will specify the start and end date for each survey. Only one will be displayed on the site at a time.
- Each survey will have at least 10 questions.
- Each question will have at least 3 choices.
- Each visitor will be required to respond to each question by choosing 1 response from the possible choices.
The question asks for a summary of the Entity-Relationship Diagram (ERD) using the Crow's Foot Notation for a database system designed to manage surveys for Jersey Athletics. This ERD should include entities like surveys, survey topics, questions, choices, and responses, along with their relationships and attributes. The goal is to create a system that can handle multiple surveys on different topics, track questions and choices within those surveys, and record visitor responses.
Step by step
Solved in 3 steps with 1 images
