The term project is to add enhancements to your on-line music store. This is your opportunity to be creative!  

1. Enhancement ideas

2. Instructions for turning in project

3. Project grading

1. Enhancement Ideas

Make sure that you have the basic music store working properly before you start on enhancements. Enhancements are of little value if they are added to non-functional sites. 

Tip: Before starting to work on enhancements that could cause existing code to malfunction, I suggest that you make a backup copy of your project in a separate folder. 

Some ideas for enhancements are listed below. You are also encouraged to be creative and come up with other ideas.

• Upgrade the graphical appearance of your music store.

• Add a shopping cart status box (see XML Music).
  

• Add a listing of "visited pages" so the user can easily get back to previously viewed items (see XML Music).

• Validate city-state-zip code combinations by looking them up in a zip code database. A zipcode database containing over 42,000 city, state, zip codes is available for your use on Yorktown at:
  Table: tblZipCodes
  Data Source=reliant.cbe.wwu.edu,2767
  Initial Catalog=SandvigMusicStore
  User ID=WebGuest
  Password=guest  
  NOTE: This database is behind WWU's firewall and cannot be accessed from off campus. It can be accessed by code that is running on Yorktown as well from Visual Studio via the campus network.

• Add CD track listings from Amazon.com. (see XML Music)

• Add Lightbox, Highslide JS or other JavaScript tool for displaying images.

• If you are not artistic and would like a professional design use a WordPress Theme on your site.

• Add AJAX functionality to your site.

• Add customer reviews from Amazon.com. (see XML Music)

• A CAPTCHA verification image on customer reviews helps prevent automated form submission from spam robots. See XML Music and CAPTCHA Sample

• Create a customer wish list. Ideally the wish list will persist between sessions and be available from any computer, requiring that the wish list items would need to be written to a database (similar to the shopping cart). See Amazon.com as an example of a wish list. 

• Validate that customer email addresses are unique before writing them to the database. The sample site uses a custom validator. The validator's handler calls a method of the checkout class named "EmailIsUnique." This method executes a sql query that counts the number of instances for the email address, excluding the current CustID. If the count is > zero the validator reject the email address.

• List best sellers based upon data in tblOrderItems (see XML Music)

• Recommend music to customers based upon their interests. (see XML Music)
   
• Create administrative pages for managing customer and order information. This could include the ability to edit customer information, an interface for managing order status (shipped, partially shipped, returned, etc.) and adding new products to the database. (Note: In MIS 424 this is done using the SQLDataSource controls, which are very convenient for this task).
  

• For other ideas look at Amazon, Barnes and Noble and other sophisticated shopping sites.

Include a list of your enhancements in your "About this store" section so that I don't miss any when grading your assignment.

2. Instructions for turning in Project

The project is due at the date and time shown on the course schedule.  Late projects will be subject to a penalty of one letter grade per 24 hours (so don't be late!). 

Send your music store URL to:

1. Professor Sandvig at csandvig@wwu.edu
2. cc a copy to yourself

3. Project Grading

The project will be graded based on the basic store created in assignments 7, 8 and 9, plus any enhancements that you have added. The basic store that you have completed by the end of assignment 9 will earn a grade of approximately a B-. Enhancements are a way for your to further improve your grade.

The grading of the final project is very detailed and includes looking at your source code to make sure that you have coded efficiently and neatly. Specifically I will be checking to make sure that you have used user controls for all code that is reused, that your browse menu is dynamically generated and that you code is original (your own work).

Project grades will be posted on the class web site.