Simple answer plz. you (a user) would get asked if you want to login to vote in

Question

Simple answer plz.

you (a user) would get asked if you want to login to vote in the election for the presidency of the DB class. If you already an existing member, then the shell prompt would ask you to enter your username and password. If you are not a member, then you need to register. You get asked to pick a username, password, name, and email (all fields are required). If username has been used before, you will be notified to reenter a new one. After registration, you can login, and then you get to vote and pick a candidate, a member/candidate can vote and self-vote, can't vote to the same candidate twice, and no limitation on the number of votes casted. A special user named "admin", with a space (" ") as the password, that can't vote, who can display all registered members' info, add/delete members, assign/un-assign a member to become a candidate and vice versa, and then can display simple count stats on the race status at any moment. Question: Create and use stored procedures that validates the user existence to login, add/delete members, assign/un-assign members, and vote.

Explanation / Answer

Stored Procedure to validate the user existence to login:

Stored Procedure to add/delete menbers:

Stored Procedure to VOTE:

Stored Procedure to Assign/Un-Assign Member: Use the below update query syntax to assign or unassign the menber

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.