Java Web Project Documentation

Todd Westerman
toddandlaura99@yahoo.com

Advanced Java Programming, Fall 2002
Professor: ChanJin Chung

Project Description

This project is an E-Commerce website for Randolph Miller Associates (RMA), a company that specializes in marketing for real estate agents. The site will provide customers of RMA the ability to order products and request services online, as well as manage their account online and see the progress of their orders. The site is going to have two main parts, one for customers of RMA to order products, and the other part is for RMA employees to download and manage information for the site.

Project History & Background

RMA has been in business since 1998, and since then, they have gained a good reputation as a reliable company in southeastern lower Michigan. The majority of their client-base comes from Oakland, Washtenaw, and Wayne counties. Now, however, they are looking into the possibility of offering their services country-wide, and starting an E-Commerce site is their first step in doing so. This project is going to be the first phase of their implementation of expanding their business.

Database

Click here to see the Entity Relational Diagram

Requirement Specification

Click here for the Sytem Context Diagram

System Major Functions

Functions available for Customers:

Done: Order_Zap( )
- Calculate the price based on product and pricing tables
- Add a row in the Order table
- Add a row in the account table
- Send alert email to company
- Send confirmation to customer
Done: Order_Budget_Mail( )
- Add a row in the BudgetMailInterest table
- Send alert email to company
Done: Order_Pesonal_Postcards( )
- Add a row in the PersonalPostcardInterest table
- Send alert email to company
Done: Enroll_As_Client( )
- Adds a row to customer table
- Send alert email to company
- Send confirmation to customer
Done: View_Transactions( )
- View all customer transactions based on: Date of order, Product, Order Number
Done: Update_Info( )
- Update any information on Customer table
- Update any information on Accoutn table/lI>
Done: UnEnroll_Email_Subscription( )
- Sets flag on customer table that customer doesn't want email subscription anymore
Done: Login to system

Functions available for business access only

Done: Add_Update_Products( )
- If product is not existing in table, adds a row to product table
- Updates product info if product already exists
- Instead of deleting a product, use this function to see status to invalid because of the fact that orders might exist for a product, and if it were deleted, there would be no referential integrity for the foregin keys anymore.
Done: Adjust_Pricing( )
- Allows company to adjust the pricing on any of their products
Done: View_PersonalPostcard_Interest( )
- Allows company to view any clients who have submitted interest on the Personal Postcard program
Done: Update_PersonalPostcard( )
- Allows company to update the status of a personal postcard request
Done: View_BudgetMail_Interest( )
- Allows company to view any clients who have submitted interest on the Budget Mail program
Done: Update_BudgetMail( )
- Allows company to update the status of a Budget Mail program request
Done: View_Orders( )
- Allows company to view orders based on: Customer, Date, Status, Order Number
Done: Update_Order( )
- Allows company to update the status of an order
Done: Send_Broadcast_Email( )
- Send broadcast email to customers who want to receive product updates and special promotions