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.