CROSS WORD                

Book Order Management

Develop an online books order system where a customer can buy books on credit.The following functionality has to be implemented.

Functions of an employee of the organization

Registration: An employee has to register before performing any actions. The following details of an employee are captured.

a. Name

b. Sex

c. DOB

d. Phone No

e. Email

f. Login Id

g. Password

An authorized employee can perform the following tasks.

1. Add Book(s) : 4 categories of books can be added (Fiction, Romantic, Self Help, Academic). The following details are captured

a. Book Name(Mandatory)

b. Author(Mandatory)

c. Category

d. Publisher(Only for Academic books)

e. Edition(Only for Academic books)

f. Quantity(Mandatory)

g. Price(Mandatory)

The combination of Book Name and author is unique.

2. Update Quantity & Price

For a Book Name & Category the quantity & price can be updated

3. Update the Status of a customer order

When a customer places an order, a unique order ID is generated. The delivery of that book may take a few days before which the customer might want to track his order. So depending on the status of the delivery the employee updates the status of that order.

Functionality for Customer

A customer need not be registered in our website to avail the services. The following actions can be performed by a customer

1. Search

A customer can search the wide range of books available. A customer might not always know the actual book name, so he can search based on the following combinations as well

       a. Book Name: If the book name is known then the search is simple and straight forward.

       b. Author: He can search based on author name, all the books corresponding to that author are displayed out of which he can select the book he wants.

       c. Category: He can search based on category, all the books in that category written by different authors are displayed. He can refine the search by limiting the author after                  selecting the category as well.

The search criteria can be a combination of the above options as well.

2. Order: Once a customer chooses a book, he can specify the quantity he want to purchase. If the quantity required is <= quantity available then the total price is calculated and an invoice is generated. The invoice contains all the details of the customer like address, contact, mail. 

After an invoice is generated a unique order ID is generated which can be used by him to track the order. A confirmation mail is sent to the customer with the order details.

3. Order Status: The customer can track the status of an order by specifying the Order Id.

The cash has to be paid at the time of delivery.