On-line book store presentation

On-line book store presentation

1. Presentation On:Presentation On:
Online Book StoreOnline Book Store

2. IndexIndex
DefinitionDefinition Data Flow DiagramData Flow Diagram
Project ProfileProject Profile Entity Relationship Diagram Entity Relationship Diagram
Feasibility ReportFeasibility ReportFlow Chart Flow Chart
Key FeaturesKey Features Data DictionaryData Dictionary
Risk AnalysisRisk Analysis Screen Shots Screen Shots
ModulesModules Thank You [ EXIT ]Thank You [ EXIT ]

3. DefinitionDefinition

This is online book shopping site.This is online book shopping site.

By which user can put details of books and By which user can put details of books and
user can search it, can be member of site, user can search it, can be member of site,
buy online books, and see other related buy online books, and see other related
books of same author or same category.books of same author or same category.

User can view online book detail from User can view online book detail from
anywhere through internet and purchase it anywhere through internet and purchase it
with payment from PayPal and credit card.with payment from PayPal and credit card.
HomeHome

4. Project ProfileProject Profile

Project Title :- Online Book Store SystemProject Title :- Online Book Store System

Developed At :- Orange Web TechnologyDeveloped At :- Orange Web Technology




Developed By:- Developed By:-
Smit Patel Smit Patel

HomeHome

5. Feasibility ReportFeasibility Report
HARDWAREHARDWARE

ProcessorProcessor : : Intel P4 or Above 2.5GhzIntel P4 or Above 2.5Ghz

RAM RAM :: 512 MB RAM or Above512 MB RAM or Above

HDDHDD :: 80 GB or Above80 GB or Above
SOFTWARESOFTWARE

OSOS :: Windows 2000/2003/XP or NextWindows 2000/2003/XP or Next

FrontendFrontend :: ASP. Net 2.0ASP. Net 2.0

BackendBackend :: SQL Server 2000SQL Server 2000

Web BrowserWeb Browser :: Internet Explorer/ Mozilla/ Fire foxInternet Explorer/ Mozilla/ Fire fox
HomeHome


6. Tools To Be UsedTools To Be Used

Frontend Tools:-Frontend Tools:-
ASP.Net 2.0ASP.Net 2.0

Backend Tools:-Backend Tools:-
SQL Server 2000SQL Server 2000

7. Key FeaturesKey Features

Many types of categories are available in our site.Many types of categories are available in our site.

User can search books subject wise or author wise.User can search books subject wise or author wise.

User can add books to his wish list which he want User can add books to his wish list which he want
to purchase later.to purchase later.

One can send page as email to his friend.One can send page as email to his friend.

Information is displayed on latest released books.Information is displayed on latest released books.

One can take information about future releasing One can take information about future releasing
books.books.

User can give book reviews.User can give book reviews.

8. Key FeaturesKey Features

User can give comments and ratings on User can give comments and ratings on
particular book. particular book.

User can see other user’s favorite subject in User can see other user’s favorite subject in
other user’s wish list. other user’s wish list.

We have shown the complete collection of We have shown the complete collection of
particular book. As example: - Harry Potter’s 9 particular book. As example: - Harry Potter’s 9
books collection.books collection.

In recommended item member can enter book In recommended item member can enter book
name which he/she not found in our site. name which he/she not found in our site.
HomeHome

9. Risk AnalysisRisk Analysis

If item is not in stock, then we provide information If item is not in stock, then we provide information
that “this particular book is not available for some that “this particular book is not available for some
days”, so member can add that item in days”, so member can add that item in
recommended item.recommended item.

We gradually give notification about member’s order We gradually give notification about member’s order
status by email. Still if member not get order in status by email. Still if member not get order in
delivery time due to some reason then we give delivery time due to some reason then we give
information to member by telephone about that.information to member by telephone about that.

If price, which we are provide for particular books is If price, which we are provide for particular books is
changed and yet we have not updated it then changed and yet we have not updated it then
,during that time any member buys those books, we ,during that time any member buys those books, we
willwill

charge them for displayed price only.charge them for displayed price only.
HomeHome

10. ModulesModules

HomeHome

Shopping CartShopping Cart

AdminAdmin

UserUser

HelpHelp

Contact UsContact Us

11. HomeHome

SearchSearch

Most Popular SubjectsMost Popular Subjects

Top AuthorsTop Authors

Top New ReleasesTop New Releases

Complete CollectionsComplete Collections

Customer ReviewsCustomer Reviews

12. Shopping CartShopping Cart

No. of itemsNo. of items

List of Books with priceList of Books with price

Total AmountTotal Amount

PaymentsPayments

Remove from cartRemove from cart

13. AdminAdmin

Login FormLogin Form

Category managerCategory manager

Product managerProduct manager

User ManagerUser Manager

Help managerHelp manager

Feedback managerFeedback manager

Change PasswordChange Password

Author managementAuthor management

14. UserUser

Login FormLogin Form

Books in my wish listBooks in my wish list

Items in my shopping cartItems in my shopping cart

My ordersMy orders

15. HelpHelp

Payments & ReturnsPayments & Returns

Privacy PolicyPrivacy Policy

Help / FAQHelp / FAQ

16. Contact UsContact Us

Bulk order inquiryBulk order inquiry

Undelivered ordersUndelivered orders

Company informationCompany information

Sell us new booksSell us new books
HomeHome

17. Data Flow Diagram (DFD)Data Flow Diagram (DFD)

18. Context DiagramContext Diagram

19. OO
thth
Level Diagram Level Diagram

20. 11
stst
Level Diagram (ADMIN) Level Diagram (ADMIN)

21. 11
stst
Level Diagram (USER) Level Diagram (USER)

22. 22
ndnd
Level Diagram (ADMIN) Level Diagram (ADMIN)

23. 22
ndnd
Level Diagram (USER) Level Diagram (USER)
Home

24. Entity Relationship Diagram (ERD)Entity Relationship Diagram (ERD)

25. Home

26. Flow ChartFlow Chart

29. Home

30. Data DictionaryData Dictionary

31. Table NameTable Name : : tbl_bktbl_bk
DescriptionDescription : : This table contains all information about books.This table contains all information about books.
Field name Data type Size Desc. Pk /Fk
bk_id Integer 7 This field is created to generate index for the book
table.
PK
bk_name Varchar 50 Name of the book.
cate_id Integer 5 Id of the category to which book belongs.FK
author_id Integer 5 Id of the author of the book FK
bk_price Float 8,2 Price of the book
qty Integer 5 Number of books available
comp_coll Integer 1 If book is complete collection then its value is 1 and
0 otherwise.
recent Integer 1 If book is sold recently then its value is 1 and 0
otherwise.
latest Integer 1 If book is latest then its value is 1 and 0 otherwise.
Discount Integer 2 Discount on the book.
bk_img Image 1 Image of the book.

32. Field NameDate TypeSize Description PK/FK
cate_ID integer 5 This field contain category ID.PK
cate_name varchar 50 This field contain category name.
Field NameDate TypeSize Description PK/FK
author_ID integer 5 This field contain author ID. PK
author_name varchar 50 This field contain author name.
Table Name: tbl_cate
Description: This table contains all the categories (Subjects) of the books.
Table Name:tbl_author
Description:This table contains all the authors of whom books are available.

33. Table Name: tbl_admin_login
Description: This table contains all the login details of admin.
Field NameDate TypeSize Description PK/FK
admin_id Integer 2 This field contains admin ID. PK
admin_uname varchar 50 This field contains admin username.
admin_pass varchar 50 This field contain admin password.
admin_sec_que varchar 200 This field contains admin password recovery
secret question.
admin_sec_ans varchar 50 This field contains admin password recovery
secret question’s answer.

34. Field NameDate TypeSize Description PK/FK
user_login_ID integer 8 This field contains user login ID. PK
user_ID integer 8 This field contains user ID. FK
user_uname varchar 50 This field contains username of all users.
user _pass varchar 50 This field contain user password.
user _sec_que varchar 200 This field contains user password recovery
secret question.
user _sec_ans varchar 50 This field contains user password recovery
secret question’s answer.
Table Name: tbl_user_login
Description:This table contains all the login details of users.

35. Field Name Date Type Size Description PK/FK
user_ID integer 8 This field contains user ID. PK
user_fname varchar 50 This field contains user’s first name.
user _init varchar 1 This field contains user’s middle name or
initial.
user _ lname varchar 50 This field contains user’s last name.
user_gen varchar 6 This field contains user’s gender.
user _add varchar 200 This field contains user’s permanent
address.
user_city varchar 50 This field contains user’s city.
user_pin integer 6 This field contains city pincode.
user_state varchar 50 This field contains user’s state.
user_country varchar 50 This field contains user’s country.
user_emailID varchar 200 This field contains user’s email Address.
user_phone number 20 This field contains user’s phone no.
Table Name:tbl_user_reg
Description:This table contains all the information about user.

36. Field NameDate
Type
Size Description PK/FK
user_ID integer 8 This field contains user ID.FK
book_ID integer 7 This field contains the ID of the
book in the wish list.
FK
Field NameDate
Type
Size Description PK/FK
help_ID Integer 5 This field contains ID of help
content.
PK
help_contentvarchar 50 This field contain s help content
Table Name:tbl_wish_list
Description:This table contains wish list.
Table Name:tbl_help
Description:This table contains help content

37. Table Name:tbl_query
Description:This table contains queries sent by users.
Field NameDate
Type
Size Description PK/FK
query_ID integer 4 This field contains ID of the query.PK
Query_que varchar 200 This field contains the question of
query sent by user.
Query_ans varchar 200 This field contains the Answers of
query sent by user.
Table Name:tbl_order
Description:This table contains order detail.
Field NameDate TypeSize Description PK/FK
order_ID integer 8 This field contains the order number.
user_ID integer 8 This field contains ID of the user who is
purchasing books.
FK
book_ID integer 7 This field contains the ID of the book that
you want to purchase.
FK
qty Integer 5 This field contains the quantity of book
that you want to purchase.
FK
Home

38. Bibliography Bibliography
Website ReferredWebsite Referred

www.amazon.comwww.amazon.com

www.flipcart.comwww.flipcart.com

www.GPOUSGovernment Bookstore.comwww.GPOUSGovernment Bookstore.com

www.nbcindia.comwww.nbcindia.com

www.infibeam.comwww.infibeam.com

www.openbooksystem.comwww.openbooksystem.com
Name of BookName of Book AuthorAuthor

System Analysis and Design System Analysis and Design Shelly Cashman SeriesShelly Cashman Series

ASP.Net 2.0ASP.Net 2.0 Black BookBlack Book

Database System ConceptsDatabase System Concepts Peter Rob & Carlos CoronelPeter Rob & Carlos Coronel

39. Screen ShotsScreen Shots

40. Home Page part - 1Home Page part - 1

41. Home Page part - 2Home Page part - 2

42. Home Page part - 3Home Page part - 3

43. Book DetailBook Detail

44. All Authors and CategoriesAll Authors and Categories

45. All Authors and CategoriesAll Authors and Categories

46. Admin LoginAdmin Login

47. Admin forgot passwordAdmin forgot password

48. Admin forgot passwordAdmin forgot password

49. Admin WorkAdmin Work

50. Author ManagerAuthor Manager

51. Category ManagerCategory Manager

52. User LoginUser Login

53. User forgot passwordUser forgot password

54. User forgot passwordUser forgot password

55. New UserNew User

56. New UserNew User

57. Help & FAQHelp & FAQ

58. Contact UsContact Us

59. Contact UsContact Us

60. Contact UsContact Us
Home

61. From:-
Smit Patel
Thank You…Thank You…