01936529733

Report On
“Online shopping”

Prepared for

MD. Hsibur Rashid Chayon
Instructor
International University of Business Agriculture and Technology, Dhaka

Prepared By

Tahsin Kabir
11304038

Database Management Syestem
CSC: 433

IUBAT-International University of Business Agriculture and Technology

DECLARATION

We do solemnly declare that the report submitted, in the partial fulfillment for the MBA of Bangladesh International University of Business, Agriculture & Technology, is the result of my own research work and written in my own language.

Name: TAHSIN KABIR,
ID : 11304038,
Department: MBA (semester: 4th).

ACKNOWLEDGEMENT

First of all we give thanks to the Almighty Allah and we articulate our earnest for giving us the scope & capacity to complete the assigned task within the scheduled time more efficiently. Certainly I should acknowledge the contribution of our teacher whose teaching has become the part of our thinking process. I would like to thank our honorable teacher Md. Hasibur Rashid Chayon for his valuable advice and guideline to prepare this report. This report reflects my best efforts. I have tried my best to complete it properly within my knowledge.

Acknowledged by

Name: TAHSIN KABIR
ID: 11304038
MBA (Semester-4th) .

IUBAT: International University of Business Agriculture and Technology

Table of Content 1. Chapter 1- Online Shopping

2. Chapter 2-Data Flow Diagram

3. Chapter-3 Entity Relationship (ER) Diagram

4. Chapter 4- SQL code

Chapter 1- Online Shopping
Online shopping or online retailing is a form of electronic commerce whereby consumers directly buy goods or services from a seller over the Internet without an intermediary service. An online shop, e-shop, e-store, Internet shop, web-shop, web-store, online store, or virtual store evokes the physical analogy of buying products or services at a bricks-and-mortar retailer or shopping center. The process is called business-to-consumer (B2C) online shopping. When a business buys from another business it is called business-to-business (B2B) online shopping. The largest online retailing corporations are E-Bay and Amazon.com, both of which are US-based.
History of Online Shopping
In 1990 Tim Berners-Lee created the first World Wide Web server and browser.[1] It opened for commercial use in 1991. In 1994 other advances took place, such as online banking and the opening of an online pizza shop by Pizza Hut.[1] During that same year, Netscape introduced SSL encryption of data transferred online, which has become essential for secure online shopping. Also in 1994 the German company Intershop introduced its first online shopping system. In 1995 Amazon.com launched its online shopping site, and in 1996 eBay appeared.[1]
Customers
Online customers must have access to a computer and a method of payment. In general, higher levels of education, income, and occupation of the head of the household correspond to more favorable perceptions of shopping online. Also, increased exposure to technology increases the probability of developing favorable attitudes towards new shopping channels.[2]
In a December 2011 study Equation Research found that 87% of tablet users made an online transaction with their tablet device during the early holiday shopping season.[3]
Logistics
Consumers find a product of interest by visiting the website of the retailer directly or by searching among alternative vendors using a shopping search engine. Once a particular product has been found on the web site of the seller, most online retailers use shopping cart software to allow the consumer to accumulate multiple items and to adjust quantities, like filling a physical shopping cart or basket in a conventional store. A "checkout" process follows (continuing the physical-store analogy) in which payment and delivery information is collected, if necessary. Some stores allow consumers to sign up for a permanent online account so that some or all of this information only needs to be entered once. The consumer often receives an e-mail confirmation once the transaction is complete. Less sophisticated stores may rely on consumers to phone or e-mail their orders (though credit card numbers are not accepted by e-mail, for security reasons).

Payment
Online shoppers commonly use a credit card to make payments, however some systems enable users to create accounts and pay by alternative means, such as: * Billing to mobile phones and landlines[4][5] * Cash on delivery (C.O.D., offered by very few online stores) * Cheque / Check * Debit card * Direct debit in some countries * Electronic money of various types * Gift cards * Postal money order * Wire transfer/delivery on payment * Invoice, especially popular in some markets/countries, such as Switzerland
Product delivery
Once a payment has been accepted the goods or services can be delivered in the following ways. * Downloading: This is the method often used for digital media products such as software, music, movies, or images. * Drop shipping: The order is passed to the manufacturer or third-party distributor, who ships the item directly to the consumer, bypassing the retailer's physical location to save time, money, and space. * In-store pickup: The customer orders online, finds a local store using locator software and picks the product up at the closest store. This is the method often used in the bricks and clicks business model. * Printing out, provision of a code for, or emailing of such items as admission tickets and scrip (e.g., gift certificates and coupons). The tickets, codes, or coupons may be redeemed at the appropriate physical or online premises and their content reviewed to verify their eligility (e.g., assurances that the right of admission or use is redeemed at the correct time and place, for the correct dollar amount, and for the correct number of uses). * Shipping: The product is shipped to the customer's address or that of a customer-designated third party. * Will call, lCOBO (in Care Of Box Office), or "at the door" pickup: The patron picks up pre-purchased tickets for an event, such as a play, sporting event, or concert, either just before the event or in advance. With the onset of the Internet and e-commerce sites, which allow customers to buy tickets online, the popularity of this service has increased.
Online shopping
Like many online auction websites, many websites allow small businesses to create and maintain online shops (ecommerce online shopping carts), without the complexity that involved in purchasing and developing an expensive stand alone ecommerce software solutions.
User Interface:

An automated online assistant, with potential to enhance user interface on shopping sites. The most important factors determining whether customers return to a site are ease of use and the presence of user-friendly features.[15] Usability testing is important for finding problems and improvements in a web site. Methods for evaluating usability include heuristic evaluation, cognitive walk through, and user testing. Each technique has its own characteristics and emphasizes different aspects of the user experience.[15]
Advantages
Online stores are usually available 24 hours a day, and many consumers have Internet access both at work and at home. Other establishments such as internet cafes and schools provide access as well. A visit to a conventional retail store requires travel and must take place during business hours.
In the event of a problem with the item it is not what the consumer ordered, or it is not what they expected—consumers are concerned with the ease with which they can return an item for the correct one or for a refund. Consumers may need to contact the retailer, visit the post office and pay return shipping, and then wait for a replacement or refund. Some online companies have more generous return policies to compensate for the traditional advantage of physical stores.
Information and reviews
Online stores must describe products for sale with text, photos, and multimedia files, whereas in a physical retail store, the actual product and the manufacturer's packaging will be available for direct inspection (which might involve a test drive, fitting, or other experimentation).
Some stores even allow customers to comment or rate their items. There are also dedicated review sites that host user reviews for different products. Reviews and now blogs gives customers the option of shopping cheaper organise purchases from all over the world without having to depend on local retailers.
Price and selection
One advantage of shopping online is being able to quickly seek out deals for items or services with many different vendors (though some local search engines do exist to help consumers locate products for sale in nearby stores). Search engines, online price comparison services and discovery shopping engines can be used to look up sellers of a particular product or service.
Shipping costs (if applicable) reduce the price advantage of online merchandise, though depending on the jurisdiction, a lack of sales tax may compensate for this.
Another major advantage for retailers is the ability to rapidly switch suppliers and vendors without disrupting users' shopping experience.
Disadvantages
Fraud and security concerns
Given the lack of ability to inspect merchandise before purchase, consumers are at higher risk of fraud on the part of the merchant than in a physical store. Merchants also risk fraudulent purchases using stolen credit cards or fraudulent repudiation of the online purchase. With a warehouse instead of a retail storefront, merchants face less risk from physical theft.
Privacy
Privacy of personal information is a significant issue for some consumers. Different legal jurisdictions have different laws concerning consumer privacy, and different levels of enforcement. Many consumers wish to avoid spam and telemarketing which could result from supplying contact information to an online merchant. In response, many merchants promise not to use consumer information for these purposes, or provide a mechanism to opt-out of such contacts.

Chapter-2 Data Flow Diagram

Fig: Data Flow Diagram of Online shopping

Chapter-3 Entity Relationship (ER) Diagram of Online shopping

Category_id
Foreign Key
Primary Key

Supplied by
Select
Detail
Payment_id
Payment_type allowed shipper_id
Company_name
phone
Billing_address
phone
Ship_address
country firstname Customer_id password lastname email
Order_number
Orderdetail_id
Product_id
quantity price Order_id
Product_name
description picture Category_name

Category_id unitprice quantity
Product_id
description
Shippers
orders payments category Product customers orderdetails

address

Fig: Entity Relationship (ER) Diagram of Online shopping
Chapter 4- SQL code
Create database onlineshop;
---Category Insert---
CREATE TABLE category ( `categoryid` int(11) NOT NULL auto_increment, `categoru_name` varchar(123) NOT NULL, `description` varchar(223) NOT NULL, `picture` varchar(225) NOT NULL, `active` varchar(111) NOT NULL, PRIMARY KEY (`categoryid`)
);
--
-- Dumping data for table `category`
--
INSERT INTO category (`categoryid`, `categoru_name`, `description`, `picture`, `active`) VALUES
(1, 'Book', 'All Kinds of book', 'book.jpg', 'yes');
--
-- Table structure for table `customer`
--
CREATE TABLE customer ( `customer_id` int(11) NOT NULL auto_increment, `firstname` varchar(100) NOT NULL, `lastname` varchar(100) NOT NULL, `gender` varchar(11) NOT NULL, `email` varchar(123) NOT NULL, `password` varchar(123) NOT NULL, `address1` varchar(123) NOT NULL, `address2` varchar(123) NOT NULL, `country` varchar(123) NOT NULL, `phone` varchar(111) NOT NULL, `creditcard_name` varchar(111) NOT NULL, `cardtypeid` varchar(111) NOT NULL, `cardexpmo` varchar(34) NOT NULL, `cardexpyo` varchar(34) NOT NULL, `billing_address` varchar(123) NOT NULL, `billing_city` varchar(122) NOT NULL, `billing_region` varchar(123) NOT NULL, `billing_postcode` varchar(50) NOT NULL, `billing_country` varchar(100) NOT NULL, `ship_address` varchar(123) NOT NULL, `shi_country` varchar(100) NOT NULL, `ship_city` varchar(100) NOT NULL, `ship_region` varchar(100) NOT NULL, `ship_postcode` varchar(111) NOT NULL, `dateentered` datetime NOT NULL, PRIMARY KEY (`customer_id`));
--
-- Dumping data for table `customer`
--
INSERT INTO customer (`customer_id`, `firstname`, `lastname`, `gender`, `email`, `password`, `address1`, `address2`, `country`, `phone`, `creditcard_name`, `cardtypeid`, `cardexpmo`, `cardexpyo`, `billing_address`, `billing_city`, `billing_region`, `billing_postcode`, `billing_country`, `ship_address`, `shi_country`, `ship_city`, `ship_region`, `ship_postcode`, `dateentered`) VALUES
(1, 'Evana', 'Yasmin', 'Female', '[e-mail]', 'evana123', 'Dhaka', 'Dhaka', 'Bangladesh', '01911718922', 'Visa', '111', 'December', '2015', 'Dhaka', 'Dhaka', 'Dhaka', '1213', 'Bangladesh', 'Dhaka', 'Bangladesh', 'Dhaka', 'Dhaka', '1213', '2012-11-24 21:49:56');
--
-- Table structure for table `orderdetails`
--
CREATE TABLE orderdetails ( `order_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `ordernumber` varchar(123) NOT NULL, `price` double NOT NULL, `quantity` int(11) NOT NULL, `discount` varchar(12) NOT NULL, `total` decimal(10,0) NOT NULL, `size` varchar(22) NOT NULL, `color` varchar(55) NOT NULL, `ship_date` date NOT NULL, `orderdetail_id` int(11) NOT NULL auto_increment, `bill_date` date NOT NULL, `fullfilled` varchar(5) NOT NULL, PRIMARY KEY (`orderdetail_id`), KEY `order_id` (`order_id`), KEY `product_id` (`product_id`)
) ;
INSERT INTO category('categoryid' ,'categoru_name','description','picture','active')
VALUES (NULL , 'Book', 'All Kinds of book', 'book.jpg', 'yes');
----Category update---- update category set category_name='Book' where category_id=1;
---Category Delete--- delete from category where category_id=1;
---Product Insert---
Insert into
Product ('product_id','product_name','product_description','category_id','quantity','unitprice',
'avalilable_size','availablecolors','size','colors','discount','unit_weight','picture','note')
VALUES (NULL , 'Novel', 'Novel of Bangladesh', '1', '23', '105', 'x', 'all colors', 'x', 'green', 'no', '1/2 kg.', 'book1.jpg', 'It''s a nice novel');
---Product update--- update product set product_name='Novel' where product_id=1;
---Product Delete--- delete from Product where Product_id=1;
CREATE TABLE customer (
`customer_id` int(11) NOT NULL auto_increment, `firstname` varchar(100) NOT NULL, `lastname` varchar(100) NOT NULL, `gender` varchar(11) NOT NULL, `email` varchar(123) NOT NULL, `password` varchar(123) NOT NULL, `address1` varchar(123) NOT NULL, `address2` varchar(123) NOT NULL, `country` varchar(123) NOT NULL, `phone` varchar(111) NOT NULL, `creditcard_name` varchar(111) NOT NULL, `cardtypeid` varchar(111) NOT NULL, `cardexpmo` varchar(34) NOT NULL, `cardexpyo` varchar(34) NOT NULL, `billing_address` varchar(123) NOT NULL, `billing_city` varchar(122) NOT NULL, `billing_region` varchar(123) NOT NULL, `billing_postcode` varchar(50) NOT NULL, `billing_country` varchar(100) NOT NULL, `ship_address` varchar(123) NOT NULL, `shi_country` varchar(100) NOT NULL, `ship_city` varchar(100) NOT NULL, `ship_region` varchar(100) NOT NULL, `ship_postcode` varchar(111) NOT NULL, `dateentered` datetime NOT NULL, PRIMARY KEY (`customer_id`)
);
---Customer Insert---
INSERT INTO `onlineshop`.`customer` (`customer_id` ,`firstname` ,`lastname` ,`gender` ,`email` ,`password` ,`address1` ,
`address2` ,`country` ,`phone` ,`creditcard_name` ,`cardtypeid` ,`cardexpmo` ,`cardexpyo` ,`billing_address` ,`billing_city` ,
`billing_region` ,`billing_postcode` ,`billing_country` ,`ship_address` ,`shi_country` ,`ship_city` ,`ship_region` ,`ship_postcode` ,
`dateentered`
)
VALUES (
NULL , 'Evana', 'Yasmin', 'Female', '[e-mail]', 'evana123', 'Dhaka', 'Dhaka', 'Bangladesh', '01911718922', 'Visa', '111', 'December', '2015', 'Dhaka', 'Dhaka', 'Dhaka', '1213', 'Bangladesh', 'Dhaka', 'Bangladesh', 'Dhaka', 'Dhaka', '1213', '2012-11-24 21:49:56'
);
---Customer update--- update customer set firstname='Evana' where customer_id=1;
---Customer Delete--- delete from Customer where customer_id=1;

INSERT INTO `onlineshop`.`orders` (`order_id` ,`customer_id` ,`ordernumber` ,`payment_id` ,
`require_date` ,`ship_date` ,`shiper_id` ,`paid_status` ,`payment_date` ,`paid` ,`fullfilled`)
VALUES (NULL , '1', '1213', '1', '2012-11-28', '2012-11-27', '1', '1', '2012-11-24', 'yes', 'yes');
---order update--- update order set address='Dhaka' where order_id=1;
---order Delete--- delete from order where order_id=1;
INSERT INTO `onlineshop`.`shippers` (`shipper_id` ,`company_name` ,`phone`)
VALUES (NULL , 'ABC', '02-993222');
---shippers update--- update shippers set phone='02-123211' where shipper_id=1;
---shippers Delete--- delete from shippers where shipper_id=1;
INSERT INTO `onlineshop`.`payment` (
`payment_id` ,`payment_type` ,`allowed`)
VALUES (NULL , 'Master Card', 'Yes'); update payment set payment_type='Master Card' where payment_id=1;
---payment Delete--- delete from payment where payment_id=1;
-----------------------------------------------------