Online Book Store Website Development Project

Index

• Introduction
• Proposed System
• Objectives to be fulfilled
• System Features
• Assumptions
• Entity Relationship Diagram
• Data Flow Diagram
• Data Dictionary
• Coding System
• Screen Layouts
• Operating Environment
• Proposed Enhancement
• Conclusion
• Bibliography

Introduction

The Project “Online Book Store” is a user interactive and delivery based website where the order can be booked and payments can be done shortly along with getting all the required details regarding each and every mobile.

Business done by e-commerce is far more efficient, faster and reliable than traditional commerce.

This method of adoption of doing business via e-commerce is a user-friendly system which will help the user to access the product easily.

Proposed System

The Online Book Store method of selling products through e-commerce is far more efficient than traditional commerce.

Objectives to be fulfilled

The following are the objectives which are fulfilled by creating an online shop for Selling Books Online.

To provide a wider market to the seller.

To remove monopoly and provide better products to the customers

To make products easily available to the customers.

Assumptions

While developing the E-Commerce website for Book Selling System, following assumptions were kept in mind for the administrator.

The user logged in with ID and Password is a valid user.

The Credit Card Number taken from the user is not received to the database, and is redirected directly to the www.paypal.com via SSL.

All Products are available according to the stock.

Context Diagram

First Level Diagram

Data Dictionary

Table: Board

This Table Keeps the records of different Discussion boards

Field Name	Data Type	Size	Constraint
BoardID	Int	4	Primary Key
B_Name	Varchar	40
B_des	Varchar	100
B_Order	Int	4

Table: Manufacturer

This Table Keeps the records of different Manufacturer Information

Field Name	Data Type	Size	Constraint
Man_id	Int	4	Primary Key
Man_name	Varchar	30
Man_img	Varchar	40

Table : NewestPhone

This Table Keeps the records of Newest Phone

Field Name	Data Type	Size	Constraint
Cheker	Varchar	40	Primary Key
Phone_Id	Int	4
Man_Id	Int	4	Primary Key
Price	Float	8
Thumnail	Varchar	40

Table : Ordertable

This Table Keeps The Records Of All The Orders

Field Name	Data Type	Size	Constraint
OrderId	Varchar	10	Primary Key
UserId	Varchar	20	Primary Key
PhoneId	Varchar	10	Primary Key
Ord_Quentity	Int	4
SubTotal	Float	8

Table : Payments

This Table Keeps The Records Of All The Payments

Field Name	Data Type	Size	Constraint
Order_Id	Varchar	10	Primary Key
User_Id	Varchar	50
Amount	Float	8
Exp_Date	Date	8
Card_No	Varchar	15
IP	Varchar	25
Ord_Date	Date	8
Status	Char	1

Table : PhoneDetails

This Table Keeps The Records Of All The Phones

Field Name	Data Type	Size	Constraint
Phone_Id	Varchar	10	Primary Key
Man_id	Varchar	20
Date_pub	Date	8
Bat_type	Varchar	50
Disp_type	Varchar	50
Big_img	Varchar	50
Small_img	Varchar	50
Thumnail	Varchar	50
Price	Float	8

Table: Post

This Table Keeps The Records Of All The Posts

Field Name	Data Typ	Size	Constraint
PostId	Int	4	Primary Key
PostSubject	Varchar	50
PostedBy	Varchar	50
Posted	Date	8
IP	Varchar	25
Massage	Varchar	200
ThreadID	Int	4

Table : Ratings

This Table Keeps The Records Of All The Ratings For Phones

Field Name	Data Type	Size	Constraint
RatingId	Int	4	PrimaryKey
Rating	Int	4
IP	Varchar	25
PhoneId	Varchar	10

Table : Cart

This Table Keeps The Records Of related cart.

Field Name	Data Type	Size	Constraint
TransId	Int	4	PrimaryKey
SecCode	Int	4
UserId	Varchar	50
PhoneId	Varchar	10
Man_Id	Varchar	20
Price	Float	8
Qty	Int	4

Table : Thread

This Table Keeps The Records Of All Thread

Field Name	Data Type	Size	Constraint
ThreadId	Int	4	PrimaryKey
Tname	Varchar	50
StartedBy	Varchar	50
BoardId	Int	4

Table : User

This Table Keeps The Records Of All The Users

Field Name	Data Type	Size	Constraint
UserId	Varchar	50	PrimaryKey
Pass	Varchar	50
Name	Varchar	50
L_name	Varchar	50
B_Date	Date	8
Country	Varchar	20
Previladge	Char	1
JoinDate	Date	8
ImgUrl	Varchar	200

 

Screen Layouts

Admin Login

Add New Phone

User Home

Listing Mobiles

Mobile’s Details

Contact Us

Coding System

In the Coding System, we have provided a unique primary key to all the Books so they can be searched uniquely.

There would be no redundant data in the coding system.

Operational Environment

The Hardware and Software requirements for this particular project is specified below

Hardware Configuration (Minimum Requirement)
Processor Pentium 233 Mhz
RAM 128 MB
HDD 500 MB
Monitor Supporting resolution up to 1024 * 768

Software Requirement (Minimum Requirement)
Internet Explorer 6 or Above—

Proposed Enhancement

The current Online Book Store project can be made more secure by providing cross-checking techniques and algorithms for keeping the user data secure.

This project is expandable if we can include more modules to it, like shipping and door to door delivery.

Conclusion

This is our first live Online Book Store project to handle an e-commerce website. The firm was only using a traditional commerce method for selling machinery.

During analysis, e gathered the information about the companies by taking interviews of organization staff members and even studied the manual system.

This Website Development Project gave us sound knowledge and experience in all major areas of computer application and to get exposure to various technical and management practices of IT industry.