Chapter 14 Flashcards

1
Q

How does the world wide web allow businesses to communicate with customers

A
Advertising
Follow-Up Sales
Sales to consumers
Sales to other businesses
Non-Sales Transactions (statements and bill pay)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is ecommerce?

A

business conducted with the Internet and via the web including sales, advertising, and bill pay options

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Is setting up an ecommerce site difficult?

A

Setting up an organization for ecommerce can be as intensive as setting up a physical store front.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are some business problems that could be solved with an ecommerce site?

A

Broadening the customer base
Recapturing customers lost to online competitors
Serving existing customers better
Integrating departments of existing business

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are some of the risks of moving online in ecommerce

A

Same customers moving from in-store to online
Facing new competition online
Existing customers don’t need/want online store
Employee concerns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are some of the costs of moving online using ecommerce

A

Computer equipment and infrastructure
Hiring personnel to manage the website
Legal expertise required to protect your intellectual property, regulations online, and customer privacy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are some of the decisions that need to be made in terms of ecommerce

A

Design website in-house or hire an ASP (Application Service Provider)

Buy or lease equipment

Use existing software or have custom software written

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Give a general overview of how an order is placed (and what your responsibilities are in that cycle as the website owner) starting from the point of the customer discovering your site to the point of sale

A

Customer learns of your site and goes there
Identify return customers and personalize the site
Provide a secure environment for making purchase
Process the payment
Communicate with accounting and credit company

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How do you fulfill orders?

A

Update inventory
Contact shipping system and shipping company
Arrange pick up and delivery to customer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the 9 steps to a typical online transaction

A
  1. Customer goes on Internet to your website
  2. Customer logs into a database management system
  3. Customer goes into the online order entry system
  4. Customer goes into the accounting system
  5. Credit card is verified
  6. Inventory is checked to make sure there is enough stock
  7. Customer goes into the shipping system
  8. Item goes from the shipping system to the shipper
  9. Item goes from the shipper to the customer
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are some ways that customers learn about your site?

A
  • Conventional print advertising with URL
  • An obvious domain name (home page URL)
  • Search engine results (sponsored link)
  • Presence on a portal (website about a topic) with links to retail, wholesale, and informational websites
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is a domain name?

A

home page URL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What corporation registers domain names?

A

ICANN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does ICANN stand for

A

Internet corporation for assigned names and numbers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is a portal?

A

A website about a topic

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are two efficient ways to identify return customers and personalize the site for them?

A
  • Require the user to register and log in

* Leave a cookie on the users computer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Why should we require the user of an ecommerce site to register and log in

A

To connect to the database with the user’s past history on the site

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is a cookie

A

A cookie is a small text file containing information about the user.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Why do we leave cookies on a user’s computer

A

To allow continuity between one page of a site and another

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

How do we provide a secure environment for making a purchase

A

Encryption and Authentication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is the role of encryption in ecommerce

A

ensure sensitive information is encrypted for transmission

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is the role of authentication in ecommerce

A

verify that your website is legitimate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What are two payment processing options

A

1: Process payment while the customer waits
2: Record order and payment info and complete transaction offline and then email customer the confirmation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Explain payment processing option 1: while the customer waits

A
  • Online form communicates with accounting software
  • Accounting system verifies customer credit
  • Customer can correct bad information
  • No need to keep credit card numbers
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Explain payment processing option 2: Offline payment processing
* Record the order and payment information * Verify and complete the transaction offline * Send email confirmation to the customer
26
What are the three steps to order fulfillment once the customer has placed an order
* Communication with online inventory * Arrange for Shipping * Arrange Pick-up at the warehouse and delivery to the customer
27
What are some overall website design principals
* Attractive with new products displayed * Good design principles * Organize for natural shopping habits * Make it easy to navigate * Provide site map or navigation bar * No more than four clicks from one page to another * Encourage browsing and targeted searching * Ensure the site works on different platforms and browsers
28
What should be provided on an ecommerce website to facilitate purchase
Electronic Shopping Carts
29
What are some very important consideration in regards to checkout steps
* Always show details of order * Clearly indicate what the next button click does * Allow the customer to go back and change things * Give the customer shipping options * Provide email with order information and shipping confirmation
30
What are other pieces of information that should be included in website design
* FAQ page and link to customer service * Entries allowed for customer reviews or forums * News and press releases * Links to your social media sites
31
What is legacy code
Existing old software still in use
32
What is middleware
Software to enable separate systems to communicate
33
What is disaster recovery strategy
Response to natural disasters, equipment failures or being hacked
34
What are the types of software systems that have to work in conjunction together in ecommerce
* Website, accounting, inventory, and shipping * Suppliers, orders, and billing * Personnel
35
What is the e-bay ecommerce model
Peer-to-peer auction style sales
36
What is the craigslist ecommerce model
Peer-to-peer classified ads
37
What is the groupon ecommerce model
* Group coupons. * Businesses post coupons for one day only * Minimum number required
38
What is the PayPal ecommerce model
online payment service
39
What is the apple pay ecommerce model
Mobile payment system
40
What is the bitcoin ecommerce model
virtual currency
41
What do databases store
Large amounts of data
42
What do businesses require databases for
Inventory, personnel, customers, suppliers, and financials
43
What is a bit/byte
Basic pieces of computer data
44
What is a field
One meaningful piece of information
45
What is a record
A set of related fields
46
What is a data file
a set of related records
47
What is a database
A set of related data files
48
How are data files represented in a database
Data files are represented as tables
49
How are records represented in a database
Rows
50
How are fields represented in a database
Columns
51
What is a Database management system
Manages files in a database
52
What does DBMS stand for
Database management system
53
What is a relational database model
Files are 2D tables
54
What is an entity in a relational database model
A distinguishable component of a system
55
What is a tuple in a relational database model
A row of relational tables
56
What is an attribute in a relational database model
A category of a field
57
What is a primary key in a relational database model
Attribute that uniquely identifies a tuple
58
What is SQL
Standard query language for a DBMS
59
What are SQL queries used for
Used to retrieve data according to some criteria
60
What is a foreign key?
An attribute in one table that is the key in the other
61
What is a foreign key used for
It connects data in one table with another
62
What is a "project" in relation to relational database operations
Picking some attributes from a set of tuples
63
What is a "restrict" in relation to relational database operations
Pick tuples that meet criteria
64
What is a "join" in relation to relationatal database operations
Combine tuples from different tables
65
What are three major components for database integrity
Entity integrity Data integrity Referential integrity
66
What is entity integrity in relation to databases
No primary key can be missing
67
What is data integrity in relation to databases
Values must match category constraints (ie: valid pay rate)
68
What is referential integrity in relation to databases
Foreign keys must match a primary key value in the related table
69
Describe efficiency in a database
* Disk access is slow | * File management systems can organize disk files for faster access
70
What is a distributed database
Data stored across a computer network
71
What is big data
Huge amounts of available data
72
What is data analysis
Process of finding the right data sets, putting data in the right format, and writing queries to extract information
73
What is data science
Incorporates data analysis tasks, but requires knowledge of the enterprise for useful queries and the use of statistics and visualization techniques to interpret the results and predict future strategies to achieve a predetermined goal
74
What is a data warehouse
A collection of databases that contain current and archived data for research and analysis
75
What is data mining?
Process of analyzing data to extract and interpret previously hidden patterns through several steps:
76
What are the 4 steps to data mining
1. Determine the problem to be solved 2. Review the condition of the data: Does all data have the same structure? Are any tuples missing information? 3. Determine a model that will help bring out the patterns: Patterns classify the data to determine the strongest predictors of a given outcome – this is the data mining part: creation of a model 4. Evaluate your model: Are the results predicted borne out by further data? Would a different model give better results?
77
What are some data science tools
Decision tree Statistical Analysis Graphical Visualization
78
What language can help with databases/data science
Language R
79
What are some privacy issues associated with data mining?
Automatically analyzing large amounts of data to uncover hidden patterns
80
What are data brokers
companies that collect and sell data
81
What are some examples of data sold by data brokers
Birth certificates, marriage certificates, publically available information, and nonpublic data purchased or acquired from other companies or data brokers.
82
What can data science make contributions towards
Medicine, science, ecology, and many more fields