Please upload your files to CSNS. The files should include all the source code, documentation (optional), and an HTML file lab2.html, which contains a link to your JSP page on the CS3 server. Note that file uploading will be disabled automatically after 10:00PM, so please turn in your work on time.

Company X is conducting a promotion, which works as follows:

• When a customer buys a product from Company X, they will receive a code. For simplicity, we will assume that a code is simply a 4-digit number.
  
• The customer may go to Company X's website, enter the code and their name and email address, and see if they have won any reward.
  
• If there is a reward associated with the code, the website will record the customer's information, and the customer will be contacted later with the information on how they can claim their reward.

In this exercise, you are going to help Company X to implement the promotion website.

[SQL] (5pt) Create the following two tables, Rewards and Customers, in your database, using proper attribute type for each attribute:

Note that the Rewards table contains a list of codes and the rewards associated with them. The Reward field could be null, which means there is no reward. The Customers table contains a list of customers and their email addresses. Note that an email address uniquely identifies a customer, or in other words, you should not have two rows in the Customers table that have the same email address.

For this problem, turn in a file lab2.sql which includes the SQL statements to create and populate the tables.

[JSTL SQL] (5pt) Create a JSP page GetReward.jsp. When GetReward.jsp is requested without any parameter, it displays the the following form:

Once a customer fills out the form and clicks the Get Reward! button, the application checks the user input and the content of the database, updates the database if necessary, and displays one of the following messages:

• Sorry, your code is invalid.
• Sorry, the reward has already been claimed.
• Sorry, you did not win any reward.
• Congratulations! You have won <reward>! A representative will contact you shortly. (<reward> is the actual reward information retrieved from the Rewards table).

For this problem, you must use the JSTL SQL tags to access the database.

[JDBC] (+5pt) For extra credit, create another JSP page GetReward2.jsp, which provides the same functionality as GetReward.jsp, except that GetReward2.jsp uses Java beans and JDBC instead of the JSTL SQL tags to access the database.