Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MySQL statements only. Table user *user_Id Email user_Name pwd dob img Table poll *poll_Id +user_Id S_date e_Date ques Ans_1 Res_1 Ans_2 Res_2 Ans_3 Res_3 Ans_4

MySQL statements only.
Table user
*user_Id
Email
user_Name
pwd
dob
img
Table poll
*poll_Id
+user_Id
S_date
e_Date
ques
Ans_1
Res_1
Ans_2
Res_2
Ans_3
Res_3
Ans_4
Res_4
Ans_5
Res_5
image text in transcribed
b. Login Form given the username and password, retrieve the user ID, matching screen name, and avatar graphic if the username and password pair do not match, return an empty result set . C. Poll Management Page given a specific user ID, retrieve all of the user's polls (question, answer alternatives, number of votes for each alternative, and the date/time of the most recent vote) d. Poll Vote Page given a specific poll ID, retrieve the question and answer alternatives e. Poll Results Page .given a specific poll ID, retrieve the question, answers, number of votes for each alternative, and the date/time of the most recent vote

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

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions