Near East University Near East University

(1)

Near East University Near East University

Department of Computer Engineering Department of Computer Engineering

E-COMMERCE FOR LAPTOPS SELLING COMPANY E-COMMERCE FOR LAPTOPS SELLING COMPANY

Abdul Halim Abu Kuwaik Abdul Halim Abu Kuwaik

(2)

Introduction Introduction

I was approached by a computer selling I was approached by a computer selling

company to construct an e-commerce company to construct an e-commerce

system that allows customers to purchase system that allows customers to purchase products, mainly laptops, over the internet.

products, mainly laptops, over the internet.

The system was designed to enable The system was designed to enable

customers to browse through the customers to browse through the

interactive website, fill out an order form, interactive website, fill out an order form, and submit it to the company’s database.

and submit it to the company’s database.

(3)

Employees of the company will be able to view Employees of the company will be able to view

the orders made in the form of reports, and the orders made in the form of reports, and

deliver the products accordingly.

Payments are made in cash or check to the Payments are made in cash or check to the

delivery representative upon delivering the delivery representative upon delivering the

product to its customer. This method is called product to its customer. This method is called

payment-on-delivery.

(4)

Analysis of the system Analysis of the system

After collecting all the necessary information After collecting all the necessary information about the company, the analysis phase was about the company, the analysis phase was

started.

I determined how the system will be built, what I determined how the system will be built, what processes were involved, what information was processes were involved, what information was

needed, and so on.

(5)

Logical Data Flow Diagram Logical Data Flow Diagram

Context Diagram Context Diagram

(6)

Methodology Methodology

I chose different software to construct the e- I chose different software to construct the e-

commerce system:

MS FrontPage

MS FrontPage (for website design)(for website design)

HTML

HTML (for website design)(for website design)

Active Server Pages

Active Server Pages (for linking website to database)(for linking website to database)

Ms Access

Ms Access (to store orders made and for the user interface)(to store orders made and for the user interface)

(7)

Website Design Website Design

After collecting pictures and information from the After collecting pictures and information from the

company, I started designing the website using company, I started designing the website using

Ms FrontPage and HTML for the static web Ms FrontPage and HTML for the static web

pages.

I used frames, hyperlinks, tables, and text I used frames, hyperlinks, tables, and text

formatting.

(8)

Database Design Database Design

Using the MS Access software, I constructed a Using the MS Access software, I constructed a

database consisting of 4 tables.

The first table was the ‘

The first table was the ‘customer information’customer information’

table and included all the customers’ names, table and included all the customers’ names,

addresses, telephones, emails etc.

(every customer was given a unique ID auto number to (every customer was given a unique ID auto number to distinguish his/her order from other orders)

distinguish his/her order from other orders)

The second table was the ‘

The second table was the ‘brands table’brands table’ and and

included the products’ IDs and the product brand.

(9)

Database design Database design

The third table was the ‘

The third table was the ‘item information’item information’ table and table and

included all the products that were displayed for sale on included all the products that were displayed for sale on

the website.

(T(That this table was linked via ASP to the order form on hat this table was linked via ASP to the order form on the website so that the company can add any number of the website so that the company can add any number of

products to its range in the database and will products to its range in the database and will

automatically be updated in the website automatically be updated in the website))..

The fourth table was the ‘manager’ table and included The fourth table was the ‘manager’ table and included

(10)

Reports Reports

Using the Ms Access features, different Using the Ms Access features, different

reports were generated for the employees reports were generated for the employees

of the company to view orders made by of the company to view orders made by

customers.

I included a customer information report, a I included a customer information report, a

products description report, a delivery products description report, a delivery

report, and a general information report.

(11)

User Interface User Interface

The user interface was designed to allow The user interface was designed to allow

employees of the company to view and employees of the company to view and

print different reports.

I used the form option in the Ms Access I used the form option in the Ms Access

software to create the user interface.

(12)

User Interface

(13)

Summary Summary

The project was considered successful despite of some The project was considered successful despite of some minor faults such as the customer having to submit more minor faults such as the customer having to submit more than one order form if he/she wants to order more than than one order form if he/she wants to order more than one product.

one product.

Several future development plans are in progress to Several future development plans are in progress to better enhance the system. These are a few:

better enhance the system. These are a few:

-Adding a shopping cart system. -Adding a shopping cart system.

(14)

In order to make myself clear, let’s take a In order to make myself clear, let’s take a

look at the website.