Requirement doc

                                                 SHOPIEE------The online store
Requirement
Version:0.1
Date:-15/09/2012
Author:- Rashmi(ROLL NO:-12BM60069)

Shoppie is an online store which deals in FMCG products.This application has user and Admin roles.

Roles:

1)customer

2)Admin

customer:-

Steps of action:-

1)Login in the store website with his login id and password.Authenticate the login password and id.

2)If not authorised user display “Sorry not an authorised user”.

3)Correct login ,direct to  inventory page .

4)Go and select  from the available choice of merchandice, shipping address etc.

5) Name ,mail address,phone number,merchandise choice ,quantity  are mandatory fields.

6) Have datatype validations on the above mentioned attributes.

7) Satisfy all the validation ,submit the form .

8) Make neccessay updation in inventory table.

9)Onsubmit directed to payment page  ,make payment ,apply necessary validations   and submit.

10)On submittion the user gets a mail,regarding confirmation of his order.

Admin:-

1)Should have a authenticated user id and password.

2)Should have add or remove previlage.

3)Put the product name ,product id and quantity and add it to existing inventory.

4) Submit it ,on submit the details are added in the inventory table.

Tables:-

Inventory

Attributes:-

Product name(string 25)

Product id (string 10)(Primary key)

Quantity(Numeric 5)

User

Attributes:-

Customer id (string 15)(Primary key)

First Name(string 20)

Last name(string 20)

Address (string 50)

Mail_id (string 30)

Password (alphanumeric  20)

Phone number(numeric 10)

Product id(string 5)(Foreign key)

Fig :-1

Fig:-2

Fig:-3

Appendix 1:-

Hi,

First name:- xxxxxx

Second Name :-xxxxxxx

Phone number -667788xxx

Mail id:-xxxxxxxxx@xxxxxx

Merchandise choice:-xxxxxx

Quantity:xxxxx

Thanks for the purchase.

You will get your product within 4 buisness days.

Regards,

Shopify

=====================================================================

                                                 SHOPIEE------The online store

Requirement

Version:0.2

Date:-15/09/2012

Author:- Rashmi

Accepted  following changes suggested from client side through mail channel:-

Note of acceptance:-

I hereby accept changes suggested by the Programmer.

Signature:-Rashmi

Place:-Kharagpur

Date:-19/09/2012