A prototype of an online music CD shop
Category : Web Design and Development > Web Sites
|
 |
| Buyer | :: |
|
| Posted on | :: | 10/08/2004 |
| Expires on | :: | 17/08/2004 |
| Job Type | :: | ASP, HTML/DHTML, Flash |
| Database system | :: | No Database |
| Operating System | :: | I do not know |
| Budget | :: |
|
| Total Bid | :: | 9 |
| Project Description | :: |
Scenario:
A music CD retail supplier wishes to provide public webpage access to a remote database containing information about the CDs that they sell.
Specific user requirements:
All webpage visitors should be able to obtain a list of:
a) all the CDs in the database listed alphabetically by artiste name;
b) CDs by a certain artiste listed by date of release;
c) CDs whose price is within a range (minimum and maximum) specified by the user;
d) the titles of the tracks on any selected CD;
e) CDs whose overall CD title or track titles contains a keyword input by the visitor.
Staff users (only) should also be able to obtain a list of all CDs sorted into descending order of customer interest as measured by the number of enquiries about each specific CD retrieved in requirement d) above.
Your specific instructions:
You are expected to:
1. Analyse the informational requirements, specifying exactly what fields are needed and how information will be represented, including data types, field sizes, etc.
2. Design and create an Access database to implement the above. It is expected that you will need two tables in the database, one for the CDs and one for the track information.
3. You could also have a table of staff user IDs and passwords but for this assignment the userID of �staff� and password �staff� may be hardwired in program code to save time.
4. You should enter information for 20+ CDs. Each CD can have any number of tracks but for some CDs there may be no track information available. The data chosen must support the testing required.
5. Write an ASP program using VBScript to:
a. produce a webpage that introduces and explains the system for users and displays an HTML form to receive user input (so that the user can indicate what type of search they want).
b. process the user input, validate it where necessary, use SQL to retrieve the specified information from the database, and output a suitable results page which is sent back to the client as a webpage, usually using HTML tables to lay out the results neatly.
6. The indicator of customer interest must be generated automatically by incrementing a counter for the CD each time a user asks for track information on that CD.
7. Produce concise and accessible documentation for the assessor which contains the following minimum information:
a. Clear identification of all required items, including your user number, filenames, page titles, etc.
b. The specification of the database tables, fields, field lengths, data types, etc, with justification for decisions that you took.
c. Evidence that you have tested systematically (including the items covered on the Coversheet).
d. A screen shot of the user-input screen.
e. Annotated screen shots showing the results of searches specified above.
f. List of any enhancements that you have implemented.
g. Suggestions for potential future enhancement
|
|
|
