The company has a large database of customers who signed up for the newsletter subscription when they purchased items or made an enquiry. Some customers may wish to unsubscribe from the newsletter. We want to automate this process on our corporate web site which was built using Wordpress and mySQL.
The functional specification looks like this:
store the email addresses in a database table
for each email address set a flag indicating that the email address is subscribed to the newsletter
set up a web page for the unsubscribe feature
the newsletter email will have an "unsubscribe" link to this page
the email unsubscribe link will forward the customer's email address to the unsubscribe page
the user will click on the "confirm unsubscribe" link on the unsubscribe page
the page will respond with a confirmation message and send a confirmation email to the customer
the transaction will set the flag to null for that email address indicating that the email address is not longer subscribed to the newsletter.