Result Desired:<br /><br />To get a general summary and list of common answers/replies to a standard email which will be used as a basis to write an improved guide.<br /><br />Background:<br /><br />Website visitors sign up to receive a free guide with helpful information, they also sign up to get free access to use a database. After the users double opt in to receive information, we send them a free guide and details to access the database.<br /><br />After about a week, we send a standard follow up email asking about the their experience using the guide and if it helped them.<br /><br />They usually reply with a story about how they decided and used the site.<br /><br />Some of the responses will not be a reply to the standard email about, (for instance trouble logging into the database, a response to another email, unsubscribe request, etc.) these will need to categorized as separate from the responses to the standard email. <br /><br />Work:<br /><br />Part 1<br />Make a simple mySQL database with a web page interface (server will be provided). The database will need to have a way to copy the text from the reply emails and allow for the categorization of common attributes among the responses to the standard questions asked (each reply may contain multiple responses/commonalities). In addition the database will also need a way to separate out and categorize the emails that are not responses to the standard email. The database should also be able to produce a summary report with counts for each type of common responses. <br /><br />Input and categorize the first 100 emails (emails are stored in a gmail account) and produce a summary a report, then send the report and database interface/access instructions to me<br /><br />Wait for my reply beforecontinuing. <br /><br />Milestone 1 reached, 1/2 of payment will be issued.<br /><br />Part 2<br />After receiving the okay to proceed, input/process the remaining emails (approximately 1500) and send a final summary report.<br /><br />After reviewing the report, the final 1/2 payment will be issued.<br />