Online Book Store - (Customer Side Perspective)

#Disclaimer: This post is created as a requirement for ZOHO app, MIS Course , VGSoM IIT Kharagpur, class of 2014.

Customer:   Happy Garg (12BM60103) (ME)
Vendor:  Sandeep Katakol(12BM60104)

Objective:  I am acting as customer and providing the requirements to the next roll number for the ZOHO app that he/she has to make for completing the course requirements.

These are the requirements/specification that I gave

Topic: ONLINE BOOKSTORE

Requirements

·        The website should have book entry page to enter the Books related data in to database.

     This page should be visible only to the admin user who can insert book entries.

·        There should be a book search page where a normal user can search the booklist by the book name.

·        The details of the searched book should pop up in the right frame of page. And Purchase of the book can be made if the book is available, and in stock.

·        Purchase should reduce the inventory of the book by one and navigation to user entry page to enter user details and address for shipping.(If the stock of book A is 4 then on purchase of book A it should be reduced to 3).

·        Confirmation email should be sent to the purchaser and initiation of shipping should be done. (It is Cash on delivery model hence no invoice needs to be generated in email).

·        The book which has its zero inventory must not shown in the search list.

·        A thank you page should be displayed after a successful purchase, and a “buy another book” button should be provided in the page for user to again go to book search page and buy another book.

·        It should have good look and feel to it.

The Database structure

Table Name	Column name	Column name	Column name	Column name	Column name	Column name
Book Table	Book Number(Primary Key)	Book Name	Description	Publisher Name	Price	Quantity Available
Order Table	Order Number(Primary key)	User Name	Email Id	Mobile number	Delivery Address	Book Number(foreign key)

The Application can be accessed here: 

URL : GRANTH: ONLINE BOOK STORE

This link to the application created was put after editing this post later. This was done as per requirements of ZOHO APP assignment as specified in  http://goo.gl/dynXM