Create and use stored procedures

Assignment Help Computer Engineering

Reference no: EM132163011

Discussion Question

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.

Reference no: EM132163011

Questions Cloud

Output and consumption of the good : Explain why a competitive market would generally lead to too much output and consumption of the good if production of the good generates a negative externality.

Life of how a change in the market : Think of a relevant example in your own life of how a change in the market

How do the norms and values around investing : How do the norms and values around investing (esp. Impact investing (differ in japan?

Write a static method that takes multiple formal parameters : Write a static method that takes multiple formal parameters. Write and test several overloaded methods called textBoxString. This method returns a String value.

Create and use stored procedures : Create and use stored procedures that validates the user existence to login, add/delete members, assign/un-assign members, and vote.

Determine the throughput using frame relay transmission : Assume that all physical circuits operate at the same transmission speed and have the same bit error rate p.

Compute the average salary of the employees : Compute the average salary of the employees in the company and display the average on the screen.

What is the maximum file size : What is the maximum file size if 32 bytes are used for metadata, and 8 bytes are used for one single indirect and one double indirect pointer?

Demonstrate the use of file io : Display the seats on the screen in some manner and indicate which are available and which are taken, it is up to you to decide how to do this.

User Account

All Pages