Programming Exercise II: An On-Line Music Store Using a Database

---

Absolutely no copying others' work
Exercise Demonstration-Presentation and Due Date
Wednesday, April 30, 2008 in class. Each team

• gives a 10-minute demonstration and presentation of the two exercises and
• turns in
  • all hard-copy source code of C/C++, CSS, (X)HTML, Java, JavaScript, JDBC, OraPerl, Perl, PHP, PL/SQL, Pro*C/C++, Unix shell, SQL (especially create table commands), SQLJ, and whatever languages,
  • the userid whose account hosts this exercise, and
  • a report (single spacing and no less than five pages) with the following subjects:

    Title Introduction Literature review

    System structure The methods applied Experimental results

    Conclusion References Appendix: User manual

---

The Objectives
Design and implement an on-line music store using a database. This exercise is for students to learn how to build a database-driven web site.

---

Requirements
MicroSongs is an on-line, B2C (business-to-customer), digital music store, which includes the following features:

• It has many songs for sale.
• Customers can search songs for multiple title keywords or display all songs.
• Customers can buy songs.
• Customers can check their shopping carts.
• Each customer can check his/her account information including an ID, purchased song titles, and total amount spent.

The store owner (superuser) has the following requirements:

• Can enter songs.
• Can delete songs of specific ASINs.
• Can updated titles or prices of songs of specific ASINs.
• Can display all song information, each song of which includes title, 10-character ASIN, and price.
• Can display all customer information, each customer of which includes a name, an ID, purchased song titles, and total amount spent.

Other than the above requirements, the instructor has the following requirements:

• User-friendliness will be heavily considered when grading. In the past, some exercises were awkward, which made the grading difficult. For example, it is considered not user-friendly if the system repeatedly asks users to enter their names/IDs/passwords.
• The system can be reset, which is to clear all databases and files. So the instructor can test the system by using only his own test data.
• Each interface includes a button Display the source, which is to list ALL the source code for implementing the functions of this interface.

---

An Example
Note that this example is not related to this exercise. It is only to show how to display web interfaces.

Start Using the Music Store.
Name:       Password:
Password:

---

Evaluation
The following features will be considered when grading:

1. This exercise will not be graded if the system entry interface can not be found at http://people.cs.und.edu/~userid/351/2/, and redirection (http-equiv="refresh") to the pages not hosted by http://people.cs.und.edu/~userid/ is prohibited.
2. Before submitting the exercise, test it comprehensively. Absolutely no extra points will be granted after grading.
3. The exercise must meet the requirements. However, exercises with functions exceeding the requirements will not receive extra credits.
4. Databases have to be used.
5. Each exercise may have a different weight, which is based on its difficulty level.
6. The SQL create table commands of database implementation have to be submitted.
7. From the source code submitted, the database design and programs will be examined.
8. Try to perform the tasks by using SQL as much as possible because SQL, a non-procedural language, can save your programming efforts.
9. User-friendliness will be heavily considered.
10. If not specified, no error checking is required; i.e., you may assume the input is always correct for that case. For example, the ASIN entered will always be a 10-character string.
11. Each function will be tested extensively.
12. Firefox 2.0 browser will be used to grade exercises. Note that Internet Explorer and Firefox are not compatible. That is your exercises may work on the IE but not Firefox.
13. The hard-copy exercises will be kept until the end of this semester. They will be used to check against others' exercises. The instructor will inform you the exercise evaluations by emails after grading.