Slide 8.13: WriteFile.h
Slide 10.2: How to construct the Programming Exercise II
Home

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

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: The store owner (superuser) has the following requirements: Other than the above requirements, the instructor has the following requirements:

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.