As a Customer, I would like to register for the online store, so that my information can be saved for future shopping, and I can track my usage history
Priority: 1
Acceptance Criteria
Customers visiting the site must register for an account or login to continue shopping
Customers are greeted with a form to input their information
After submitting valid information the customer is logged in
Upon submitting invalid information a customer is informed of their error, with an apology and asked to try again
Upon submitting a username that is already in the system, the user is informed that the username already exists, and is asked to try a different username.
An Email my password button is available to email the customer their login information
Testing plan
prove that submitted user information is sanitized
prove that new customer information is stored in the database
prove that the system is logs in users after registration
prove that visual elements respond to activation in a predictable and logical manner
Story points: 5
Tasks
Create Customers table in SQL
Name, Address, Phone number, cid (username), Password, Email
Create a Home Page form in php with 2 sections:
Login: Username and Password, both free text fields; email my password link
Register: Username, Password, Name, Address, Phone number, Email, all free text fields
Test access to the form from different browsers and locations
Create an insert procedure to the customers table
Test the insert procedure in SQL
Create a find procedure on the customers table
Test the find procedure in SQL
Connect the stored procedures in SQL to the php login form
Determine edge cases, exceptions, and expected use operations
Test the procedures from our website for all cases:
Description
As a Customer, I would like to register for the online store, so that my information can be saved for future shopping, and I can track my usage history
Priority: 1
Acceptance Criteria
Customers visiting the site must register for an account or login to continue shopping Customers are greeted with a form to input their information After submitting valid information the customer is logged in Upon submitting invalid information a customer is informed of their error, with an apology and asked to try again Upon submitting a username that is already in the system, the user is informed that the username already exists, and is asked to try a different username.
An Email my password button is available to email the customer their login information
Testing plan
prove that submitted user information is sanitized prove that new customer information is stored in the database prove that the system is logs in users after registration prove that visual elements respond to activation in a predictable and logical manner
Story points: 5
Tasks
Create Customers table in SQL