Ed Parrish
CIS 165PH
Assignment 3

Project Proposal

1. Statement of the Problem

My project will provide 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 so that correct funds can be collected. In addition, the application must track all the items purchased and provide shipping information to the customer.

2. Web Views of Data

Product Catalog

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. You can see this organization below.

Image	Product	Price	Description	Buy
	Canvas	$22.50	Good canvas for quality paint	Add Item
	Brush,Big	$4.75	Big brush for large areas	Add Item

Shopping Cart

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 using a form like you see at Amazon.com and other online retailers. 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 to Store in the Database

Some of the data I anticipate storing in the database includes the items in the following categories:

Persons

• First name
• Last name
• Username
• Password
• Email address

Products

• Product name
• Product description
• Product image location

Orders

• Order number
• Customer billing address
• Customer shipping address
• Payment information
• Order date
• All the items ordered