Design a mysql database to store the registration data


Problem

A. Design a MySQL database to store the registration data about your customers as well as a login, password, and two security questions for each customer.

B. Implement your design in MySQL, using any combination of phpMyAdmin and the command-line interface, but try to use both enough to enhance your familiarity with each. Provide screenshots to demonstrate that you used both the command-line interface and phpMyAdmin.

C. Add enough data to test your database until you are satisfied it is going to help you perform the necessary tasks required. Add one login of "customer" with a password of "customer" for testing.

D. Add the functionality to your website to save the customer registration data to MySQL. Be sure to validate the data.

E. Add the functionality to your website for a customer to login and logout of your website from the home page.

F. If a customer forgets their password, add the functionality for the customer to reset their password. Your reset should include both security questions and email reset options.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Design a mysql database to store the registration data
Reference No:- TGS03242690

Expected delivery within 24 Hours