Project 2

a. PROPERTIER NON PROPERTIER

Creating personal infarmation

Uses

collecting personal infarmation

STORING USES

Proccessing personal infarmation Mining

storing Uses

Collecting personal infarmation

Disclosing personal infarmation

b. TYPES OF CUSTOMER

NORMAL MEMBER PREMIUM MEMBER

c. <button

data-item-id="yellow- sticker"

data-item-price="1.99"

data-item-name="stickers size"

Add to cart

</ button>

d. business to business (websites such as shopify)

business to consumer( websites such as amazon)

consumer to consumer (websites such as e bay)

e. B2B(BUSINESS TO BUSINESS)

B2C(BUSINESS TO CONSUMER)

C2C(CONSUMER TO CONSUMER)

C2A(CONSUMER TO ADMINISTRATION)

B2A(BUSINESS TO ADMINISTRATION)

f. HEAD TAG

TITLE TAG

BODY TAG

PARAGRAPH TAG

HEADING TAG

g. CREDIT CARD DEBIT CARD SMART CARRD E -WALLET MOBILE BANKING NET BANKING AMAZON PAY

h. MULTIPLE CATEGORIES SEGMENTS TAGS

i. SELLERS ORDERS

j. SHIPPING DETAILS BILLING INFARMATION

1. SELECT AVG (purch_amt)

FROM orders;

2.CREATE TABLE customer_order_details(

customer_id VARCHAR(20),

Customer_name VARCHAR(20),

order_id VARCHAR(20),

order_price INT)

3. SELECT ord _date, SUM (purch_amt)

FROM orders a

GROUP BY ord_date

HAVING SUM (purch_amt)>

(SELECT 1000.00+MAX( Purch_amt)

FROM orders b

WHERE a.ord_date=b.ord_date);

4. SELECT COUNT(*)

FROM customer;

5. SELECT salesman_id,name

FROM salesman a

WHERE 1<

(SELECT COUNT(*)

FROM customer

WHERE salesman_id=a.salesman_id);

K 1. E COMMERCE DATA BASE INFARMATION SAMPLE INFARMATION