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.