Ed Parrish
CIS 165PH
Assignment 3

Project Proposal

1. Statement of the Problem

My project is providing an online store for art supplies. The application must track products and users along with their various attributes. It will provide a product catalog for visitors to browse and a method to add products to a shopping cart. Billing and shipping information for every order must be kept, along with a list of items purchased. Storing, organizing and querying this data seems like a good use for a database.

2. Expected Database Output

Users will be able to view lists of products organized by category. The name, description and price of each product will be shown to the user, along with a picture. The user can add the product a shopping cart for later purchase.

The shopping cart maintains a list of the products purchased. A user can view their cart at any time. The shopping cart will show information like the following:

Item Description Each Qty Extended  
Canvas $22.50
$22.50
Pre-Tax Total $22.50  

If a user decides to buy a product, they must supply information for billing and shipping. Users will be able to register and become customers, allowing them to keep billing information and shipping information. Some type of user name and password will be required for authentication.

3. Data:

Some of the data I anticipate storing in the database includes: