05-07-2012, 03:02 PM
Requirements on online bookstore project
Requirements on online bookstore.doc (Size: 31.5 KB / Downloads: 284)
New customers need to register first to get one account ID. The provided information include : customer name, phone #, email address, home address info (street, city, state and zipcode), and password. After registration, the customer will be assigned one account ID and he/she can login using account ID and password. One customer can only register one account and each account must belong to exact one customer.
The bookstore keeps a large amount of books. Each book is identified by ISBN. For each book, the bookstore also needs to record its authors’ names, title, edition, year, category, publisher, quantity-in-stock, and price.
One customer can place any number of orders. For each order, the bookstore needs to record who places this order, when, the order status, total price, shipping address, payment method, bill address, and ordered books. Note there is only one shipping address and one billing address for each order though the shipping address may not be the same as the billing address. Currently for payment method, it only accepts credit card, hence the bookstore needs to record credit card information.
Functions for customers:
• New user account registration
• User login
• User can update his address, password etc.
• Book search (by author name, title, category, year or combinations)
• Create one empty order or shopping cart
• Add/delete books from shopping cart
• Merge shopping carts
• Change shopping carts as orders (please note that once a shopping cart is changed to order, all of this shopping cart’s info should be removed from database).
• Place the order
• Order trace
Functions for employees:
• List book information (e.g., title, author, price) and quantity-in-stock of some chosen books
• List information about those orders assigned to him/her
• Update order status
• Insert new books
Functions for analysts
• What types of books are better sold in the second quarter than the first quarter?
• What kind of books/customers are most profitable?
• What is the average time between the order placed and shipped?
• Is there any significant difference between books published by different publishers in terms of profitability?
Requirements on online bookstore.doc (Size: 31.5 KB / Downloads: 284)
New customers need to register first to get one account ID. The provided information include : customer name, phone #, email address, home address info (street, city, state and zipcode), and password. After registration, the customer will be assigned one account ID and he/she can login using account ID and password. One customer can only register one account and each account must belong to exact one customer.
The bookstore keeps a large amount of books. Each book is identified by ISBN. For each book, the bookstore also needs to record its authors’ names, title, edition, year, category, publisher, quantity-in-stock, and price.
One customer can place any number of orders. For each order, the bookstore needs to record who places this order, when, the order status, total price, shipping address, payment method, bill address, and ordered books. Note there is only one shipping address and one billing address for each order though the shipping address may not be the same as the billing address. Currently for payment method, it only accepts credit card, hence the bookstore needs to record credit card information.
Functions for customers:
• New user account registration
• User login
• User can update his address, password etc.
• Book search (by author name, title, category, year or combinations)
• Create one empty order or shopping cart
• Add/delete books from shopping cart
• Merge shopping carts
• Change shopping carts as orders (please note that once a shopping cart is changed to order, all of this shopping cart’s info should be removed from database).
• Place the order
• Order trace
Functions for employees:
• List book information (e.g., title, author, price) and quantity-in-stock of some chosen books
• List information about those orders assigned to him/her
• Update order status
• Insert new books
Functions for analysts
• What types of books are better sold in the second quarter than the first quarter?
• What kind of books/customers are most profitable?
• What is the average time between the order placed and shipped?
• Is there any significant difference between books published by different publishers in terms of profitability?