Spring 13 – 4713 – Group 1

bookDB
bookID
name
description
category
price
author
publisher
count
verified
verifiedComment
distID

custDB
custID
password
uID

userDB
>uID
password
usertype
firstname
mi
lastname
birthday
sex
eMail
street
city
state
zip
telephone
verified
verifiedComment

distDB
distID
password
uID

adminDB
aID
password
uID

invoiceDB
iID
uID
orderDate
shipDate
shipTo
status
total
verified
verifiedComment

orderDB
bID
iID
qty
price
status

Our group is going to create a book (and other product) ordering site in a similar vein to Amazon, Barnes and Noble, et al.

We foresee the creation of three entry points or user types:

The Customers should be able to browse anonymously or while logged in. There will be a database full of products that are available for purchase, and to facilitate the shopping there should be a cart function that carries between sessions. They will also be able to register for an account, which will be required to place orders.

The Distributors will be able to view the orders placed by customers, and the stock/availability of each item to facilitate the shipping. They will also be able to edit orders currently in the database to mark them as waiting/ready/shipped/delivered/cancelled.

The Administrators will be able to view and browse the site in the same way as an anonymous user. However, they will also have access to administrator functions including the ability to add and remove products, categories, and users, as well as the order history.

Our current plans are to implement this all using JSF, likely with MYSQL as the database system.

While all members of the group will contribute to all sections of the project, the following is the tentative breakdown of priority duties:

Database Design and Connectivity
Raymond To (Hong)

GUI Design and Implementation
Alvin Gonzalez

Business Logic
Brian Febo